Hiding table if there is no data

[#1]

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

[rajeshvaswani77]

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

[#3]

It is not working for me.

is there anyother way to do this

[its_anandrjs]

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]

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)

[its_anandrjs]

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

[#7]

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

[#8]

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