as on date

[#1]

Hai Community,

I HAVE fOLOWING ISSUE

THAT TO  WHAT IS MEANT BY AS ON DATE REPORT   AND FOR THE PERIOD  IN QLIKVIEW CAN ANYONE

SUGGEST ME HOW WE WIIL CALCULATE WITH SMALL EXAMPLE

REARLLY IT HELPS ME LOT

[khadeer · Accepted solution]

As On Date means.... suppose u have 4 years 2010,2011,2012 & 2013. so if the user checking on today it will show the total amount until today from starting means(2010-01-01----2013-01-09)

for the period means .... year wise, quarter wise, month wise, week wise.....

hope it will help u.

[#3]

Hai,,

I got That point

same the way last 5 rolling yrs as on date value

last five qrts as on date value

and last 8 months as on date value

[khadeer]

Last 5 rolling years means from last 5 years to untill selected date.

in the same way quarter n months also.

Hope it helps u

[#5]

by default last five years

like 2009 2010 2011 2012 2013

that i done

but same the way i want last eight months that to cummulative value

for example

currnt month value 12000cr

last month               10000 cr

same the way i want rolling last 8 months

current year last 8 months  ,may jun,july,aug,sep,oct,nov,dec

but if u click prev year it has full months so it will show

from                          aug,sep,oct,vov,dec,jan,feb,mar     

[#6]

if u want i will send u sample data

[khadeer]

I am attaching rolling last 12 months example, it will help u.