Are PICK() or PICK(Match()) expressions faster than IF expressions for Calculated Dimensions?

[mwallman]

Hi,

I think the answer here is it depends on what is in the expressions, but in general, are PICK() or PICK(Match()) expressions faster than IF expressions for Calculated Dimensions?

Let's say you had a nested IF expression like this:

IF Value = 1 then Hello

IF Value = 2 then Cat

IF Value = 3 then Dog

Written in Pick or Pick Match format would it perform better?

[Digvijay_Singh]

I think so, Pick/Match always find one bullet point in performance checklist indicating should be used instead of if.

https://community.qlik.com/t5/New-to-QlikView/Pick-Match-vs-Nested-If-Performance/td-p/1174461

[sunny_talwar]

Also, a good read help - performance improvements