topic Use if condition on a set analysis in QlikView

Use if condition on a set analysis

Thu, 05 Mar 2015 22:50:50 GMT

I have a set analysis set up and was wondering if I could make an if statement out of the set analysis. Basically I want an if condition that checks to see if the value from the set analysis is greater than 0.

here's the set analysis:

sum({<FYEAR={$(vBenchYr)},QUARTER={'Q4'},Measure={'Shipped Qty'}>}(Value))

so if the sum of this set analysis value is greater then 0 then I want to do something

how would I do this if it can be done????

Re: Use if condition on a set analysis

maxgro — Thu, 05 Mar 2015 22:55:56 GMT

if (sum({<FYEAR={$(vBenchYr)},QUARTER={'Q4'},Measure={'Shipped Qty'}>}(Value))>0, '>0', '<=0')

Re: Use if condition on a set analysis

robert99 — Thu, 05 Mar 2015 22:56:06 GMT

if (sum({<FYEAR={$(vBenchYr)},QUARTER={'Q4'},Measure={'Shipped Qty'}>}(Value)) >0,

'A','B')

Re: Use if condition on a set analysis

chrislofthouse — Fri, 06 Mar 2015 09:28:24 GMT

if ( sum({<FYEAR={$(vBenchYr)},QUARTER={'Q4'},Measure={'Shipped Qty'}>}(Value)) > 0 , TRUE , FALSE )