topic Export to excel - Decimal and integer in the same column in QlikView

Export to excel - Decimal and integer in the same column

malin_ortengren — Tue, 02 Apr 2013 08:02:38 GMT

Hi,

I have columns in a table that contains both decimal and integer. It is a incomestatement with both ratios and lines.

To format this the function num() is used today:

if(right(Summeringsrubrik,1)='%',num(((sum({$<Procentuträkning={"T"}>} Belopp)/sum({$<Procentuträkning={"N"}>} Belopp))*100),'# ##0,0')&'%',

num(sum(Belopp),'# ##0'))

Unfortunately,when exporting to Excel the value is presents as text instead of numbers.

Does anyone have a good solution to this?

advait_thakur — Tue, 02 Apr 2013 08:22:40 GMT

Hello Malin,

could you please post your sample application file..!!

Thanks

Advait

malin_ortengren — Tue, 02 Apr 2013 09:00:59 GMT

Hi,

Here is an example with my problem.