Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Hiding table if there is no data


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

7 Replies
rajeshvaswani77
Valued Contributor III

Re: Hiding table if there is no data

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

Not applicable

Re: Hiding table if there is no data

It is not working for me.

is there anyother way to do this

Re: Hiding table if there is no data

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

sujeetsingh
Honored Contributor III

Re: Hiding table if there is no data

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

As

=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

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


Or


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

Not applicable

Re: Hiding table if there is no data

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

Not applicable

Re: Hiding table if there is no data

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