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

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

Anonymous — Wed, 16 May 2018 10:08:31 GMT

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.

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

YoussefBelloum — Wed, 16 May 2018 10:11:52 GMT

Hi,

I think ValueList() is one way to do it

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

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

Anonymous — Wed, 16 May 2018 10:18:52 GMT

Can u send me an example?

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

sagar_puri — Wed, 16 May 2018 10:30:08 GMT

Hi Mohammed,

Maybe this can help

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

Anonymous — Wed, 16 May 2018 11:24:14 GMT

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

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

YoussefBelloum — Wed, 16 May 2018 11:46:06 GMT

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

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

sagar_puri — Wed, 16 May 2018 12:05:13 GMT

Yes..

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

Anonymous — Wed, 16 May 2018 14:37:15 GMT

I got the results..

Thank you so much Sagar & Youssef ..