topic Re: Date gets changed while exporting into excel in QlikView

Date gets changed while exporting into excel

umamaheswarareddy — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am facing the following issue.

I have bar chart with weekend dimension and sum(sales) as expression. When i am trying to export or send to excel, the dates gets changed.

Please see below example.

Anil_Babu_Samineni — Wed, 01 Aug 2018 15:41:33 GMT

Does X-Axis is measure or simple field. Can you share sample file to test.

umamaheswarareddy — Thu, 02 Aug 2018 05:02:01 GMT

Hi Anil,

X-Axis has Dimension ie. Weekend

bwisealiahmad — Thu, 02 Aug 2018 07:15:22 GMT

Hi,

I suspect this might be a rounding issue.

What version of QlikView are you on?

Could you try to do:

Date(Floor([Week End])) AS Week End

and then try to export?

Best,

Ali A