Export to Excel

[manojkulkarni]

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

[sunny_talwar]

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

[manojkulkarni]

Tried Same, but it didn't worked.

[ecolomer]

try to define Enter data no number without decimals

[mohammadkhatimi]

Hie..

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

Hope This will helps You..

Regards,

Mohammad.

[sunny_talwar]

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

In QlikView

Excel Export

[PrashantSangle]

Hi,

Try Floor()

like

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

Regards