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 a table when all values are zero or blank

I have several straight tables. I only want to display those tables with values I want to hide all the tables with no value or blanks.

The value in the tables are based on Fields selected in the Multi Box.

How can I do this? Thanks in advance for your help.

1 Solution

Accepted Solutions
Jason_Michaelides
Luminary Alumni
Luminary Alumni

It's a simple Boolean formula.  So in the Show Condition just type

category<>orange

However, what if more than one category selection is made i.e. green and orange are both selected?  If you want to hide the table if orange is contained in the category selections then you will need

INDEX(GetFieldSelections(category),'orange')=0

But what if orange is an associated value i.e. some other selection is made that is associated to orange?  If you want to hide the table in this case you will need

INDEX(Concat(DISTINCT category,','),'orange')=0

Hope this helps,

Jason

View solution in original post

7 Replies
goldnejea8
Partner - Creator
Partner - Creator

Try using the Calculation Condition on the General Tab.  It will only generate based on the conditions you set.  It can also display a message indicating that the calculation conditions have not been met

goldnejea8
Partner - Creator
Partner - Creator

Or better yet, there is also a conditional show in the Layout Section of the properties.

Anonymous
Not applicable
Author

Can you tell me how to write the condition to hide the table?

In my Multi Box, I have 4 population category, if category = orange then I would like the table to be hidden.

Thanks.

Jason_Michaelides
Luminary Alumni
Luminary Alumni

It's a simple Boolean formula.  So in the Show Condition just type

category<>orange

However, what if more than one category selection is made i.e. green and orange are both selected?  If you want to hide the table if orange is contained in the category selections then you will need

INDEX(GetFieldSelections(category),'orange')=0

But what if orange is an associated value i.e. some other selection is made that is associated to orange?  If you want to hide the table in this case you will need

INDEX(Concat(DISTINCT category,','),'orange')=0

Hope this helps,

Jason

Anonymous
Not applicable
Author

Jason,

Thank you!

Anonymous
Not applicable
Author

Hi , i have a question in similar lines ,

  how to hide a dimnsion when there is a null

say like i have

Brand as dimension adn values are as follows

xxx,

yyy,

zzz,

-,

then how can i remove that' -' ( null value) dimensionout of my straight table

Anonymous
Not applicable
Author

sorry , that i could able  figured that out by selecting an option supress nul vales

thanks