Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
suresh_qv50
Creator
Creator

Pick with match vs Nested if

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

1 Solution

Accepted Solutions
robert_mika
Master III
Master III

Variable will improve performance.

Each expression makes the app 'heavier'.

With variable, you are creating a reference point.

improving QlikView performance

View solution in original post

2 Replies
robert_mika
Master III
Master III

Variable will improve performance.

Each expression makes the app 'heavier'.

With variable, you are creating a reference point.

improving QlikView performance

marcus_sommer
MVP & Luminary
MVP & Luminary

Take a look here: Pick Match vs Nested If Performance

- Marcus