How to Filter Levels

[rwb139]

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.

[Lech_Miszkiewicz]

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 

[Frank_S · Accepted solution]

@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. 

[Lech_Miszkiewicz]

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?

[rwb139]

@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.

[Frank_S]

@Lech_Miszkiewicz 

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

[rwb139]

That did the trick! Thanks for your help!

[Frank_S]

No worries!