topic Re: Stacked bar chart in QlikView

Stacked bar chart

heeman_alpha — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Stacked bar chart

Gysbert_Wassenaar — Sat, 18 May 2019 14:17:41 GMT

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)