topic As on calculation in QlikView

As on calculation

Thu, 10 May 2012 06:10:42 GMT

hey all

i am making a report in a straight table.In which i have taken date as dimension. And i am calculating count of id's which are active as expression.

i am getting the active id's as per the date against them. But actually i want active id as on the date in dimension field. so can someone provide some way to calculate the active id's, as on the date comming in my chart..thanks..

As on calculation

Thu, 10 May 2012 07:29:16 GMT

can any one provide some idea on this.

As on calculation

varunpbhandary — Thu, 10 May 2012 09:34:11 GMT

Hi ronny123,

If I understand your requirement correctly you basically want to sum the previous date count of active ID's to calculate the as on date values. You can do this by using inter record functions like above etc in the front end or Peek or previous if you want to calculate it in the scripting level.

Cheers!

Varun Bhandary