Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to filter empty pages from report?

Hi,

I have an object showing data for several departments in file and my report is running over all of them. Not all of them have data relevant to specific week, therefore I get some empty pages (page per department).

How can I create a report showing only the pages/departments with data?

Thank's.

2 Replies
marcus_sommer

You could try to filter and select the departments with data before you start the print-job. Maybe a calculated listbox-expression might work. Try something like this:

if(sum(aggr(sum(YourField), Department, Week))>0, 'data available', 'no data')

- Marcus

ramasaisaksoft

Hi Ayala,

I hope you need to write a conditional show option.

Select  the ( for all tabs) tab ->right click->Sheet properties->Conditional Show sheet here u need to give condition

like

= if(sum(aggr(sum(YourField), Department, Week))>0, 'ActiveDocument.ActivateSheet "SH01"', ActiveDocument.ActivateSheet "Default Sheet ID"))