topic Re: Getting timestamp in QlikView

Getting timestamp

Fri, 15 May 2015 10:06:51 GMT

Hi All,

Is it possible to compare the date time format of a field?

e.g. if datetime format is in DD-MM-YYY hh:mm:ss TT, then 'Y' else 'N' in the field Check should be created.

Thanks,

Asma

Re: Getting timestamp

sunny_talwar — Fri, 15 May 2015 10:12:12 GMT

You might be able to do this:

If(IsNum(Num(Date#(YourDateField, 'DD-MM-YYY hh:mm:ss tt'))), 'Y', 'N')

Best,

Sunny

Re: Getting timestamp

anbu1984 — Fri, 15 May 2015 10:13:57 GMT

=If(IsNum(Timestamp#('01-01-2010 01:10:10 AM','DD-MM-YYYY hh:mm:ss TT')),'Y','N')

Re: Getting timestamp

jagan — Fri, 15 May 2015 10:23:13 GMT

Hi,

Try like this

Arriving a flag in script will have better performance in front end.

LOAD

If(TimeStamp#(DateFieldName, 'DD-MM-YYY hh:mm:ss TT'), 'Y', 'N') AS Flag

FROM DataSource;

Now use this flag in set analysis like below

Count({<Flag={'Y'}>} SomeDimension)

Regards,

Jagan.

Re: Getting timestamp

Anonymous — Fri, 15 May 2015 11:30:52 GMT

Hi Asma,

You can check the Date Format or Date-Time Format with the help of Alt function.

Please refer to attached image for detail:

Thanks & Regards
Prince Anand

Re: Getting timestamp

Fri, 15 May 2015 11:45:14 GMT

Is it possible to get the DateFieldName from a variable?

e.g. If I use

let vColumnName=FieldName(1,'Test') as [Column Names]

vColumnName would store the column name.

Now can I use the below expression for checking the datetime format

If(TimeStamp#(vColumnName, 'DD-MM-YYY hh:mm:ss TT'), 'Y', 'N') AS Flag

Re: Getting timestamp

Anonymous — Fri, 15 May 2015 11:56:19 GMT

Yes Asma You can get the column name by using fieldname function and store it in a variable like show below:

set vStartDate=makedate(2015,05);

Calendar:

load date($(vStartDate)+RecNo()-1,'DD-MM-YYYY') as Date

AutoGenerate makedate(2015,05,15)-$(vStartDate)+1;

let vColName=fieldname(1,'Calendar');

and then use the alt function as describe above.

Thanks & Regards

Prince Anand

Re: Getting timestamp

jagan — Tue, 19 May 2015 08:08:00 GMT

Hi,

Try like this

If(TimeStamp#($(vColumnName), 'DD-MM-YYY hh:mm:ss TT'), 'Y', 'N') AS Flag

Regards,

jagan.

Re: Getting timestamp

Sat, 06 Jun 2015 11:47:39 GMT

The above expression is not working.

It always returns N

Re: Getting timestamp

anbu1984 — Sat, 06 Jun 2015 14:16:16 GMT

Can you post sample input