topic Re: How to filter empty pages from report? in QlikView

How to filter empty pages from report?

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: How to filter empty pages from report?

marcus_sommer — Mon, 30 May 2016 10:39:17 GMT

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

Re: How to filter empty pages from report?

ramasaisaksoft — Mon, 30 May 2016 11:08:25 GMT

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

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