IF vs CASE...WHEN

[wanyunyang]

Hi guys,

Can we use CASE...WHEN in QLIK SENSE expression? If so, which is more efficient? IF or CASE...WHEN?

Thanks for help!

[sunny_talwar · Accepted solution]

There is no CASE statement in Qlik world... but you can use Pick(Match(...)) which gives better performance then if statements

[zebhashmi]

I am not sure about when maybe while and where

so looks like IF is only choose

[Anonymous]

Pick(Match(...)) certainly gives better looking code which I find easier to understand and less brackets to count up and get correct, but I am not sure if it gives better performance.  Do you know of any metrics that have been done re this ?

[sunny_talwar]

It might be a myth, but have seen some places where Pick Match helped people improve the expression.... Also, HIC's description of if makes me think that it might do worse then Pick... but have not seen any threads where a comparison has been done.

Some places which might be worth going through.

HIC's response here

Re: help - performance improvements

Marcus's response here

Pick Match vs Nested If Performance