Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
h_prakash
Creator II
Creator II

Qlik Sense Measure Issue in Bar and KPI's

Hi All,

I am trying to calculate a measure Where I am need sum(A)-Sum(B). In this Instance Both the Values are same that is Sum(A)=Sum(B).

But When I Create a KPI to show Sum(A)-Sum(B) I am getting value of 0.06n. Please help in this regard.

Thanks

Hari

2 Replies
shraddha_g
Partner - Master III
Partner - Master III

There might be minor difference in decimal values of the A and B.

If you convert it to Interger or Decimal till 2 Values it will show as zero.

Try to round up values using Round().

For ex.

Round(86.656982, 0.01)

It will round up value till 2 decimal

h_prakash
Creator II
Creator II
Author

Thank you Shraddha for you suggesstion.