set nulls to temporal values in data manager

[ioannagr]

Hello all.

I have a date field which is recognized correctly by qlik sense  as a temporal value field.

The thing is I want to manage some test data from my dataset e.g. some future dates and data manager won't let me do this. There isn't even an option as "set nulls" or "replace".

I tried treating it as a dimension but i don't think this is best practice.

Any ideas?

[treysmithdev]

I don't think there is currently a way to do it in the data manager unless you make a calculated field. 

Something like: 

If(Len([FieldName]) = 0, 'NULL VALUE',[FieldName]) as [FieldName]

Doing it in the script editor allows some more flexibility using NullAsValue.

[ioannagr]

Hello and thank you for the response.

I don't have blank field values, but some odd dates I want to set as null.

For example, 2062, 1113, that  are test data. Could I do:

If ( {<datefield={'3/3/2062', '01/01/1113','05/05/1113'}>}, 'null',datefield) as datefield ?

[treysmithdev · Accepted solution]

I would try using this:

If(Match(Text(datefield),'3/3/2062', '01/01/1113','05/05/1113') > 0, Null(), datefield) as datefield

[ioannagr]

Thanks! This worked. 😄