Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Re: Date gets changed while exporting into excel

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

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)

Re: Date gets changed while exporting into excel

Hi Anil,

X-Axis has Dimension ie. Weekend

Partner
Partner

Re: Date gets changed while exporting into excel

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