Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Hide zeros columns on Combo Chart

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

2020-03-04 10_04_03-Example - My new sheet _ Sheets - Qlik Sense.png

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

 

Labels (1)
10 Replies
Highlighted
Partner
Partner

Hi,

Please look into the below link:

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

Highlighted
Specialist
Specialist

Sumanta1234, your solution doesn't met my request.

Highlighted
Creator III
Creator III

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

Highlighted
Specialist
Specialist

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

Highlighted
Creator III
Creator III

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

Highlighted
Specialist
Specialist

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

 

2020-03-04 12_00_43-Example - My new sheet _ Sheets - Qlik Sense.png

Highlighted
Creator III
Creator III

In dimension uncheck "Include null values"..

Highlighted
Specialist
Specialist

Already did, the space remains

Highlighted
Creator III
Creator III

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