topic Re: Convert if statement to Set Analysis in QlikView

Convert if statement to Set Analysis

Fri, 14 Apr 2017 01:14:38 GMT

Can this be converted to Set Analysis?

if(SUM(EXTENDED_RETAIL) >=500, sum(EXTENDED_RETAIL)*.05, sum(EXTENDED_RETAIL)*.02 )

Re: Convert if statement to Set Analysis

oknotsen — Fri, 14 Apr 2017 07:21:18 GMT

No, but you could use the statement in your script and create an extra field for the outcome so you no longer have to do the calculation in your front-end.

Re: Convert if statement to Set Analysis

MarcoWedel — Sun, 16 Apr 2017 22:39:10 GMT

no set expression, but maybe helpful:

SUM(EXTENDED_RETAIL)*(.05+(sum(EXTENDED_RETAIL)<500)*.03)

regards

Marco

Re: Convert if statement to Set Analysis

Mon, 17 Apr 2017 01:49:32 GMT

Marco,

The " + " in the set equation represent the "OR" condition?

Lyndon

Re: Convert if statement to Set Analysis

avinashelite — Mon, 17 Apr 2017 07:38:27 GMT

In your case your comparing the results after the Aggr so you need calculate the sun() in the script then you could use the same in set analysis

Re: Convert if statement to Set Analysis

Mon, 17 Apr 2017 13:25:35 GMT

It works!