Export to CSV does not show full decimal value

[Anonymous]

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?

[Anil_Babu_Samineni]

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

[marcus_sommer]

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

[Anonymous]

No. I only use simple sum expression

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

please kindly check

thanks

[Anonymous]

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?

[marcus_sommer]

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

[qliksus]

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