Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to filter group of codes?

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!!!

11 Replies
Chanty4u
MVP
MVP

you can use applymap

quick applymap example

Anonymous
Not applicable
Author

Thanks! But I need it for the users use' so it have to be very friendly use.

Ralf_Heukäufer
Partner - Creator III
Partner - Creator III

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.

NareshGuntur
Partner - Specialist
Partner - Specialist

Have you tried something similar to this?

(Green|Red)

multiple values separated by pipe symbol

Best Regards

Naresh

agigliotti
Partner - Champion
Partner - Champion

Just to know, what's the scope of your request?

ogster1974
Partner - Master II
Partner - Master II

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

Anonymous
Not applicable
Author

Thanks Andy, I need something flexible for users use

Anonymous
Not applicable
Author

do you mean something like this : 100 | 101 ?

This syntax doesn't work

Anonymous
Not applicable
Author

Thank you Ralf I need flexible solution for users use