Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
SkitzN27
Creator
Creator

Multiple If conditions with and

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

2 Replies
Chanty4u
MVP
MVP

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 )

SkitzN27
Creator
Creator
Author

Hi @Chanty4u 

How will I write this?

 

AND TODAYS MONTH IS NOT JANUARY OR FEBURARY