Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Text To Number

Hi,

When my report is exported to excel, certain columns are in text format. I tried to change them to number format by using NUM function and Number Tab. After using both the things, this is not getting converted to number. I used following expression in my sheet object(Pivot table) .

=num(Count ({ $ <[Deleted] = {'No'} > } DISTINCT [Key]))

Kindly suggest me any ideas.

Thanks,

Sindhu.

Tags (3)
6 Replies
Not applicable

Re: Text To Number

Can u post ur sample application?

MVP
MVP

Re: Text To Number

try this

- remove num in expression

- format the field in Number tab of the chart

there is also a number formatting for export in

menu --> user preferences --> export tab

Not applicable

Re: Text To Number

Hi,

I even removed num in expression and formatted in number Tab. The results are same.

Kindly note that I'm using Pivot Table.

Thanks,

Sindhu.

Luminary
Luminary

Re: Text To Number

Question here:

Do you get the same behaviour when:

1) Using "Send to Excel" button on the caption

2) Right-click, Export as .xls file

3) Right-click, Copy to Clipiboard, Full table.

Another idea:

Try to format your column in the properties tab explicitly as "Number".



MVP
MVP

Re: Text To Number

Goto Help->About QlikView->Click on QlikView image on the bottom left corner-> Select 'ExcelExportMixedAsText' -> Set it's value to 0(zero).

Re: Text To Number

Hi,

I would say overwrite the setting to number as shown in attached image.

Hope it helped.

Regards

ASHFAQ

Community Browser