topic Number Format Issue in QlikView

Number Format Issue

Sat, 19 Jul 2014 06:25:39 GMT

Hi Everyone,

I have created a Bar chart to analyze the sales in different cities, where the problem is when Sales value is displayed in bar chart for a city say A the sales value is 7.85(after Formatting) , but when i export the bar chart to excel it gives the sales value as 7.85236214.

Can any one advice the reason behind this......? & suggest a way to rectify this issue.

Thanks

Re: Number Format Issue

kaushiknsolanki — Sat, 19 Jul 2014 06:32:09 GMT

Hi,

Use the "Number" Tab to format the numbers.

That will work

Regards,

Kaushik Solanki

Re: Number Format Issue

Sat, 19 Jul 2014 06:39:03 GMT

Hi Sathis Kumar

it is excel formatting issue. you need to check the Format Cell values in General Section. You need to define the Decimal place according to value you can define the place.

Hopefully when you export the bar chart to Excel it gives the sales value exact that you required.

Re: Number Format Issue

MK_QSL — Sat, 19 Jul 2014 07:17:11 GMT

You can have two different ways to get the proper format...

While loading itself in the script, use as below

NUM(SalesValue,0.01) as SalesValue

Use Something Like Below in Bar Chart Expression

=Num(SUM(Sale),'#,##0.00')

Re: Number Format Issue

Mon, 21 Jul 2014 04:20:29 GMT

Thank You Kaushik for your reply,

But the thing is i have formatted the sales value is the expression it self

say - Num(Sum(sales),'##,##0.00')

& I have selected Expression default option in the Number Tab.

but still the problem occurs when i export to excel.

Expecting your feedback.

Re: Number Format Issue

Mon, 21 Jul 2014 05:04:22 GMT

Thank You For your advice

It Works

Re: Number Format Issue

senpradip007 — Mon, 21 Jul 2014 05:08:43 GMT

Dear Satish.

If you get the correct answer, you should mark this thread as answered for others to learn.

Re: Number Format Issue

Mon, 21 Jul 2014 06:13:56 GMT

Thank You for Your Advice

its Informative.

Re: Number Format Issue

Mon, 21 Jul 2014 06:19:53 GMT

Hi Manish ,

Kindly Share the logic how NUM(SalesValue,0.01) works ....?

Manish Kachhia wrote:

You can have two different ways to get the proper format...

While loading itself in the script, use as below

NUM(SalesValue,0.01) as SalesValue

Or

Use Something Like Below in Bar Chart Expression

=Num(SUM(Sale),'#,##0.00')

Re: Number Format Issue

Mon, 21 Jul 2014 06:23:30 GMT

Hi Pradip

Am New to Qlikview (Community also). Can u advice me how to mark a thread as Answer ....?

Thanks

Re: Number Format Issue

its_anandrjs — Mon, 21 Jul 2014 06:39:43 GMT

Hi Sathis,

You have to use =Num(SUM(Sale),'#,##0.00') because after decimal you need 2 digits you can achieve the same from the chart properties >> Number >> Fixed to >> 2 Decimals.

And NUM is worked like when you pass SUM(Sale) expression values then the values get formatted after decimal place value 2 digits and you can increase this value also.

Hope this helps

Re: Number Format Issue

MK_QSL — Mon, 21 Jul 2014 07:55:40 GMT

Dear Sathis, I think my friend Anand has already written the logic.

Thanks Anand...

Re: Number Format Issue

Mon, 21 Jul 2014 08:48:17 GMT

OK its clear .....

Re: Number Format Issue

Mon, 21 Jul 2014 08:50:17 GMT

Its Clear now manish & thank you anand chouhan