topic Re: Excel Paging based on Flag in Qlik NPrinting

Excel Paging based on Flag

cbaqir — Fri, 27 Sep 2019 21:18:24 GMT

I have a field called 'CRDTeamFlag' and the options are 'CRD Team' or 'Non-CRD Team'.

I have one chart for CRD Team and one for Non-CRD Team.

In my NP report, I want 1 tab to show the entire Non-CRD Team chart, one tab for the entire CRD Team, chart and then PAGING (1 tab) for each Person in the CRD Team. In other words, 2 summary tabs (team and not team) and one tab for each person on the team. Thoughts?

Re: Excel Paging based on Flag

Lech_Miszkiewicz — Sat, 28 Sep 2019 06:31:23 GMT

not sure about template you want to use as you are not indicating it. Lets assume it is excel. I can see it working like this:

use one chart (instead of 2 separate prefiltered charts) without any set analysis or filtering as you can use page tag to achieve filtering...

Build first (1-one) excel sheet with page applied on it using CRDTeamFlag
Build second sheet (also one sheet) with applied page on it using table as a page object with CRDTeamFlag and Person as dimensions

It looks quite straight forward i think.

If my understanding is wrong maybe try to attach sample with how the outcome needs to look like...

Re: Excel Paging based on Flag

cbaqir — Mon, 30 Sep 2019 15:06:51 GMT

How do you apply paging with a filter? My CRDTeamFlag = 'CRD Team' or 'Non-CRD Team'.

Re: Excel Paging based on Flag

Lech_Miszkiewicz — Mon, 30 Sep 2019 23:52:09 GMT

Page tag loops through values in the field. So why do you want to apply filter. It will look through CRDTeamFlag = 'CRD Team' and CRDTeamFlag = 'Non-CRD Team'.

Do you have any other values in this CRDTeamFlag field? From your description it looks like you only have those 2 above mentioned values so you just need to use this field as <page> tag and it will loop through it.

If you have other values in i then apply filter on whole report. Filter would be then CRDTeamFlag = 'CRD Team' , 'Non-CRD Team'