Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

If Condtions

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

 

1 Solution

Accepted Solutions
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Try:

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

View solution in original post

2 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Try:

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

upaliwije
Creator II
Creator II
Author

Thanks