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: 
supriyabiware
Creator
Creator

Cumulative % For stacked Bar Chart

supriyabiware_0-1611834989147.png

 

Hi All 

 

I have a chart with stacked % and formula is as below.

 

=Count(Distinct %Account_ID)/count(total <MonthYear> %Account_ID)

 

 

Now i need to show the cumulative increase in % of the stacked dimension?

 

How can i do it?

 

Thanks & Regards,

Supriya

 

Labels (1)
3 Replies
supriyabiware
Creator
Creator
Author

supriyabiware_0-1611835372484.png

 

Should look something like this

Seyko
Partner - Creator
Partner - Creator

Hi Supriyabiware,

Can you attach some sample data?

Regards

Excuse my english, i'm french!
supriyabiware
Creator
Creator
Author

Hello, here is a sample data in excel format. i just need the shown output in Qliksense. Currently i can show cumulative of whole numbers , but 100% stack cumulation is where i am stuck