Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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

 

 

Labels (1)
4 Replies
Kushal_Chawda

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

Kushal_Chawda

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