Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor III

when compare among if and set analysis which performance is good in ui level?

when compare among if and set analysis which performance is good in ui level?

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: when compare among if and set analysis which performance is good in ui level?

Set Analysis will almost always be faster than if().

-Rob

View solution in original post

4 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: when compare among if and set analysis which performance is good in ui level?

Set Analysis will almost always be faster than if().

-Rob

View solution in original post

Highlighted
MVP
MVP

Re: when compare among if and set analysis which performance is good in ui level?

set analysis

Highlighted

Re: when compare among if and set analysis which performance is good in ui level?

This post covers your question

http://community.qlik.com/thread/74494


Highlighted
Esteemed Contributor III

Re: when compare among if and set analysis which performance is good in ui level?

A few things to keep in mind:

- As a rule, set analysis is faster.

- Expressions with set analysis are not "cache-able", that means they are recalculated every time.

- In some cases "if" cannot be replaced with set analysis.