Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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