topic Re: Set analysis if statement in QlikView

Set analysis if statement

Anonymous — Wed, 31 May 2017 13:18:52 GMT

I need a little help with the following set analysis statement.

If (SALES_PERSON='John', // if sales person = john

Avg({<MetricName={OverallScore}>} Sales_Formula) // then take the average of the following sales

$(vCustomSale)) // otherwise return this variable

Does this look ok (format wise ) as it doesnt seem to work ?

vishsaggi — Wed, 31 May 2017 13:36:15 GMT

May be this?

If (SALES_PERSON='John', Avg({<MetricName = { 'OverallScore' }>} Sales_Formula), '$(vCustomSale)' )

sunny_talwar — Wed, 31 May 2017 14:03:47 GMT

Does one part of the if condition doesn't work or the whole thing doesn't work? May be missing a comma?

If (SALES_PERSON='John', // if sales person = john

Avg({<MetricName={OverallScore}>} Sales_Formula), // then take the average of the following sales

$(vCustomSale)) // otherwise return this variable

Anonymous — Wed, 31 May 2017 14:57:38 GMT

Thanks. The comma should have originally been included - was just a typo. With this though what it does is 'only' show me sales for John ...

sunny_talwar — Wed, 31 May 2017 15:03:12 GMT

Okay so we know that this is working

Avg({<MetricName={OverallScore}>} Sales_Formula)

The issue is with $(vCustomSale) then? What is the expression behind this variable?

Anonymous — Wed, 31 May 2017 16:32:05 GMT

Yes exactly, Avg({<MetricName={OverallScore}>} Sales_Formula) works fine.

The expression behind $(vCustomSale) is Round(Avg(AreaCustomScore),1)

zebhashmi — Wed, 31 May 2017 16:38:43 GMT

Try this

$(=vCustomSale)

Anonymous — Thu, 01 Jun 2017 14:11:26 GMT

Unfortunately this didn't work.