Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

danmercer
Contributor

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
Esteemed Contributor III

Re: Hide dimension where measure is null or 0?

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.



5 Replies
mov
Esteemed Contributor III

Re: Hide dimension where measure is null or 0?

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
Contributor

Re: Hide dimension where measure is null or 0?

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
Esteemed Contributor III

Re: Hide dimension where measure is null or 0?

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
Contributor

Re: Hide dimension where measure is null or 0?

Ah.  That seems to do it.

Thanks.

sohailansari201
Contributor

Re: Hide dimension where measure is null or 0?

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