Pick with match vs Nested if

[suresh_qv50]

Hello all,

Nested if and pick with match both are used to achieve the same functionality, can any one explain performance wise which one is preferable.

Storing  pick and match function  expression into variable and using that variable in multiple location can it improves performance or there is no any difference in case of Pick and Match Expression.

Regards

suresh

[robert_mika · Accepted solution]

Variable will improve performance.

Each expression makes the app 'heavier'.

With variable, you are creating a reference point.

improving QlikView performance

[marcus_sommer]

Take a look here: Pick Match vs Nested If Performance

- Marcus