topic Re: as on date in QlikView

as on date

Wed, 09 Jan 2013 04:11:39 GMT

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

Re: as on date

khadeer — Wed, 09 Jan 2013 05:05:21 GMT

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.

Re: as on date

Wed, 09 Jan 2013 13:09:07 GMT

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

Re: as on date

khadeer — Thu, 10 Jan 2013 03:43:44 GMT

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

Re: as on date

Thu, 10 Jan 2013 04:03:59 GMT

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

Re: as on date

Thu, 10 Jan 2013 04:04:30 GMT

if u want i will send u sample data

Re: as on date

khadeer — Thu, 10 Jan 2013 04:20:34 GMT

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