Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

malin_ortengren
New Contributor

Export to excel - Decimal and integer in the same column

Hi,

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

Exempel tabell.PNG

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?

Tags (4)
2 Replies
advait_thakur
Contributor III

Re: Export to excel - Decimal and integer in the same column

Hello Malin,

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

Thanks

Advait

malin_ortengren
New Contributor

Re: Export to excel - Decimal and integer in the same column

Hi,

Here is an example with my problem.

Community Browser