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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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

Labels (1)
0 Replies