Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Table with the YTD of each of the last 6 days

Hi to everyone!

I need to make a table where it is shown the YTD of Today AND the last 6 days. Something like this (if today it's May 20th):

DayYTD 2008YTD 2009YTD 2010
14/05/1037119,3005839264,685638609,41248
15/05/1037241,1106740060,6485839130,12005
16/05/1038099,8027640724,0034739717,98139
17/05/1038969,270840981,2921639717,8849
18/05/1039607,4329540975,4904640016,3969
19/05/1039749,9028741220,6416640585,95065
20/05/1040153,9854843109,2508640585,95065

I think it's a strange measure but... Does anyone how it could be done?

Thanks in advance for your time and dedication! And have a nice day!

Josep

1 Reply
Not applicable

Table with the YTD of each of the last 6 days

Hi

If you always select a single date you could run a macro to extend the selection to include the previous 5 days.

Depending on the amount of data it might however be easier using the AsOfDate approach mentioned in other threads. With this you 6 fold your data in the load and have for each selected date the 6 records available for display.

Regards

Juerg

Community Browser