topic Re: wrong values exported to excel in App Development

wrong values exported to excel

ali_hijazi — Thu, 09 Jan 2025 16:02:11 GMT

Hello
got a table in Qlik in which there are several columns and several expressions
all is good in Qlik
the first 3 column are the Month-Year, From, and To as per below:

some users export this table to Excel however, when the date value is end of month, it is exported as first day of the next month

Kindly advise on how to fix this issue
knowing that the From, and To are dates but numbers, so in the Dimension we put Date(From) and Date(To)

Re: wrong values exported to excel

Clement15 — Thu, 09 Jan 2025 16:21:59 GMT

Hello,

Are your Qlik and your excel on the same UTC?

Re: wrong values exported to excel

ali_hijazi — Thu, 09 Jan 2025 17:40:04 GMT

I'm opening excel via local desktop app

Qlik sever is in Paris and I'm browsing the app from Beirut- Lebanon

Re: wrong values exported to excel

Rutvik — Fri, 10 Jan 2025 05:48:37 GMT

Hello,

Please check what is the date format in Main Section, Is it below ( If not please set)

Also, In UI side use below Date(To) and try.

Thanks,

Rutvik.

Re: wrong values exported to excel

Bhushan_Mahajan — Fri, 10 Jan 2025 06:09:19 GMT

@ali_hijazi Try applying floor function first and then Date function to From/To Dates.

Re: wrong values exported to excel

ali_hijazi — Fri, 10 Jan 2025 06:38:59 GMT

well yes this works
I just noticed that the To has time as per below:
so I either use Date (floor(To)) or in the script I use Daystart(To) to reset the time