Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

Re: Match field value

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
Highlighted
Specialist II
Specialist II

Re: Match field value

Try "Map Using" table
Highlighted
Specialist III
Specialist III

Re: Match field value

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
Highlighted
MVP
MVP

Re: Match field value

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