topic Re: Fraction value issue in QlikView

Fraction value issue

soniasweety — Sat, 16 Nov 2024 18:52:00 GMT

Hi All,

i am using indicator image in text object with below expression. but it is showing wrong

using below exp:

=if((sum([ YGross Sales])-sum([ EGross Sales]))>0,'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png')

if differnace is zero result it will show Up arrow (green) if difference is negative value it will show down arrow(red)

but if i see the difference in excel its having fraction values very less number its showing red

i want to make it zero how to modify ,my expression.?

Re: Fraction value issue

Vegar — Tue, 31 Mar 2020 06:59:17 GMT

Your explanation isn't very specific, but I'll try to help you.

In order to get rid of your fractions you can use one of these.

If:
sum([ YGross Sales])-sum([ EGross Sales]) = 1250.691

Then:
floor(sum([ YGross Sales])-sum([ EGross Sales])) = 1250

ceil(sum([ YGross Sales])-sum([ EGross Sales])= 1251

round(sum([ YGross Sales])-sum([ EGross Sales])) = 1251

round(sum([ YGross Sales])-sum([ EGross Sales]), 0.01) = 1251.69

Re: Fraction value issue

soniasweety — Tue, 31 Mar 2020 07:59:27 GMT

Tried all those options still no luck now you can seee below . indicator is showing down arrow as it should show UP green as differance is 0 in 3rd column value.

Re: Fraction value issue

Vegar — Tue, 31 Mar 2020 11:09:45 GMT

What happens if you increase the number of decimals in all the three calculations. Or if you check if value 1 is equal to value 2?

-81.0=-81.0 is it true or false?

Re: Fraction value issue

sunny_talwar — Tue, 31 Mar 2020 11:24:35 GMT

Don't you need your condition to be >=, instead of just >

=If((sum([ YGross Sales]) - Sum([ EGross Sales])) >= 0, 'qmem://<bundled>/BuiltIn/arrow_n_g.png', 'qmem://<bundled>/BuiltIn/arrow_s_r.png')