QlikView for Developers Cookbook

Using VBS functions in charts

999 times out of 1000, we can do everything that we need to do using the embedded QlikView functions. There is just that one in a thousand awkward times, where there is a calculation that is just not calculable by combining those functions.

In this recipe we will examine the Days360 function. This function calculates the number of days between two dates based on a 360 day year, that is, 30 days per whole month. There is a slightly different calculation between Europe and the U.S., so we will take that into account.

Getting ready

We don't need a special QlikView document here. Any document will do.

How to do it…

These steps show you how to use a VBS function in a chart:

1. From the Tools menu, select Edit Module….
2. Enter the ...