Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Test if a pivot table has data or not so I can hide it if it has no data?

Hi all,

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?

chartimage.jpg

Many thanks in advance,

Ben

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Test if a pivot table has data or not so I can hide it if it has no data?

Hi Ben,

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.

For Eg:

There is an expression Sales, then in Conditional write

Sum(Sales) <>0

This way the table will be shown only when there is any data.

Hope this helps!

View solution in original post

2 Replies
Highlighted
Not applicable

Re: Test if a pivot table has data or not so I can hide it if it has no data?

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

Highlighted
Not applicable

Re: Test if a pivot table has data or not so I can hide it if it has no data?

Hi Ben,

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.

For Eg:

There is an expression Sales, then in Conditional write

Sum(Sales) <>0

This way the table will be shown only when there is any data.

Hope this helps!

View solution in original post