topic Re: Export to Excel in QlikView

Export to Excel

manojkulkarni — Tue, 11 Aug 2015 04:55:41 GMT

Good Morning All,

I have data in straight table with fixed format for numbers (i.e #,##0). I am not displaying decimals here. But requirement is when we export same data it should show decimal values as well. How can we do this

Re: Export to Excel

sunny_talwar — Tue, 11 Aug 2015 05:00:17 GMT

I think if you format the expression from expression tab, it doesn't hold the formatting when exported out whereas Number's tab formatting holds for export as well.

Try this:

Set expression's default on Number tab and then change your expression to this -> Num(YourExpression, '#,##0')

Hopefully this will help.

Best,

Sunny

Re: Export to Excel

manojkulkarni — Tue, 11 Aug 2015 05:31:13 GMT

Tried Same, but it didn't worked.

Re: Export to Excel

ecolomer — Tue, 11 Aug 2015 05:34:06 GMT

try to define Enter data no number without decimals

Re: Export to Excel

mohammadkhatimi — Tue, 11 Aug 2015 05:35:44 GMT

Hie..

Try from Chart Proerties --> Number Tab --> Click Integer Radio button and format it...

Hope This will helps You..

Regards,

Mohammad.

Re: Export to Excel

sunny_talwar — Tue, 11 Aug 2015 05:48:42 GMT

Try the exporting the straight table from the attached qvw file. It seems to work

In QlikView

Excel Export

Re: Export to Excel

PrashantSangle — Tue, 11 Aug 2015 05:54:49 GMT

Hi,

Try Floor()

Num(Floor(fieldName),'#,##0')

Regards