Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

satish25
New Contributor III

Selection for IF Clause

Hello Everyone,

I have the Following table:

Factory_Code

1002

1005
4001
4002
5001
5009
6113
7004
8001
8008
9000
9001

The expresssion is as follows:

If(WildMatch(Factory_Code,'4*'),'Exclude service center',

If(Factory_Code='5001' or

        Factory_Code= '9001' or

            Factory_Code='8001' or

                Factory_Code='1005' or

                    Factory_Code='8008','Exclude HO',

If(WildMatch(Factory_Code,'*'),'Standard'))) as Factory_Section.

In this code, I want the third condition to display all the Factory_Codes (i.e. it should include the values of 'Exclude service center' and 'Exclude HO' as well)

The Output should be as follows:

  • Exclude service center = 4001,4002.
  • Exclude HO = 5001, 8001,9001, 1005,8008.
  • Standard = 1002, 1005, 4001, 4002, 5001, 5009, 6113, 7004, 8001, 8008, 9000, 9001.


However in Future, the Factory_Codes may increase or decrease.

So wanted the necessary changes to be made in the Code.


Thanks in Advance.

Tags (2)
1 Solution

Accepted Solutions
agigliotti
Honored Contributor II

Re: Selection for IF Clause

you can do it with the below script:

load

    Factory_Code,

If(WildMatch(Factory_Code,'4*'),'Exclude service center',

If(Factory_Code='5001' or

        Factory_Code= '9001' or

            Factory_Code='8001' or

                Factory_Code='1005' or

                    Factory_Code='8008','Exclude HO' )) as Factory_Section

from your_table;

concatenate

load

     Factory_Code,

     'Standard' as Factory_Section

from your_table;

5 Replies
agigliotti
Honored Contributor II

Re: Selection for IF Clause

why do you need the third condition ?

what's your desired result on UI ?

satish25
New Contributor III

Re: Selection for IF Clause

I know that No selections with give all the Factory_Codes, but i want it to happen on the 'Standard' selection.

Basically that's a requirement I need to fulfil.

agigliotti
Honored Contributor II

Re: Selection for IF Clause

you can do it with the below script:

load

    Factory_Code,

If(WildMatch(Factory_Code,'4*'),'Exclude service center',

If(Factory_Code='5001' or

        Factory_Code= '9001' or

            Factory_Code='8001' or

                Factory_Code='1005' or

                    Factory_Code='8008','Exclude HO' )) as Factory_Section

from your_table;

concatenate

load

     Factory_Code,

     'Standard' as Factory_Section

from your_table;

satish25
New Contributor III

Re: Selection for IF Clause

This works perfectly,

Thank you ..!!

OmarBenSalem
Esteemed Contributor

Re: Selection for IF Clause

Then please close the thread by marking the correct answer as correct

Community Browser