topic Hiding table if there is no data in QlikView

Hiding table if there is no data

Mon, 08 Dec 2014 08:38:13 GMT

Hello All,

I have a straight table with 10 expression.

I want to hide that table if the there is no data.

Thanks and Regards,

Priya

Re: Hiding table if there is no data

rajeshvaswani77 — Mon, 08 Dec 2014 08:41:47 GMT

Hi Priya,

Go to layout tab and select show conditional radio button

There give a formula

getpossiblecount(<fieldname>) > 0

Substitute <ieldname>by name of one of the fields displayed in the straight table.

thanks,

Rajesh Vaswani

Re: Hiding table if there is no data

Mon, 08 Dec 2014 08:51:40 GMT

It is not working for me.

is there anyother way to do this

Re: Hiding table if there is no data

its_anandrjs — Mon, 08 Dec 2014 08:51:44 GMT

Hi,

With any variable you can do the same

Create a variable in the load script here Region is the table name

LET vNoofRow = NoOfRows('Region');

And in the Laout property of the chart >> conditional >> write =vNoofRow > 0

Regards

Anand

Re: Hiding table if there is no data

sujeetsingh — Mon, 08 Dec 2014 08:53:00 GMT

On general tab you can use the Calculation Condition and write there the condition.

=if(sum(sales)=null(),0,1)

Even you can use this condition on the layout in properties and write there

=if(sum(sales)=null(),0,1)

Re: Hiding table if there is no data

its_anandrjs — Mon, 08 Dec 2014 08:57:02 GMT

Hi,

You can try this way also let assume this table

Fact:
LOAD * Inline [
ColA
a
b ];

And in the Laout property of the chart >> conditional >> write =GetPossibleCount(ColA) > 0

By Variable

LET vNoofRow = NoOfRows('Fact');

the Layout property of the chart >> conditional >> write =vNoofRow > 0

For check remove rows from the table then check

Fact:
LOAD * Inline [
ColA
];

Regards

Anand

Re: Hiding table if there is no data

Mon, 08 Dec 2014 09:00:50 GMT

hi priya,

what rajesh said is exacly right.

i have tried and got the result.

if that particular field which you provide in the condition is empty, the chart will not appear!

better try again!

regards,

Barathiraja

Re: Hiding table if there is no data

Mon, 08 Dec 2014 09:18:37 GMT

Dimension in chart is say Region and value id say Delhi.

Now in expression in writing so set analysis .which doesnot return any value .

In such case where the table doesnot have any data to show,i want to hide the table