topic Re: If statement vs set analysis in QlikView

If statement vs set analysis

deepakqlikview_123 — Fri, 31 Jan 2014 07:51:23 GMT

Hello All,

Can you please tell me difference between if statement and set analysis in qlikview.

thanks,

Re: If statement vs set analysis

alexandros17 — Fri, 31 Jan 2014 08:01:05 GMT

The most important difference is that set analysis is more quick expecially with complex expressions;

When you write a condition this is more compact and easy to read and to change in future

Re: If statement vs set analysis

MK_QSL — Fri, 31 Jan 2014 08:18:17 GMT

Performance wise set is more efficient than if...

Re: If statement vs set analysis

hic — Fri, 31 Jan 2014 16:39:57 GMT

Set analysis is basically building a filter into an aggregation function. The two following expressions should evaluate to the same:

Sum({$<Product={'X'}>} Amount)

Sum(If(Product='X', Amount))

Set analysis is always faster. However, Set Analysis is like a selection that is applied before the aggregation. It cannot have different conditions on different lines in the aggregation. In such a case you need an If().

HIC

Re: If statement vs set analysis

Thu, 20 Jul 2017 21:56:29 GMT

can you please explain a little bit more on how set analysis is applied before the aggregation and the inhability of having different conditions on different lines? Maybe an example too

Re: If statement vs set analysis

Nagaraju_KCS — Fri, 21 Jul 2017 03:36:53 GMT

The SET expression selection is done once for the whole chart. SET version would peform must faster.

The IF() evaluates for every row of data.

Re: If statement vs set analysis

Basel_Alyafi — Thu, 12 Sep 2019 09:05:00 GMT

Thanks for the clarification.

What if there are redundant records, would they have the same result too?