Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

nareshthavidish
Contributor 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
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])
3 Replies
techvarun
Valued Contributor II

Re: Match field value

Try "Map Using" table
Highlighted
mdmukramali
Valued Contributor 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
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])