Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Hide dimension where measure is null or 0?

Hello,

Looking to see if there is a way to not display all months when a field is zero or null?  I've got a budget to actual line chart.  I don't want to show values for months that haven't happened yet.  Our data is currently minimal, and will be updated via an excel upload. I've tried a few IF statements to no avail. Picture is below (yes, the values are negative on purpose). 

Capture.PNG

Thanks in advance

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

It is not what I said...

Assuming you "basic" Budget expression is

sum(Churn_Budget_Amount)

and your Reporting expression is

Sum(MRR)


THEN your budget expression should be

if(Sum(MRR)=0, 0, sum(Churn_Budget_Amount))

and Reporting:just

Sum(MRR)


And, don't forget to un-check that box.



View solution in original post

5 Replies
Anonymous
Not applicable
Author

Your "Budget expression" should be like this:

If(<Reported Expression> =0, 0, <Budget Expression>)

And in the chart properties, "Add-ons", "Data handling" - uncheck "Show zero values"

Anonymous
Not applicable
Author

Michael,

I have that done, and it doesn't appear to be working.

if(sum(Churn_Budget_Amount)=0,0,sum(Churn_Budget_Amount))

if(Sum(MRR)=0,0,Sum(MRR))Capture2.PNG

Anonymous
Not applicable
Author

It is not what I said...

Assuming you "basic" Budget expression is

sum(Churn_Budget_Amount)

and your Reporting expression is

Sum(MRR)


THEN your budget expression should be

if(Sum(MRR)=0, 0, sum(Churn_Budget_Amount))

and Reporting:just

Sum(MRR)


And, don't forget to un-check that box.



Anonymous
Not applicable
Author

Ah.  That seems to do it.

Thanks.

sohailansari201
Creator
Creator

Michael,

This solution only shows the chart up to the current month. I have going through the same problem. What if I want to show complete Budget line and partial Reported line? Is this a possibility?

Thank you,

Sohailscreenshot.png