Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
How can I write this bolded version in IF conditions in Qlik, I'm unable to get the correct syntax.
count( if( match( field1, 'abc') and field2= 'xyz' and YearStart(DateField)= if(day(today())>5 and
TODAYS MONTH IS NOT JANUARY ,
YearStart(AddMonths(Today(),-1)), 0 )
Qlik Sense
Thank you
try this
count( if( match( field1, 'abc') and field2= 'xyz' and YearStart(DateField)= if(day(today())>5 and
Month(Today())<>'JANUARY ',
YearStart(AddMonths(Today(),-1)), 0 )