Stacked bar with one dimension

Anonymous — Sat, 16 Nov 2024 09:01:14 GMT

Hi everyone

I need to create a stacked bar in qliksense, grouped in a different way.

what i have:

dimension:

1. type: (domestic, international)

measures:

1. sales

2. goal sales

when i build the stacked bar this is what i get.

Any idea how to solve it?

Re: Stacked bar with one dimension

shraddha_g — Wed, 29 Nov 2017 09:42:06 GMT

Try below in Bar chart

Dimension:

1st - Valuelist('Sales','Goal Sales')

2nd - Type

Measure:

Pick(Wildmatch(Valuelist('Sales','Goal Sales'),'Sales','Goal Sales'),

SalesExpression,

Goal Sales Expression

)