Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
h_prakash
Contributor

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

Tags (2)
2 Replies
Partner
Partner

Re: Qlik Sense Measure Issue in Bar and KPI's

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
Contributor

Re: Qlik Sense Measure Issue in Bar and KPI's

Thank you Shraddha for you suggesstion.