Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

saranibo
New Contributor

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
sureshqv
Esteemed Contributor III

Re: How to filter group of codes?

you can use applymap

quick applymap example

saranibo
New Contributor

Re: How to filter group of codes?

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

Ralf_Heukäufer
Contributor III

Re: How to filter group of codes?

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
Valued Contributor

Re: How to filter group of codes?

Have you tried something similar to this?

(Green|Red)

multiple values separated by pipe symbol

Best Regards

Naresh

agigliotti
Honored Contributor II

Re: How to filter group of codes?

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

ogster1974
Honored Contributor II

Re: How to filter group of codes?

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

saranibo
New Contributor

Re: How to filter group of codes?

Thanks Andy, I need something flexible for users use

saranibo
New Contributor

Re: How to filter group of codes?

do you mean something like this : 100 | 101 ?

This syntax doesn't work

saranibo
New Contributor

Re: How to filter group of codes?

Thank you Ralf I need flexible solution for users use

Community Browser