topic Using data comparision with set analysis within a nested IF in QlikView

Using data comparision with set analysis within a nested IF

triciagdaly — Fri, 30 May 2014 19:45:58 GMT

Please see attachment.

I have a nested IF and will first check for override price. If null, check to see if a purchase price exists where the last purchase price date < a benchmark date field. If this is null, then use receipt price.

I am having syntax issues with the If regarding the purchase price.

Re: Using data comparision with set analysis within a nested IF

swuehl — Fri, 30 May 2014 19:56:29 GMT

You can only use set expression in an aggregation function like sum(), count(), only() etc.

It looks like in your expression,

IsNull(CURRENT_PURCHASE_PRICE({<LAST_PURCH_PRICE_TRAN={"<=$(=date(vBenchmarkDate))"}>} ))

it's not valid syntax. Maybe you want something like

IsNull(only({<LAST_PURCH_PRICE_TRAN={"<=$(=date(vBenchmarkDate))"}>} CURRENT_PURCHASE_PRICE))