Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dries_clairhout
Creator
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?

Thanks in advance

DC

0 values.png

Labels (2)
2 Solutions

Accepted Solutions
Channa
Specialist III
Specialist III

it is number format issue

Channa

View solution in original post

ashok_rajm
Contributor III
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.

View solution in original post

8 Replies
vikasmahajan

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

 

Vikas 

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
dries_clairhout
Creator
Creator
Author

Hello,

 

Is a duplicate of the app itself ok?

Channa
Specialist III
Specialist III

try to build table or KPI with this expression

see if it bring any value

Channa
vikasmahajan

yes

duplicate and attach the same

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
dries_clairhout
Creator
Creator
Author

Also,

 

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

 

dd.png

Channa
Specialist III
Specialist III

it is number format issue

Channa
dries_clairhout
Creator
Creator
Author

Indeed,

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

Thanks

ashok_rajm
Contributor III
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.