How to show table if the NoOfRows > 0

[qlikviewforum]

Hi

Imagine if I have to tables in my application. I want to show those tables on if the NoOfRows > 0. If the NoOfRows < 0 then it should be hidden. Can someone please help me out on how to achieve this?

Thanks,
qvforum

[#2]

try using a conditional show of the object with:

=count(distinct all YourField)>0

or

=GetPossibleCount(YourField)

Hope this help

[Anonymous]

LOAD C!,

C2

FROM Table

where NoofRows > 5