topic if in QlikView

if

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

i have this query in my edit script

if(DEPT_Code = 'COS',Date([lastSalesMatchDate] ,'YYYY-MM-DD'),Date(MonthStart(today()),'YYYY-MM-DD')) as [date]

In the above DEPT_Code i need to include even DOT also how do i write this

if(DEPT_Code = 'COS',DOT,......) ?

Wed, 18 Jan 2017 13:09:03 GMT

Try this

if(match(DEPT_Code = 'COS','DOT'),Date([lastSalesMatchDate] ,'YYYY-MM-DD'),

Date(MonthStart(today()),'YYYY-MM-DD'))

Thanks,

Balakrishnan.R

avinashelite — Wed, 18 Jan 2017 13:11:11 GMT

Try like this

if(DEPT_Code = 'COS' or DEPT_Code = 'DOT' ,Date([lastSalesMatchDate] ,'YYYY-MM-DD'),Date(MonthStart(today()),'YYYY-MM-DD')) as [date]

sunny_talwar — Wed, 18 Jan 2017 13:13:46 GMT

Match doesn't need an equal sign... may be this

If(Match(DEPT_Code, 'COS', 'DOT'), Date([lastSalesMatchDate], 'YYYY-MM-DD'),

Date(MonthStart(Today()), 'YYYY-MM-DD'))

Aurelien_Martinez — Wed, 18 Jan 2017 13:13:51 GMT

Hi,

if(Match(DEPT_Code, 'COS', 'DOT')>0, Date([lastSalesMatchDate] ,'YYYY-MM-DD'),Date(MonthStart(today()),'YYYY-MM-DD')) as [date]

Wed, 18 Jan 2017 13:17:15 GMT

Yes, apologies.

Match does not need an equal sign.