Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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
MVP & Luminary
MVP & Luminary

Re: How to filter empty pages from report?

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
Valued Contributor III

Re: How to filter empty pages from report?

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"))