Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Calculating % off different categories in a column

Hi,

I have one column called Rank. I have values in this columns like "Agree", "Disagree", "NA". I can have one bar chart with no. of occurrence of  "Agree", "Disagree", "NA". I take "Rank" column as dimension and Count(Rank) as measure.

But I want to get % of each  "Agree", "Disagree", "NA" in same manner instead only counts. I can do it in pie chart but I need it on bar graph. Can anybody help please help, I need it urgently. Many thanks

1 Solution

Accepted Solutions
TKendrick20
Valued Contributor

Re: Calculating % off different categories in a column

Hey, analyzing survey data is my specialty!

Should be as simple as Count([Rank]) / Count(TOTAL [Rank])

This will return a percentage for you. Multiply by 100 if you wish.

3 Replies
TKendrick20
Valued Contributor

Re: Calculating % off different categories in a column

Hey, analyzing survey data is my specialty!

Should be as simple as Count([Rank]) / Count(TOTAL [Rank])

This will return a percentage for you. Multiply by 100 if you wish.

Not applicable

Re: Calculating % off different categories in a column

Thanks, its great. Could you please tell me how can I combine e.g "Disagree" and "NA" and display as one dimension Like "DisagreeAndNA" . Thanks

TKendrick20
Valued Contributor

Re: Calculating % off different categories in a column

You could do that in your load script with an IF statement or a CASE statement if you are loading from SQL.

Or as your dimension you could put:

IF(MATCH([Rank],'Disagree','NA'),'Disagree and NA', [Rank])

Community Browser