Filtering a Level in nPrinting

[EnKy23]

Note: I am using NPrinting February 2024 SR3. I can't find that option in the dropdown.

I am trying to create a level in nPrinting based on a field called position. 

It contains the below values. I have no issue creating the level but I was wondering if it is possible to filter out a value from the field for example Goalkeeper and use the filtered field as the list.

I saw a few posts about using a table but I have not been successful when filtering this way.

Thanks.

[Lech_Miszkiewicz · Accepted solution]

Hi,

as documented filters are not available in levels. https://help.qlik.com/en-US/nprinting/February2025/Content/NPrinting/ReportsDevelopment/Qlik-objects...

Alternative as you mentioned is use of straight table with dimensionyou want to use as a level (for example: Positions) and Measure for example Count({<Positions={'Goalkeeper'}>}Positions). Note that this way of filtering this particular level is driven by hardcoded set analysis. You can make it semi-automated by using variable to list values in your set analysis and then from NPrinting side you could then apply variable filter to the report.

Then you add that object as a level.

If you are unsuccesfull in using table as a level you may want to share steps you have taken so we can understand better what is wrong with your approach. 

cheers

[EnKy23]

Hi @Lech_Miszkiewicz,

Thank you so much for this, I thought dimensions were only to be used in the level tables. I didn't think of using a measure to filter it. I applied this and it worked.

Thanks again.