Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone!!! I want to filter for example 200 random codes in Qlik Sense. I have the list in excel. Do you have any idea how to do that easily?
THANKS!!!
you can use applymap
Thanks! But I need it for the users use' so it have to be very friendly use.
You can create groups in your Loadscript something like
Load
...
Code,
if(Code>=1 and Code<100, Group1,if(Code>=100 and Code<200,Group2 )) as Codegroup,
...
from...
and so on.
Additional you can load it with an "order by Code"
and an asc for ascending behind the from.
Have you tried something similar to this?
(Green|Red)
multiple values separated by pipe symbol
Best Regards
Naresh
Just to know, what's the scope of your request?
You could filter the codes and then create a bookmark with a friendly name. Save and repblish the App and the users will have a bookmark they can apply when they want to look at those specific 200 codes.
Regards
Andy
Thanks Andy, I need something flexible for users use
do you mean something like this : 100 | 101 ?
This syntax doesn't work
Thank you Ralf I need flexible solution for users use