Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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

 

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