How can I stack-up two expression values as one bar in the chart?

[Anonymous]

I have 6 expressions in my bar chart which I would like to show as stacked bar for two expressions each so that I can show only three bars for 6 expressions.

For Eg: In the below snap attached, I want to show "Design Completed & Design Pending" as one stacked bar and hence the same for others as well.

[YoussefBelloum]

Hi,

I think ValueList() is one way to do it

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/ChartFunctions/SyntheticDimen...

[Anonymous]

Can u send me an example?

[sagar_puri · Accepted solution]

Hi Mohammed,

Maybe this can help

[Anonymous]

Do I have to write one value list function as expression to stack-up?

In that sense, I have to enter 3 value list functions for 6 expressions to stack-up as 3 bars... ?

[YoussefBelloum]

Sagar already created the example for you and yes you will need to create 3 different values in the valuelist because you nedd 3 bar charts

[sagar_puri]

Yes..

[Anonymous]

I got the results..

Thank you so much Sagar & Youssef ..