Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
orangebloss
Creator
Creator

If statement with Two 'And' requirements

I'm wanting to filter my data so that only data that matches the following criteria is returned :

 

If the change flag is 'AN' and the Mod_status is greater than 6 and the Partcategory is either B or M but I keep getting 'AND is not a valid function' when I add in the MODstatus requirement/

 

if([BCD CHANGE_FLAG]='AN' and Mod_status={">6"} and ([BCD Partcategory]='B' or [BCD Partcategory]='M') ,[BCD COMPONENT])

Labels (2)
1 Solution

Accepted Solutions
Or
MVP
MVP

You seem to be mixing syntax between regular syntax and set analysis.

if([BCD CHANGE_FLAG]='AN' and Mod_status>6 and ([BCD Partcategory]='B' or [BCD Partcategory]='M') ,[BCD COMPONENT])

View solution in original post

2 Replies
Or
MVP
MVP

You seem to be mixing syntax between regular syntax and set analysis.

if([BCD CHANGE_FLAG]='AN' and Mod_status>6 and ([BCD Partcategory]='B' or [BCD Partcategory]='M') ,[BCD COMPONENT])

orangebloss
Creator
Creator
Author

Brilliant thank you!!