export to excel data problem

[#1]

hi all,

i have one pivot table  when am export to excel the numeric data will store into text

i want to store numeric in numeric only and accept only 2 digits after .(dot)

please help me

am attached that qvw

thanks in  advance

[kaushiknsolanki · Accepted solution]

Hi,

Use this expression for limiting the numbers to 2 decimal.

=round(if(SUm(RADat_DUE)-sum(if(RR_Receipt_date<=T_Date,RR_RECEIPT_AMT))<>0,SUm(RADat_DUE)-sum(if(RR_Receipt_date<=T_Date,RR_RECEIPT_AMT)))/Value,0.01)

When you do export to excel, all dimensions will be treated as Text and Expressions will be converted in to number.

Regards,

Kaushik Solanki

[Anonymous]

Hi

Try this Macro

Re: need decimal values in Excel

Hope it helps

[#4]

thank you kaushik.solanki but i done like

in help->about qlikview->rirht click on qlik logo-> i am set ExcelExportMixedAsText =0  after am using round function

now the values coming corectly

now numeric data coming in number format only

once again thank you kaushik.solanki

[#5]

thank you for your replay, my problem is solved