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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to exclude a Date Range

Hi

I have an expression for calulation of IDs. Given below is the expression

IF( Type = 'Error' AND

      Status = 'Yes' AND

       Condition3,

   Id,Null( )

   ) 

In condition3 i want to compare a Date Variable with two date values in such a manner that

Date is not in range (date1,date2). What is the helpful function or logic to achive this.

Kindly help

Regards

Tribhuwan

0 Replies