Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

New Contributor

Stacked bar chart

I have stacked bar chart with 5 different values which I am getting from my SQL query.

Different stack showing different value in different colors. And that's fine.

Now I want to merge two different stack value and show as one ( as the same color), How can I achieve that without modifying my SQL query.


1 Reply
MVP & Luminary
MVP & Luminary

Re: Stacked bar chart

Put a preceding load on top of your SQL query where you combine the two different values into one value. If you don't want to modify your script you can try using a calculated dimension. Something like =If(MyFieldHere = 'FirstValueThatShouldBeMerged' OR MyFieldHere = 'SecondValueThatShouldBeMerged', 'NewMergedValue', MyFieldHere) 



talk is cheap, supply exceeds demand