Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Or better yet, there is also a conditional show in the Layout Section of the properties.
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.
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
Jason,
Thank you!
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
sorry , that i could able figured that out by selecting an option supress nul vales
thanks