Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

hamdaniahmad
New Contributor III

Combining 2 Stacked Bar with different dimensions

Hello All,

I have a question, can I combine 2 stacked bar into only 1 object?

I have case to comparing total sales persons with their area with different dimensions (see picture).

If we combine into 1 object, it's easier to see and analyze.

Anyone have any suggestions or maybe Qlik Sense have special extension for this case?

It is better if stacked bar also showing transition between dimension.

Thanks anyway.

sense.png

3 Replies
OmarBenSalem
Esteemed Contributor

Re: Combining 2 Stacked Bar with different dimensions

u have 2 measures u want to combine into the same bar?

one for Sales another for Area?

hamdaniahmad
New Contributor III

Re: Combining 2 Stacked Bar with different dimensions

Yes... exactly, I have 2 Measures and 2 Dimensions, is it possible?

OmarBenSalem
Esteemed Contributor

Re: Combining 2 Stacked Bar with different dimensions

Try to use valueList()

sthing like follow:

Dim : ValueList('Sales Person','Area')

Dim2 : YourDim

Measure: if(ValueList('Sales Person','Area')='Sales Person', YourFirstMeasure,YourSecondMeasure)

Community Browser