topic Hide a table when all values are zero or blank in QlikView

Hide a table when all values are zero or blank

Anonymous — Fri, 11 May 2012 18:28:04 GMT

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.

Hide a table when all values are zero or blank

goldnejea8 — Fri, 11 May 2012 19:48:09 GMT

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

Hide a table when all values are zero or blank

goldnejea8 — Fri, 11 May 2012 19:50:24 GMT

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

Re: Hide a table when all values are zero or blank

Anonymous — Mon, 14 May 2012 15:22:28 GMT

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.

Hide a table when all values are zero or blank

Jason_Michaelides — Mon, 14 May 2012 15:41:43 GMT

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

Hide a table when all values are zero or blank

Anonymous — Mon, 14 May 2012 15:51:03 GMT

Jason,

Thank you!

Re: Hide a table when all values are zero or blank

Anonymous — Mon, 14 May 2012 16:07:24 GMT

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

Hide a table when all values are zero or blank

Anonymous — Mon, 14 May 2012 16:14:30 GMT

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

thanks