Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
rwb139
Creator
Creator

'And' Conditional in custom field

How can I use the 'and' conditional in a custom field? I am trying to do so and it keeps giving me this error. Any help is appreciated!

rwb139_0-1605906750532.png

 

1 Solution

Accepted Solutions
rwb139
Creator
Creator
Author

Solved it by converting to this if statement:

 

if(QuarterStart(AddMonths(today(),-9))>=date(lease_from),if(QuarterStart(AddMonths(today(),-9))<=date(lease_to),'y','n'),
if(QuarterEnd(AddMonths(today(),-9))>=date(lease_from),if(QuarterEnd(AddMonths(today(),-9))<=date(lease_to),'y','n'),'n'))

View solution in original post

1 Reply
rwb139
Creator
Creator
Author

Solved it by converting to this if statement:

 

if(QuarterStart(AddMonths(today(),-9))>=date(lease_from),if(QuarterStart(AddMonths(today(),-9))<=date(lease_to),'y','n'),
if(QuarterEnd(AddMonths(today(),-9))>=date(lease_from),if(QuarterEnd(AddMonths(today(),-9))<=date(lease_to),'y','n'),'n'))