Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pascaldijkshoor
Creator
Creator

AND/OR functions in the data manager

Hello,

I want to add a calculated field in the data manager. This new column will contain an if formula with an AND and OR condition. However the set expressor in the data manager does not recognize AND/OR functions. Is there a trick to bypass this problem?

Regards,

Pascal

1 Solution

Accepted Solutions
sunny_talwar

May be this

If(LOAD_Index >= 4,

     If(LOAD_Index >= 12, 1, If(Right(Com_Code, 1) = 'e', 1, 0)))    

View solution in original post

4 Replies
sunny_talwar

What is your condition that you have to use?

pascaldijkshoor
Creator
Creator
Author

This is the formula i want to add:

IF (LOAD_Index >=12 OR Right (Com_Code, 1) = 'e' and LOAD_index >=4,1,0)

sunny_talwar

May be this

If(LOAD_Index >= 4,

     If(LOAD_Index >= 12, 1, If(Right(Com_Code, 1) = 'e', 1, 0)))    

pascaldijkshoor
Creator
Creator
Author

Thanks! This works perfect.