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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adding an or condition to logic

Here is a snippet of code

if((len(trim([First CK249 Date])) >=1 and len(trim([MED249 Date])) >=1),

I want to add (len(trim([First CP249 Date) to the code above as an or statement

Can I just add the logic like this

If (len(trim([First CK249 Date],[First CP249])) >=1 and len(trim([MED249 Date])) >=1),

Or would I need to add a completely new or statement applying the same len function to CP249 Date.

1 Reply
anbu1984
Master III
Master III

If ((len(trim([First CK249 Date])) >=1 or len(trim([First CP249])) >=1)and len(trim([MED249 Date])) >=1)