Date gets changed while exporting into excel

[umamaheswarareddy]

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]

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

[umamaheswarareddy]

Hi Anil,

X-Axis has Dimension ie. Weekend

[bwisealiahmad]

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