Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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, your solution doesn't met my request.
You can use a Stacked bar chart for this..as you are not showing lines with bar that usually combo chart have.
For my purpose I need to use Non-Stacked combo chart
try like if(SUM(measure)>0,SUM(measure))
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
In dimension uncheck "Include null values"..
Already did, the space remains
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..