Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
when I am exporting data from CHART, the data is exporting in form of TEXT value.
I need Numeric VALUE in excel...
can any one help??
Hi,
You can use the NUM function for this can you provide sample excel file that is exported.
Regards,
Anand
Hi,
If num() will work for you.
If it wont work then
Go to Help Menu-> about Qlikview->right click on Qlikview Symbol->You will get setting window
in that
ExcelExportMixedAsText change its value to 0 from 1
Regards
Hi,
Go to Settings -> User Preferences -> Export -> Number Formatting. Select Full Formatting.
Check if that helped
Qlikview sends to excel dimensions as text instead of num or date
Regards
ASHFAQ
For converting text to Number by exporting as excel do as Max suggested will be right way
Go to Help Menu-> about Qlikview->right click on Qlikview Symbol->You will get setting window
in that
ExcelExportMixedAsText change its value to 0 from 1
Regards,
Anand
Go to Help Menu-> about Qlikview->right click on Qlikview Symbol->You will get setting window
in that
ExcelExportMixedAsText change its value to 0 from 1