topic Re: timestamp to num conversion in QlikView

timestamp to num conversion

harsha087 — Fri, 03 Sep 2021 06:20:03 GMT

Hi ,

while converting the timestamp to num its giving incorrect number as shown below

Actual values for

26/04 - 44312

29/04 - 44315

kindly help me ..

Re: timestamp to num conversion

tresB — Fri, 03 Sep 2021 06:30:48 GMT

If you don't need the fraction value for the timestamp, try like:

Num(Floor(createdbydate)) as numcreate

Re: timestamp to num conversion

harsha087 — Fri, 03 Sep 2021 06:46:48 GMT

hi sir,

i have written same logic .. but still i am getting in correct num .

same as the screenshot given above ..

Re: timestamp to num conversion

harsha087 — Fri, 03 Sep 2021 06:50:19 GMT

when i write the same logic in the table chart as dimension i am getting correct numbers ..

second column as a calculated dimension

3rd columns .. same logic in script level

Re: timestamp to num conversion

tresB — Fri, 03 Sep 2021 07:21:20 GMT

Are you using any formatting function in script?

Re: timestamp to num conversion

harsha087 — Fri, 03 Sep 2021 08:39:58 GMT

Date(Floor(createdbydate), 'MM/DD/YYYY') AS [CREATED_DT]

Re: timestamp to num conversion

harsha087 — Fri, 03 Sep 2021 08:58:45 GMT

Actually my requirement is to get days between two days . But unfortunately, i was not able get the days incorrect due to create date into conversion in scripting level .

to get difference between two dates , i have written below logic

Ceil(Interval(Date(lastmodifieddate, 'DD/MM/YYYY hh:mm') - Date(createdbydate, 'DD/MM/YYYY hh:mm'), 'DD' ))

Re: timestamp to num conversion

tresB — Fri, 03 Sep 2021 09:46:29 GMT

What if you try like:

Interval(lastmodifieddate -createdbydate, 'D')

Re: timestamp to num conversion

MarcoWedel — Wed, 08 Sep 2021 19:44:17 GMT

your screenshot looks like there is each combination of field values generated in this table suggesting that there is an issue in your data model rather than a simple timestamp to integer conversion issue.

Can you check again how your numcreate field is generated?
Maybe it is in a different (island) table, the key fields are not properly generated or the numcreate field is not properly joined to the table that contains createdbydate ?

hope this helps

regards

Marco