Skip to main content
Announcements
New: No-code data prep in Qlik Cloud Analytics™ TAKE A TOUR
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

wrong values exported to excel

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:

ali_hijazi_1-1736438087836.png

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

ali_hijazi_2-1736438475142.png

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)

 

I can walk on water when it freezes
Labels (1)
1 Solution

Accepted Solutions
Bhushan_Mahajan
Contributor III
Contributor III

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

View solution in original post

5 Replies
Clement15
Partner - Specialist
Partner - Specialist

Hello,

Are your Qlik and your excel on the same UTC?

ali_hijazi
Partner - Master II
Partner - Master II
Author

I'm opening excel via local desktop app

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

I can walk on water when it freezes
Rutvik
Contributor
Contributor

Hello,

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

Rutvik_1-1736488003542.png

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

Thanks,

Rutvik.

 

 

Rutvik
Bhushan_Mahajan
Contributor III
Contributor III

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

ali_hijazi
Partner - Master II
Partner - Master II
Author

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 timeali_hijazi_0-1736491087811.png

 

I can walk on water when it freezes