topic Re: Export to CSV does not show full decimal value in QlikView

Export to CSV does not show full decimal value

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I usually used 'send to excel', but since my table has >256 columns, I start to use 'export' to csv

But the problem is, in CSV my value is not shown in full decimal value. For example:

Value in Qlikview Web Display: 3803

Value in Excel: 3802,5719534

Value in CSV: 3803

(please kindly find my sample file, that is part of my main qvw)

I need my value in csv to show full decimal value, like excel does.

Any idea?

Re: Export to CSV does not show full decimal value

Anil_Babu_Samineni — Tue, 26 Sep 2017 06:43:05 GMT

Have you use any SubField() function or Concat() in Report? Can you share sample application to send from our end

Re: Export to CSV does not show full decimal value

marcus_sommer — Tue, 26 Sep 2017 06:50:41 GMT

I assume the reason is that by a csv-export it exports the content like it's displayed within the table and not the values however they are formatted like by an excel-export. Therefore change the format within the (additionally) table (only for export-purposes) to expression-standard or to a decimal-format (you might need to adjust the decimal-delimiter, too maybe from comma to a point/dot to avoid trouble with the csv-delimiter).

- Marcus

Re: Export to CSV does not show full decimal value

Anonymous — Tue, 26 Sep 2017 07:27:04 GMT

No. I only use simple sum expression

I've attached the sample of my qvw in my question

please kindly check

thanks

Re: Export to CSV does not show full decimal value

Anonymous — Tue, 26 Sep 2017 07:38:03 GMT

I see..

But the problem is I want to show the value in million format. so I have to divide it by1000000

This makes the display value is not the original one.

Please kindly find the attachment in my question

Do you have any suggestion?

Re: Export to CSV does not show full decimal value

marcus_sommer — Tue, 26 Sep 2017 08:00:04 GMT

A quite common approach is to use different and specialized objects for printings/exports maybe within a special (and hidden ?) sheet than the normal user-objects. Further I'm not sure if it really made sense to use a table with more than 256 columns as a user-object - if the numbers are formatted in any way or not ...

Maybe changing columns into rows might be an alternatively.

- Marcus

Re: Export to CSV does not show full decimal value

qliksus — Tue, 26 Sep 2017 12:30:09 GMT

Create a small variable and use it in the expression like the below to switch to the required format when you export and use a small macro to export the object

if( VShow=1, sum(Amount), SUM(Amount)/1000000 )

sub export()

Activedocument.variables("VShow").setcontent "1" ,true
Activedocument.getsheetobject("CH02").export "C:\Users\AA\Desktop\test.csv",","
Activedocument.variables("VShow").setcontent "0" ,false

end sub