Discussion board where members can get started with QlikView.
when I just use date field from Dimension and export the table to excel everything working well.
but as soon that I am using a formula
When Actual is a variable ==> 1/2/2015
and export to excel than the format in excel not ok.
I mean when I am filtering the date I don't see group like we should see for date "Year / month and than date"
but I see a lot of lines of date, You can see the picture attached.
I don't know what to do.
I hope that it was clear
Your dates are coming into Excel formatted as Text.
To convert in Excel, click column A and chcnge the format to Short Date.
Then select Data|Text to columns and click Finish
Instead of using Send to Excel:
If you are using the IE PlugIn, you can right-click and choose Copy to Clipboard|Full Table. Then paste into Excel
Right-Click and Export to csv. Then open in Excel.
View solution in original post
THANKS A LOT
I was stuck with this during a long time,
HAVE a very nice weekend and thank you again