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
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,
Hi
Please try the
Num()
Function for the field
thanks
michael
Its just bcoz of its taking that as expression Default.
Go to Property
-Number Tab
- Select Integer
- Apply ok
Then try to export.
Regards,
Nirav Bhimani
Hi Michael,
The dimensions are defined using num() fun, but still it displays as text
Hi,
Go to properties -> Number -> select dimension or expression -> then select Number and in -> Format pattern type ###########
Hope this helps
Thanks & Regards
Hi Anand and Nirav,
The dimensions wont be visible in number tab and i am having a numeric calculated dimension
Hi,
Can you please share your file with small dataset.
Regards,
Nirav Bhimani
Also - (just to make sure)....
Go to User Preferences / Export.
In this tab there are options regarding Default Export Options.
Hi
i am adding a dummy report of similar kind
on exporting the chart the num values are presented as text
Hi Hamish,
i just gone through user preferences but no change