# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
cancel
Showing results for
Did you mean:
Creator

## 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
Specialist III

it is number format issue

Channa
Contributor III

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
MVP

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

Vikas

If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
Creator
Author

Hello,

Is a duplicate of the app itself ok?

Specialist III

try to build table or KPI with this expression

see if it bring any value

Channa
MVP

yes

duplicate and attach the same

Vikas

If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
Creator
Author

Also,

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

Specialist III

it is number format issue

Channa
Creator
Author

Indeed,

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

Thanks

Contributor III

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.