Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

balaji_m
New Contributor II

Qlik Sense Stacked Bar chart without Dimensions

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 Attachedtest.png

1 Solution

Accepted Solutions
OmarBenSalem
Esteemed Contributor

Re: Qlik Sense Stacked Bar chart without Dimensions

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:

Capture.PNG

2 Replies
OmarBenSalem
Esteemed Contributor

Re: Qlik Sense Stacked Bar chart without Dimensions

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:

Capture.PNG

balaji_m
New Contributor II

Re: Qlik Sense Stacked Bar chart without Dimensions

Hi Omar,

Thanks.

Community Browser