Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
josephinetedesc
Creator III
Creator III

limit the dimensions shown in a chart

I have 2 values, actual and target.

my x axis is a month of the financial year

obviously for future months there is a value of -100%, I do not wish to show these months/values to show on the chart.

It is not a dimension limit of the x axis "month"

My if statement to get the variance between actual and target is shown below:  I thought I could get a if statement which would give the value -30%, but this does ot solve the problem, because the month's are still shown with a value.

(

sum(theactua_total) - sum(tartget_total))/(sum(target_total)) 

Thank you

Jo


7 Replies
Not applicable

Can you please share the sample application ?

Not applicable

Hi Josephine,

You can use if condition in your expression i.e.

if(sum(theactua_total) >0,sum(theactua_total) - sum(tartget_total))/(sum(target_total)))


MayilVahanan

HI

Try like this

= if((sum(theactua_total) - sum(tartget_total))/(sum(target_total)) > 0, (sum(theactua_total) - sum(tartget_total))/(sum(target_total)) )

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
alkesh_sharma
Creator III
Creator III

Go to the dimensions limit tab ans limit dimensions where value < 0.

Hope this helps!

josephinetedesc
Creator III
Creator III
Author

But the problem is that the dimension is a date value of Month - it is not <0

I think I might need to limit the Month value shown so something like if the  Month(today()) >Month(date)? 

alkesh_sharma
Creator III
Creator III

No, It will limit the expression value of less than 0, to the corresponding month

josephinetedesc
Creator III
Creator III
Author

this is what I get:   so in the lower chart the months still show - There is a target in the coming months although no actual

still shows.JPG