topic New calculated time field in QlikView

New calculated time field

gerhardl — Thu, 14 Apr 2011 15:48:46 GMT

Hi,

I am loading a table with the following two fields:

I would like to create an additional field called "Days since last movement".

This must look at whatever is the latest date of the two above-mentioned fields, and then subtract that from TODAY's date.

Example:

Possible?

Gerhard

IAMDV — Thu, 14 Apr 2011 16:03:19 GMT

Create two variables...

vMaxLastPayment = Max({1} [Date of last payment])

vMaxLastPurchase = Max({1} [Date of last purchase])

Then use Max fucntion with the variables like this...

=Today() - Max($(vMaxLastPayment) , $(vMaxLastPurchase))

Thu, 14 Apr 2011 16:06:40 GMT

try this

load date2, date3, if(date2>date3, interval(date(today())- date(date2),'DD'), interval(date(today())- date(date3),'DD')) as movement

erichshiino — Thu, 14 Apr 2011 18:28:51 GMT

Try something like this:

Load *,

today()-if(LastPayment>LastPurchase,LastPayment,LastPurchase) as DaysLastMovement

resident table;

Regards,

Erich

rwunderlich — Thu, 14 Apr 2011 18:37:11 GMT

today(1)-RangeMax(LastPurchase,LastPayment) as DaysLastMovement