topic Re: how to create a calculation in script to check if field=date then y else n in QlikView

how to create a calculation in script to check if field=date then y else n

Nathan22 — Sat, 16 Nov 2024 00:15:11 GMT

Hi guys ,

i am facing problem in writing a logic as i am new to qlikview to check if the field imported from excel is a date or a text in date format then create a new column =y else new column =n .

Appreciate your help.

Re: how to create a calculation in script to check if field=date then y else n

dplr-rn — Mon, 27 Jul 2020 17:43:38 GMT

if the dates are in consistent format. you could try soemthing like below

If(IsNum(Date#(DateField,'dd/mm/yyyy')),'yes','no') as IsDate

if Datefield is 'adb' it will store no

if it is 21/11/2020 it will store yes

Re: how to create a calculation in script to check if field=date then y else n

Nathan22 — Tue, 28 Jul 2020 10:27:52 GMT

thanks for the reply.

but this formula doesn't work on the below data

Not Required for FSPO Treatment

04/09/2020

Re: how to create a calculation in script to check if field=date then y else n

Brett_Bleess — Tue, 11 Aug 2020 18:12:54 GMT

In this case I would recommend just doing a check if the first character is numeric or alpha and proceed from there...

The following Help link may put you on the right track, sort of from where the prior post was coming I believe:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/InterpretationFunctions/interpretation-functions.htm

Regards,
Brett

Re: how to create a calculation in script to check if field=date then y else n

Saravanan_Desingh — Tue, 11 Aug 2020 20:39:55 GMT

Try like this.

tab1: LOAD RowNo() As RowID,*, If(Text Like '*??/??/??*','Y','N') As Flag; LOAD * INLINE [ Text Not Required for FSPO Treatment Not Required for FSPO Treatment Not Required for FSPO Treatment Not Required for FSPO Treatment Not Required for FSPO Treatment Not Required for FSPO Treatment 04/09/2020 ];

Re: how to create a calculation in script to check if field=date then y else n

Saravanan_Desingh — Tue, 11 Aug 2020 20:40:42 GMT

Output.