topic Re: export to excel data problem in QlikView

export to excel data problem

Tue, 30 Aug 2016 05:52:06 GMT

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

Re: export to excel data problem

kaushiknsolanki — Tue, 30 Aug 2016 09:03:03 GMT

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

Re: export to excel data problem

Anonymous — Tue, 30 Aug 2016 09:15:06 GMT

Try this Macro

Re: need decimal values in Excel

Hope it helps

Re: export to excel data problem

Tue, 30 Aug 2016 09:26:31 GMT

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

Re: export to excel data problem

Tue, 30 Aug 2016 09:29:23 GMT

thank you for your replay, my problem is solved