topic Re: Text To Number in QlikView

Text To Number

Mon, 21 Apr 2014 12:28:04 GMT

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.

Re: Text To Number

Mon, 21 Apr 2014 12:29:29 GMT

Can u post ur sample application?

Re: Text To Number

maxgro — Mon, 21 Apr 2014 12:32:06 GMT

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

Re: Text To Number

Mon, 21 Apr 2014 12:36:14 GMT

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.

Re: Text To Number

simondachstr — Mon, 21 Apr 2014 12:37:23 GMT

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".

Re: Text To Number

tresB — Mon, 21 Apr 2014 12:54:06 GMT

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

ashfaq_haseeb — Mon, 21 Apr 2014 12:59:11 GMT

Hi,

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

Hope it helped.

Regards

ASHFAQ