Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am using a pivot table in one of my doc and in dimensions one of the dimension is calculated dimension which is in number format
On exporting to excel, values of the calculated column is presented as text and options it pop outs as follows
Please help on this
In the calculated dimension, try multiplying the entire result by 1
(exp)*1
Right click on the table-> Copy to Clipboard->Full Table, and then paste in excel.
Sorry Graeme,
Even that didnt work.
More over the calculated dimensions are using num() function
This works fine as a developer prospective.
But by end user prospective its not suggestable
Hi,
You can do this thing by go to,
Help->About Qlikview->(Right Click on) Qlikview Symbol(On Left Bottom)->ExcelExportMixedAsText(Select)->Set its value as 0 ->Set->Close
Save your qlikview Document and then Export chart to Excel,
This will surely help you
Regards,
Thanks Max.
This works fine.
But will this effect any other properties in the document
Hi,
See the attached snap and change value here Max is given answer for this
Hope this helps
Thanks & Regards
Hi,
It will affect on only those data who have combination number and string .
Other wise it works fine
Regards,
another question: I had saved this file and distributed to some users.
From accsspoint if i export to excel will it work
Hi,
As per my knowledge it should work.
Regards,