topic Re: If Else expression in QlikView

If Else expression

Anonymous — Tue, 08 Aug 2017 13:52:51 GMT

Hello

I have an expression which goes like this

If(A like 'B', 'B',

If(A like 'C*', 'C',

If(A like 'D*', 'D',

null())))

But I want to change it to also give a title to all other possible entries

So something like this

If(A like 'B', 'B',

If(A like 'C*', 'C',

If(A like 'D*', 'D',

Else ('E',

null()))))

So if A isnt like B,C or D it is presented as E

If there is a way to do this it would be appreciated

Re: If Else expression

sunny_talwar — Tue, 08 Aug 2017 13:55:15 GMT

May be this

=If(A like 'B', 'B',

If(A like 'C*', 'C',

If(A like 'D*', 'D', 'E')))

Re: If Else expression

Anil_Babu_Samineni — Tue, 08 Aug 2017 13:57:43 GMT

Try this?

Pick(Match(A, 'B', 'C*', 'D*'), 'B','C','D', 'E')

If(Match(A, 'B'), 'B',

If(Match(A, 'C*'), 'C',

If(Match(A, 'D*'), 'D', 'E')))

Note - I am not sure i understand about Null() part

Re: If Else expression

sunny_talwar — Tue, 08 Aug 2017 14:01:10 GMT

You would need this for Pick Match....

Pick(WildMatch(A, 'B', 'C*', 'D*') + 1, 'E', 'B','C','D')

Re: If Else expression

Anil_Babu_Samineni — Tue, 08 Aug 2017 14:05:16 GMT

WildMatch is good one, But what does the use of +1 here?

Re: If Else expression

sunny_talwar — Tue, 08 Aug 2017 14:16:40 GMT

Basically

when A = B, WildMatch will give 1 + 1 = 2

when A = C*, WildMatch will give 2 + 1 = 3

when A = D*, WildMatch will give 3 + 1 = 4

when A = E, WildMatch will give 0 + 1 = 1

The way you wrote the expression, for E to show up, its value needs to be 4, but E can never equal 4, so its better to put it as the first clause....

Does that make sense?

Re: If Else expression

Anil_Babu_Samineni — Tue, 08 Aug 2017 14:22:58 GMT

Yes, LOT sense now. May be i miss this concept. I need to endorse this part. Thanks Bhai