topic Re: If Condtions in QlikView

If Condtions

upaliwije — Fri, 10 Jan 2020 06:58:00 GMT

Hi Friends,

I want to write following condition in may data load script

IF(QUOTED_PRICE<AVG_PRICE AND IF(QUOTED_PRICE<MARKET_PRICE AND IF(QUOTED_PRICE< LAST_PURCHASE,'Y','N'))) AS PURFLG,

But it is not correct. Kindly help me

Arthur_Fong — Fri, 10 Jan 2020 07:01:56 GMT

Try:

IF(QUOTED_PRICE<AVG_PRICE AND QUOTED_PRICE<MARKET_PRICE AND QUOTED_PRICE< LAST_PURCHASE,'Y','N')as PURFLG

upaliwije — Fri, 10 Jan 2020 07:10:31 GMT

Thanks