topic Re: Help Needed in App Development

Help Needed

saik — Sat, 16 Nov 2024 03:25:08 GMT

Hi Team,

I have a query related to Dates . Please go through below

I have a Date Field which is in the format of 1/15/2020 8:04:19 AM . I have to create a new field from this like Date +72 hours(i.e 3 days).

Please suggest me some function to do this Job

Note : I am Novice User to qlik

Thanks.

Re: Help Needed

pjaredchurch — Wed, 29 Jan 2020 18:40:36 GMT

To be string, this should work:

date#(<your_field>,'M/D/YYYY h:mm:ss tt')+3

Qlik doc's here

https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Scripting/InterpretationFunctions/date_hash.htm

You may find that you can just do:

<your_field>+3

In Qlik Sense dates are actually stored as numbers and 1 = 1 day, 0.5=12 hours etc.

Re: Help Needed

saik — Thu, 30 Jan 2020 07:29:02 GMT

Hi,

I am not able to get the expected result. Could you help me on this.

Re: Help Needed

UserID2626 — Thu, 30 Jan 2020 10:28:24 GMT

Set expression:

Timestamp(Max([Date_Field])+72/24,'D-MMM-YYYY h:mm:ss tt')

Timestamp(Max([Date_Field])+3,'D-MMM-YYYY h:mm:ss tt')

In Script:

LOAD
Business_Date as Date,
Timestamp(Business_Date+3,'D-MMM-YYYY h:mm:ss tt') as "Third Day",
Timestamp(Business_Date+48/24,'D-MMM-YYYY h:mm:ss tt') as "Second_Day",
//1/15/2020 8:04:19 AM
Pack as "Pack Type",
Pack,
Amount
FROM [lib://Path/Combochart Sample.xlsx]
(ooxml, embedded labels, table is Sheet1);

Re: Help Needed

saik — Thu, 30 Jan 2020 13:41:24 GMT

Team,

Thanks for your time to reply . I got Solution using Date() Function.

Return to Service( Date Field) : 2020-01-13 2:30:00 AM

date ( [Return to Service]+3,'YYYY-MM-DD hh:mm:ss tt')

Thanks.