Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jeeva3095
New Contributor II

Qlik Sense Alternate States

Hi All, Herewith I have attached the two picture for your reference. I need help for alternate state bar chart presentation in Qliksense. If I tried to stack the alternate state bar. G1 and G2 combined. But I need, separate bar for G1 and G2 with stacked different field. Ex: G1 stacked with their Sales, Profit & Loss  and then G2 stacked with their Sales, Profit & Loss.

3 Replies
miskinmaz
Contributor III

Re: Qlik Sense Alternate States

You have to use value list to create the dimension value G1 and G2.
Then create two expression for Sales, Profit and Loss using pick match of value list created in dimension.
Dim:
ValueList('G1','G2')
Measure 1 for Sales: if(ValueList('G1','G2')='G1', sum(sales_g1),sum(sales_g2))
similar for profit and loss
miskinmaz
Contributor III

Re: Qlik Sense Alternate States

jeeva3095
New Contributor II

Re: Qlik Sense Alternate States

Thank you so much