Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
umamaheswarareddy
Partner - Contributor
Partner - Contributor

Date gets changed while exporting into excel

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.

Export Issue.jpg

3 Replies
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
umamaheswarareddy
Partner - Contributor
Partner - Contributor
Author

Hi Anil,

X-Axis has Dimension ie. Weekend

bwisealiahmad
Partner - Specialist
Partner - Specialist

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