Qlik Sense Stacked Bar chart without Dimensions

[balaji_m]

Hi Team,

I have a scenario like given below

Dimension - No Dimension

Expression1 - Sum(A)+Sum(B+sum(C)

Expression 2 - sum(D) +sum(E)+sum(F)

I have to show the value in Stacked Bar chart as Attached

[OmarBenSalem · Accepted solution]

Dimension:

ValueList('exp1','exp2')

Measure 1:

if(ValueList('exp1','exp2')='exp1',sum(A),sum(D))

Measure 2:

if(ValueList('exp1','exp2')='exp1',sum(B),sum(E))

Measure 3:

if(ValueList('exp1','exp2')='exp1',sum(C),sum(F))

Result:

[balaji_m]

Hi Omar,

Thanks.

[farahahmad]

Hi Omar,

I have the same question but with 3 different dimension.

Can you give example using the same example here but add 'exp3'?

Really appreciate if you can help.

Thanks.