# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
New Contributor II

## bar graph showing weird 0 values

hello everyone,

Something weird.

My graph shows bars but the calculated value is 0,

as shown in the attached picture.

I use these formulas in this graph:

If(sum({<Year={">=\$(=max(Year)-4)<=\$(=max(Year))"}>}GLE15_DB) > sum({<Year={">=\$(=max(Year)-4)<=\$(=max(Year))"}>}GLE15_CR),
sum({<Year={">=\$(=max(Year)-4)<=\$(=max(Year))"}>}GLE15_DB) - sum({<Year={">=\$(=max(Year)-4)<=\$(=max(Year))"}>}GLE15_CR)
)

Does anyone have an idea how this came to happen?

DC

Labels (2)

• ### Graph

2 Solutions

Accepted Solutions
Valued Contributor III

## Re: bar graph showing weird 0 values

it is number format issue

Channa
New Contributor III

## Re: bar graph showing weird 0 values

Hi,
Actually if you export the data to excel, it has the values decimals like 0.00000000372529030. Because of which its showing the bar.. May be you can use number function to round of the values: Num(your_expression,Yourformat) or Round(your_expression).
Hope this will help.

8 Replies
Esteemed Contributor

## Re: bar graph showing weird 0 values

create sample app and attach the same to have more clarity hard to check with this.

Vikas

New Contributor II

## Re: bar graph showing weird 0 values

Hello,

Is a duplicate of the app itself ok?

Valued Contributor III

## Re: bar graph showing weird 0 values

try to build table or KPI with this expression

see if it bring any value

Channa
Esteemed Contributor

## Re: bar graph showing weird 0 values

yes

duplicate and attach the same

Vikas

New Contributor II

## Re: bar graph showing weird 0 values

Also,

please click on Bruvatex button and select Debetsaldo from the drop down menu next to the graph:

Valued Contributor III

## Re: bar graph showing weird 0 values

it is number format issue

Channa
New Contributor II

## Re: bar graph showing weird 0 values

Indeed,

the money format gave some issues, number didn't.

Thanks

New Contributor III

## Re: bar graph showing weird 0 values

Hi,
Actually if you export the data to excel, it has the values decimals like 0.00000000372529030. Because of which its showing the bar.. May be you can use number function to round of the values: Num(your_expression,Yourformat) or Round(your_expression).
Hope this will help.