Number Format Issue

[#1]

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

[kaushiknsolanki]

Hi,

     Use the "Number" Tab to format the numbers.

     That will work

Regards,

Kaushik Solanki

[#3]

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.

[MK_QSL]

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')

[#5]

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.

[#6]

Thank You For your advice

It Works

[senpradip007]

Dear Satish.

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

[#8]

Thank You for Your Advice

its Informative.

[#9]

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')

[#10]

Hi Pradip

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

Thanks