Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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
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 .
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.
In addition to Lech's points
Kind regards...
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
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)
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)
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:
Summary:
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.