Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
SatyaPaleti
Creator III
Creator III

How to hide line chart when value is zero in combo chart

Hi Experts,

Could some one can please help to resolve following Issue. Here the Issue Screenshot

 

Issue_zero.PNG

 

Need to hide line chart when it's value is Zero. You can find sample qvf in the attachments

Thanks and Regards,

Satya

 

 

4 Replies
Kush
MVP
MVP

for which expression it should not show zero?

SatyaPaleti
Creator III
Creator III
Author

Hi Thank you so much for your response. For Sales Price I need to hide when it is showing zero

Kush
MVP
MVP

You need to create calculated dimension like below

= aggr(if([SalesPrice Expression]>0, Month),Month)

Check the option 'Suppress NULL Value'

SatyaPaleti
Creator III
Creator III
Author

Thank you Friend. I will try this and I think we dont have an option like Suppress Null Values in Qliksense