Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
dries_clairhout
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?

Thanks in advance

DC

0 values.png

Labels (2)
2 Solutions

Accepted Solutions
Channa
Valued Contributor III

Re: bar graph showing weird 0 values

it is number format issue

Channa
ashok_rajm
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
vikasmahajan
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 

dries_clairhout
New Contributor II

Re: bar graph showing weird 0 values

Hello,

 

Is a duplicate of the app itself ok?

Channa
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
vikasmahajan
Esteemed Contributor

Re: bar graph showing weird 0 values

yes

duplicate and attach the same

Vikas

dries_clairhout
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:

 

dd.png

Channa
Valued Contributor III

Re: bar graph showing weird 0 values

it is number format issue

Channa
dries_clairhout
New Contributor II

Re: bar graph showing weird 0 values

Indeed,

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

Thanks

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