Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
@ali_hijazi Try applying floor function first and then Date function to From/To Dates.
Hello,
Are your Qlik and your excel on the same UTC?
I'm opening excel via local desktop app
Qlik sever is in Paris and I'm browsing the app from Beirut- Lebanon
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.
@ali_hijazi Try applying floor function first and then Date function to From/To Dates.
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