topic Send to Excel - Data Format Issue in QlikView

Send to Excel - Data Format Issue

Tue, 25 May 2010 06:35:29 GMT

Hi,

I have pivot table with some integer value, percentage (%) value and date. When i press the "Send to Excel", all the values are exported as number. Herewith i have attached the images for your reference.

Pivot Table

Exported Data

Regards

Rajesh

Send to Excel - Data Format Issue

Tue, 25 May 2010 07:06:54 GMT

Hi Rajesh,

This may be the problem, when you try to format the expression with two or more formatings.

One solution would be for this is enclosing the expression with text() function.


 text(if(Product = 'A',num(Sum (Sales),'##.00%'),num(Sum (Sales),'##.00')))

Check the attachment as well.

Hope this may help you.

-Peterson

Send to Excel - Data Format Issue

Tue, 25 May 2010 08:13:14 GMT

Thanks Kelvin.