Discussion Board for collaboration related to QlikView App Development.
I have a couple of pivot tables that I am using on a report and I only want them to print on the report if they actually have some data,
I am thinking I may be able to use the conditional show on the layout tab of the object but I don't know what code to use here to test if the chart actually has any data to display.
Can anyone advise how I might achieve this please?
Many thanks in advance,
Yes you are right.You can hide/show an object by using "Conditional" on Layout tab.
In the Conditional, use any of the expression from your table and make them non zero.
There is an expression Sales, then in Conditional write
This way the table will be shown only when there is any data.
Hope this helps!
View solution in original post
Generally we can Hide/Show any object on conditional
For Pivot table --> Properties --> Layout --> Show --> select conditional and write down your expression based on your requirements
The other method is enable the calculated condition on General Tab