Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
agni_gold
Specialist III
Specialist III

cumulative count for each year month since start date

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.

Please help

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.

19 Replies
MK_QSL
MVP
MVP

What is the object you are using? Straight Table, Pivot table or Bar Chart.

Can you provide some sample data or sample app to work?

agni_gold
Specialist III
Specialist III
Author

Bar chart and Straight table both

MK_QSL
MVP
MVP

Can you provide some sample data or sample app to work?

agni_gold
Specialist III
Specialist III
Author

ok

agni_gold
Specialist III
Specialist III
Author

here it is

swuehl
MVP
MVP

Have you considered using an AsOf table approach?

The As-Of Table

agni_gold
Specialist III
Specialist III
Author

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.

swuehl
MVP
MVP

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.

agni_gold
Specialist III
Specialist III
Author

Could you please help here , attaching file