topic Re: Are PICK() or PICK(Match()) expressions faster than IF expressions for Calculated Dimensions? in App Development

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

mwallman — Fri, 12 Apr 2019 17:12:09 GMT

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?

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

Digvijay_Singh — Wed, 17 Apr 2019 16:54:12 GMT

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

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

sunny_talwar — Wed, 17 Apr 2019 17:45:00 GMT

Also, a good read help - performance improvements