Having an issue with send to excel option.
The date column in report is in the format (DD-MM-YYYY), but when the data is being exported to excel the all the dates get converted to text. This is not limited to any one report or application, it is happening to all the applications and has started happening from yesterday and no settings has been changed on the server.
Even when exporting the date values of a list box the data is getting converted to text format.
Woking on QV11 SR2.
Early response is appreciated!
Solved! Go to Solution.
chart properties-> caption->Copy Data
then at right corner of chart click on copy to clipboard and then paste to excel
hope this helps
We have QlikView version 11.2 SR10 but still Date does not export as date. It is getting exported either as a text or number. Any solutions?
Go to document properties - Numbers.
You will find all the dimentiones listed on the left.
Select your required dimention from the left. And give it the desired
format from the right.
This should solve your problem.
#+91 99 58 458381
sent from mobile device.