topic Match field value in QlikView

Match field value

nareshthavidishetty — Sat, 16 Nov 2024 04:10:50 GMT

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..

Re: Match field value

techvarun — Thu, 14 Mar 2019 04:58:38 GMT

Try "Map Using" table

Re: Match field value

mdmukramali — Thu, 14 Mar 2019 04:59:17 GMT

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

Re: Match field value

tresB — Thu, 14 Mar 2019 06:48:44 GMT

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])