Need to filter the data by KCI and KRI level

[EGDR]

Hi Experts,

Please help me on this query.

I am trying to use filter on Nprinting object level, need to filter data only ABC one table object, but not working getting ABC &CDE Both we are getting.

Using filter Like

Selected advance search from the drop down 

if(wild match (ID)='ABC*', ID)

Thanks

[ajaykakkar93]

Hi,

in filter create a static filter for -> KCI 
add in the object filter using designer 

then check if it is working or no 
if it is not working make sure that if in the dashboard the same filter for KCI is when the applied object reflects the same data (this issue can come if the measure is having some condition/logic/expression that is restricting the filter)

[Lech_Miszkiewicz]

Hi,

1. @ajaykakkar93  solution obviously will not work because static filters dont support wildcard

2. The syntax you are using is just wrong - learn more about advanced search syntax from help document. To be honest learn about everything from help document as that is a great source of examples, samples etc. https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ReportsDevelopment/Static-dynamic-fi... There on help page you have video (which at 1:35 starts talking about your example). It would be as simple as just Advanced Search = KCI*

Bottom line is - always look at documentation to see how functionalities work.

good luck

[EGDR]

Hi @Lech_Miszkiewicz ,

I have created filter for only KCI, selected field and from the drop down selected Advance Search and given =KCI*

And Used filters on object level, we are getting Error. please help on this.

please find attachment for error message .

[Lech_Miszkiewicz]

1. Is it possible that your filter isnt possible to be applied?

2. you are applying it on the object-are there any other filters?

3. have you tested your filter by putting it on whole report and checking if it applies correct values?

4. Are there any other user/report filters or pages applied. If page is applied wrongly it could try to cycle through values which are excluded by your object filter.

[Frank_S]

In addition to Lech's points

• Test your report in an Publish task
• after executing the report in the task, check NP scheduler log and look for filter errors like 'empty set'  and so on. Please refer to this page (already share above by Lech) to accurately construct your filters and to understand the filter rules
  • https://help.qlik.com/en-US/nprinting/Content/NPrinting/ReportsDevelopment/Static-dynamic-filters.ht...
  • If you are using Advanced Search filter, carefully check the section on the page above: Creating a dynamic filter with advanced search

Kind regards...

[EGDR]

Hi @Lech_Miszkiewicz , @Frank_S , 

Thank you for your reply's,

I have tried multiple way's , but not working filters on Object level its working only Report level, currently  am using May-2021 version N-printing.

I am going through above reference to understand about filters. 

Thanks

[Lech_Miszkiewicz]

Did you try to create a report, have no other filters an apply filter only on the object?

You need to take into account that all filters are intersected when report is generated (Task, Report, User and Object filters) 

[Frank_S]

Exactly!!!

Lech_Miszkiewicz
 

Re: Need to filter the data by KCI and KRI level

Did you try to create a report, have no other filters an apply filter only on the object?

You need to take into account that all filters are intersected when report is generated (Task, Report, User and Object filters) 

[Lech_Miszkiewicz]

Hi @EGDR 

There is one obvious (at least to me) thing we didn't mention. It is on how advanced filters work. If you have some other filters in your app which will cause data (which you would like to filter using advanced filter) to be not associated after applying the other filters, then result of advanced search filter is only based on the "available" records based on your other filters. 

You can test your filters outside of NPrinting - directly in Qlik Sense filter pane.  Make sure you apply all selections you have in your report and then try to use advanced search in your Qlik Sense to apply your search - what results do you get?

Sample: 

• you apply filter on products sold - that filter causes only records until yesterday to appear
• then you try to use "Advanced search" to filter products sold Today (for example: Product-->Advanced Search: Count(Distinct {<Date={"$(=Today())"}>}Product)>1 and because such filter is not possible advanced search will not work!

Summary:

• advanced search filter will be evaluated based on POSSIBLE or AVAILABLE data set resulting from all other selections applied before it.

I probably drifted away little bit with this explanation but it can be a trap in some scenarios so make sure you dont fall in it.