create an object filter on NPRINTING to display the TOP 10 without using qliksense

[Wil18]

Hi everyone, I am working on NPRINTING right now. I have a chart that I am attaching to my application

and I would like to create a NPRINTING object filter so that I can display the TOP 5 without going through the modification of my chart on QLIKSENSE

 Is it possible ?
If yes how to proceed, thank you for any help.

[Lech_Miszkiewicz · Accepted solution]

hi, 

yes - you can use advanced search filter  for that purpose. Obviously it depends how the chart was written, what is dimension and measure etc. 

In simple terms if you have sales by customer you could write expression like below to show top 5:

Advanced search: =[Customer]=sum({<[Customer]={"=rank(aggr(sum([Sales]),[Customer])) <= 5"}>} [Sales]) 

Important thing to understand is that Advanced Search filter can be affected by other filters in the NPrinting as it may be applied on top of other filters hence on data set already affected. Think that through when designing the solution. 

More on advanced search filters you will find in https://help.qlik.com or on my blog here: https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/

[Ruggero_Piccoli · Accepted solution]

Hi,

You can create a Qlik NPrinting filter that uses Advanced Search:

The formula is =If(Aggr(Rank(Sum(Sales)),Customer)<=10,1) so it returns 1 if a customer is in the Top 10

Advanced Search uses the Qlik Sense advanced search syntax, so it is more a Qlik Sense question about how to create the advanced search.

Add the table in the template with the object filter:

Run a preview:

The table on the right is filtered with the object filter and has 10 rows. The table on the left is complete.

Best Regards,

Ruggero

[Wil18]

@Lech_Miszkiewicz  thank you a lot, it's perfect for me. 

Have a nice day

[Wil18]

Thank you for your help @Ruggero_Piccoli it's perfect. 

Have a nice day