topic Date in QlikView

Date

Thu, 05 Apr 2012 10:55:48 GMT

How do I get last 10 days dates in the list box or a straight table chart.

Please help.

Thanks

Thu, 05 Apr 2012 11:37:59 GMT

hi,

Take a List box

put expression as: ValueLoop(Today()-9,Today())

go to Number tab and change the format to Date

you will get the last 10 days from current date.

Thu, 05 Apr 2012 11:57:54 GMT

Hi,

You can use this script.

LET varMinDate = Num(Today()-9);

LET varMaxDate = num(today());

Calendar:

Load

$(varMinDate)+IterNo()-1 AS Num,

Date($(varMinDate)+IterNo()-1) AS Date

AUTOGENERATE 1 WHILE $(varMinDate)+IterNo()-1<= $(varMaxDate);

Regards,

Kush

v_iyyappan — Thu, 05 Apr 2012 12:00:00 GMT

Hi,

I attached a sample QV application.

Hope its helpful for u..

Thanks,

Iyyappan