Skip to main content

New to Qlik Sense

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

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
danmercer
Creator
Creator

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
mov
Employee
Employee

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
mov
Employee
Employee

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"

danmercer
Creator
Creator
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

mov
Employee
Employee

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.



danmercer
Creator
Creator
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