Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jeeva3095
Contributor II
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
Creator III
Creator III

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
Creator III
Creator III

jeeva3095
Contributor II
Contributor II
Author

Thank you so much