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: 
nareshthavidishetty
Creator III
Creator III

Match field value

Hi,

I have a date entry in my [calendar date ] as '31-12-1999 00:00:00'.

I need to make this entry to 'No Date'  at script level.

 

Thanks..

Labels (1)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

This value is actually equivalent to 366. So, if you really have dates in the field (not strings), you could try like:

If (num([calendar date])=366, 'NoDate', [calendar date])

View solution in original post

3 Replies
techvarun
Specialist II
Specialist II

Try "Map Using" table
mdmukramali
Specialist III
Specialist III

Hi,

If(Match([calendar date ] , '31-12-1999 00:00:00'),'No Date',[calendar date ]) as [calendar date ]

OR
If([calendar date ]='31-12-1999 00:00:00','No Date', [calendar date ]) as [calendar date ]

Thanks,
Mohammed Mukram
tresesco
MVP
MVP

This value is actually equivalent to 366. So, if you really have dates in the field (not strings), you could try like:

If (num([calendar date])=366, 'NoDate', [calendar date])