Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Combining Responses from One field

Hi,

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

How can I combine  e.g "Disagree" and "NA" and display as one dimension Like "DisagreeAndNA" with % of total of them and Disagree as other dimension. Thanks

   

4 Replies

Re: Combining Responses from One field

You can create a new field in the script

LOAD Rank,

     If(Match(Rank, 'Disagree', 'NA'), 'DisagreeAndNA', Rank) as CombinedRank

FROM ....

And then use CombinedRank

Or use this as your calculated dimension

If(Match(Rank, 'Disagree', 'NA'), 'DisagreeAndNA', Rank)

khan_fayez
New Contributor III

Re: Combining Responses from One field

‌in your script editor generate one more field like :

if (Rank=Match(Rank,'Disagree','NA'), 'DisagreeAndNA','Rank') As NewRank

Use NewRank as the dimensio in the chart

Not applicable

Re: Combining Responses from One field

Thanks. You mean I have to make synthetic dimension an based on each have to add up the responses to group. I want some more efficient way to be used in formula in measure in chart

Re: Combining Responses from One field

You cannot club dimension value using a measure... you will need to modify your dimension itself... the more efficient way would be to do this in the script (just as I mentioned above)

Community Browser