Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
It is not working for me.
is there anyother way to do this
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
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)
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
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
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