Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all, im just looking for some clarification. i have an excel template report set up in NP. i have created two filters, both "Value as" but i want to apply them as an OR option. i.e. filter the data where filter one is true OR where the data is part of filter two (this is a list of ref numbers). it is a limited data table so cant be sure i have done this correct although at the moment does give me the expected output when running the process manually. At the moment i have placed Filter 1 in the Report Filters section and then filter 2 in the template report properties. is this correct/the best way to do this?
i saw the below mentioned elsewhere but didnt fully understand it.
task -> user -> report -> object
thanks
Dave
I dont know your Qlik Sense data model and granularity of the data so I cannot comment on what the result will be without seeing it - that is given...
now - for you to figure out if the search expression is working as you wish you can of course test it by using set analysis. Lets assume you have measure:
For that measure to check if what you want to filter works just put in Qlik Sense expression like below:
Verify number and see how it goes. If there is something wrong - then we will need to look at your model and you will need to provide us with working sample.
cheers
Hi,
Qlik NPrinting filters support Qlik Sense Advanced Search https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Advanced_Search.h...
Some samples are in https://community.qlik.com/t5/Qlik-NPrinting-Documents/Examples-of-Advanced-Search-Filters/ta-p/1594...
I think you should create a single filter using Advanced Search OR logic.
Adding a report and an object filter will result in an AND applied to the object https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ReportsDevelopment/Static-dynamic-fi...
Best Regards,
Ruggero
This was discussed on community many times, in fact so many times that it triggered me to write the blog post about it here: https://nprintingadventures.com/2021/09/23/filters-in-nprinting-how-hard-can-it-be-part-2-or-mode/ and Ruggero is right - you need to use "advanced search" filter!
cheers
Lech
Hi Lech, i had stumbled across your blog before. some really good stuff on there. if i dont want to add in a concatenated field like your Transid example with Dim 1 and Dim 2 etc can i still do an advanced search and do something like the below?? @Ruggero_Piccoli thanks for sharing those links.
=REF like '22/11111' or NUMBER like '25221309A' + '25224364A'+'25225858A'+'25228893A'+'25230730A'+'25231958A'
is this right then that this is looking at AGENCYREF or NUMBER or NUMBER or NUMBER etc.?
thanks
I dont know your Qlik Sense data model and granularity of the data so I cannot comment on what the result will be without seeing it - that is given...
now - for you to figure out if the search expression is working as you wish you can of course test it by using set analysis. Lets assume you have measure:
For that measure to check if what you want to filter works just put in Qlik Sense expression like below:
Verify number and see how it goes. If there is something wrong - then we will need to look at your model and you will need to provide us with working sample.
cheers
Thanks all, the "accepted solution" worked so thank you for that, but i was just wondering if it could be done without creating a measure/set analysis in the advanced search. Can you not just do something similar to the Value As where you just list a number of different search criteria to check against?
Thanks
Sure it could be and as I explained in my blog post you need to apply such Advanced filter on field which will provide required granularity.
Then your filter could be:
Advanced Search:
cheers
lech