Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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
Partner

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
Partner

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

upaliwije
Creator II
Creator II
Author

Thanks