topic Re: Display table only it contains data in QlikView

Display table only it contains data

brf10043 — Wed, 25 Nov 2020 16:16:04 GMT

All,

I have an odd question. I have a dashboard that contains several tables. Depending on what filters are selected some tables may not include any data.

Is it possible to create a Layout expression to only show the table if it contains any data?

vishsaggi — Wed, 01 Nov 2017 20:28:17 GMT

Can you give us an example with some sample data. You can restrict in QV script.

MK9885 — Wed, 01 Nov 2017 20:41:55 GMT

Maybe in Settings>Layout>Conditional> give your expression with if <0

Ex:

if(Count(ID)<0,1,0)

(if(getselectedcount(FieldName)>0,1,0)

this would hide the the table if there are values below 0.

Not sure what condition you want to set to hide the chart with 0 data.