topic Re: How to Filter Levels in Qlik NPrinting

How to Filter Levels

rwb139 — Fri, 15 Nov 2024 23:36:37 GMT

Hi all,

I have a question on how I can filter out certain values on my nPrinting report. I have a dimension called appfolio_property_name which includes all of our current property names. I want to be able to sort them based on whether or not we have sold them. In my screenshot, I've got the ones currently owned on top and the ones sold on the bottom. I have tried applying a filter onto the property names where sold=yes but then there are null values on the bottom which take up hundreds of rows. Can anyone provide some insight into this? Thanks in advance.

Re: How to Filter Levels

Lech_Miszkiewicz — Wed, 18 Nov 2020 21:38:38 GMT

You should use Qlik sense table as a source for your levels and use dedicated expressions (typically with set analysis) to filter out data accordingly. Make sure you disable visibility of null value dimensions as well as 0 values in Qlik Sense chart properties.

With this in place you can then decide on individual sort of the records (sorting set on the table will be applied) as well as filter (set analysis used). Sorting should be set in Qlik Sense properties panel (not by dynamic sort on ui)

Make sure you reload metadata afterwards

Re: How to Filter Levels

Frank_S — Wed, 18 Nov 2020 21:55:33 GMT

@rwb139

To achieve your requirement, you can also emulate the snapshot below in your NP designer template editor.

In this example,

Add two levels and two tables using the same chart object
Create two filters. Apply your Yes (2015) filter to one table and the No (2016) filter to the second table

In my case the yes can be considered 2015 and the no can be considered 2016.

Re: How to Filter Levels

Lech_Miszkiewicz — Thu, 19 Nov 2020 04:45:05 GMT

Hi @Frank_S

It is worth mentioning that by taking your approach you only filtering table inside the level and not the actual level, right?

Re: How to Filter Levels

rwb139 — Thu, 19 Nov 2020 14:11:17 GMT

@Frank_S / @Lech_Miszkiewicz

Thank you both for your help! I believe that filtering the table will accomplish what I'm trying to do. I appreciate both of your help! I will update the solution once I am able to test it and confirm.

Re: How to Filter Levels

Frank_S — Thu, 19 Nov 2020 15:04:07 GMT

@Lech_Miszkiewicz

Correct. Using object filters in this ways is a reasonable way to achieve the desired result.

Re: How to Filter Levels

rwb139 — Mon, 23 Nov 2020 16:55:20 GMT

That did the trick! Thanks for your help!

Re: How to Filter Levels

Frank_S — Mon, 23 Nov 2020 17:19:29 GMT

No worries!