topic calculation in script in QlikView

calculation in script

Fri, 17 Jun 2011 10:20:10 GMT

Hi,

In the script i have 'date of joining' and 'date of seperation', can i calculate the 'vintage' in the script itself?

Regards,

Rahul

kaushiknsolanki — Fri, 17 Jun 2011 10:25:11 GMT

Hi,

You can use Interval() and Interval#() function for that.

Look into Help for more details.

Hope this will help you.

Regards,

Kaushik Solanki

erichshiino — Fri, 17 Jun 2011 10:56:04 GMT

I am not sure how you calculate it (the expression for it) but you could create any field as an operation of other fields, during reload...

For example, if your code is similar to this:

load ID, Joining_Date, Separation_Date from....

You can create something like this:

Load ID,Joining_Date, Separation_Date, Separation_Date- Joining_Date as Duration from...

(that gives you the difference in days)

Hope this helps,

Erich

Fri, 17 Jun 2011 11:08:37 GMT

to slightly modify Erichs answer

if(isnull(Separation_Date),today(),Separation_Date)-Joining_Date

if there is no separation date then use todays date.

in days.

Fri, 17 Jun 2011 11:12:18 GMT

Erich,

thanks for the reply... it worked

Thanks