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.
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