100% Stacked Bar Chart with Grouped Dimensions

[Anonymous]

Hi All,

I am very new to Qlik Sense and is now trying to produce a 100% stacked bar chart for a survey analysis.

By searching information from the internet, I am able to produce a 100% stacked bar chart with 1 dimension 'Classification' over dimension 'Q1 Response' (see below):

The expression I used in my measure is:

Count([Q1 Response]) / Count(TOTAL <Classification> [Q1 Response])

Now, I want to do dimension grouping, for the Classification used as dimensions, I want to group 'IPOS' with 'NB - IPOS' and give a new name as 'iPOS'; then group 'MCV' with 'PRC' and name this group as 'MCV', for the rest, name the remaining group as 'Paper'. I would like to show the new group name on left hand side (y-axis) while allowing the user to drill down to see the original grouping if they like.

I tried to create new variable by following expression:

=if(match(Classification,'NB - IPOS','IPOS'),'iPOS',if(match(Classification,'MCV','PRC'),'MCV','Paper'))

and is able to use this new dimension to group the data, but the chart is no longer a 100% stacked bar chart even though I set it to be stacked.

Can any one help me out here? What should be the expression for the measures or dimension?? Thanks in advance!!!

[Gysbert_Wassenaar · Accepted solution]

The easiest and imho best way is to create a new field in the load script for the groups. Then you can use that new group field as dimension and in your expression for the TOTAL qualifier.

[Anonymous]

Many thanks!! I have resolved the problem by creating new field!!!

[domm]

Hi, how did you created the new field in the load script for the groups?