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: 
Sri251
Contributor II
Contributor II

Convert Multiple Measures into categorized Dimension

Hi Everyone,

I need your inputs:

I am in a situation to convert 4 measures into dimension like a category

For example: My measures are Male Patients Count, Female Patients Count, Asian Male Patients Count, Asian Female Patients count.

Basically I need to create a pie chart based on the above mentioned measures and i need to place all the above mentioned measures into a single dimension like a category and i need to use this category as a dimension in the pie chart, so when i create a pie chart it will give their individual distribution.

Appreciate if someone can advice me the best approach!

 

TIA,
Sri

Labels (1)
1 Solution

Accepted Solutions
Sri251
Contributor II
Contributor II
Author

I got the solution: I have created a calculated dimension with the help of value list for the above mentioned measures and also used the pick match function in the measure section to calculate the % share in the pie chart.

 

Hope it will be helpful for someone!

View solution in original post

1 Reply
Sri251
Contributor II
Contributor II
Author

I got the solution: I have created a calculated dimension with the help of value list for the above mentioned measures and also used the pick match function in the measure section to calculate the % share in the pie chart.

 

Hope it will be helpful for someone!