Discussion Board for collaboration related to QlikView App Development.
Hi Friends ,
I have a situation , i need to show count of ID's for current year with summation of old months records also , means running sum.
I have tried accumulation but when i select some year or month then it show only for that month count , but i want to show count from start date.
yes but , count is not coming from start date , if i select 2017 then Jan 2017 count should show from 1992 to 2017 Jan , similarly for 2017 Feb , count should show from 1992 to 2017 Feb.
The AsOf table should still show the correct cumulative value when you select a month. You need to use the AsOfMonth field as dimension, and also adapt your set analysis accordingly.