Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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.