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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
danboh_qsen
Contributor II
Contributor II

Percentage by Column by Dimension

Hello,

I just started working with Qlik Sense and have been experimenting with some dashboards and calculations. The most recent one is to show the percentage for a column for a dimension.

Here's what I have:

Capture.PNG

And this is roughly what I'd like to get:

Capture2.PNG

I can get to the point of getting the total for each dimension, but it's totaled for all months, and not for each individual month, using 

COUNT(TOTAL <dimension> distinct(id))

Capture3.PNG

Any thoughts?

Thanks in advance!

 

Labels (1)
10 Replies
danboh_qsen
Contributor II
Contributor II
Author

Great to know. I will keep this in mind going forward.

Thank you again, good sir.