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
Best Regards, Ruggero --------------------------------------------- When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
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 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?