Hide zeros columns on Combo Chart

[micheledenardi]

I have a combo chart where the value of one measure is null for some years, while the other measure is not null (see 2018 and 2019 below).

Is there a trick to  hide zeros columns (space highlighted in yellow)  on combo chart ? 

The flag "Include zero values" is already removed but nothing change...  

Attached you can find also the source qvf

[sumanta1234]

Hi,

Please look into the below link:

https://www.youtube.com/watch?v=ARTnBy5vc6g

[micheledenardi]

Sumanta1234, your solution doesn't met my request.

[Qlik1_User1]

You can use a Stacked bar chart for this..as you are not showing lines with bar that usually combo chart have.

[micheledenardi]

For my purpose I need to use Non-Stacked combo chart

[Qlik1_User1]

try like if(SUM(measure)>0,SUM(measure))

[micheledenardi]

This last solution quite works because now zeros value are hidden but the empty space of the column remains so i cannot save space on my chart

[Qlik1_User1]

In dimension uncheck "Include null values"..

[micheledenardi]

Already did, the space remains

[Qlik1_User1]

It seems space will remain as is because for that measure value is coming but as null.. so Qlik have calculated the space for all four measure in chart and distributed accordingly..