Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can I surpress a text object if a value I am displaying is zero?

Hi, I have some text fields around a Pie chart showing additional info about what is in the Pie Chart. The problem is, sometimes the result of an expression will be 0 (as in the number 0, not as a flag), and I don't want that text object to be displayed if there is no information to be displayed (Meta data with no data). Is there a way to do this? In any other development langauge I know like C# I could say object.Display = true or something, and stick that in an IF statement. Is there a way to do this in Qlickview?

Many Thanks

1 Solution

Accepted Solutions
rustyfishbones
Master II
Master II

Yes, create the IF Statement and in the layout tab, choose Show Condition

and add IF Statement in there

View solution in original post

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Enable the option Conditional on the Layout tab of the properties window and enter the same expression used to calculate the value in the input field for the conditional expression. If the expression returns 0 the text box will be hidden. If the expression returns any value other than 0 the text box will be shown. 0 is false, anything else is true.


talk is cheap, supply exceeds demand
rustyfishbones
Master II
Master II

Yes, create the IF Statement and in the layout tab, choose Show Condition

and add IF Statement in there

Not applicable
Author

Many thanks guys! Works perfectly