Combining 2 Stacked Bar with different dimensions

[hamdaniahmad]

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.

[OmarBenSalem]

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

one for Sales another for Area?

[hamdaniahmad]

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

[OmarBenSalem]

Try to use valueList()

sthing like follow:

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

Dim2 : YourDim

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