Guage chart %

[dandaanilreddy]

Hello Qlik Developers

I have below information ( The values are examples in my case). I am not getting the correct result in the guage chart. Please look at the expression what i wrote below.

Total reported out cases = 17260

Total tbd cases = 2168

Calculated points = 17260-2168 = 15092

Points earned = 23203

Average is calculated below by taking points earned divided by (Total reported out cases minus Total tbd cases)

Avg= 23203/15092 = 1.53743705

Points for TBD cases will be calculated by total TBD cases * average value

2168*1.53743705 = 3333.16352

Total points = 23203+3333.16352= 26536.1635

For 92 days we have 148536 points

If I look till today what will be the goal point’s example 18 days the calculation is below

18*148536 divided by 92 = 29061.3913

% to plan as of today will be 26536.1635/29061.3912*100

=((count(distinct if(count_id=' ' And not Isnull(Bill_Type_Details),Reported_Out_case_id))*

(Sum(Points)/

(sum(goal_Reported_Out)-count(distinct if(count_id=' ' And not Isnull(Bill_Type_Details),Reported_Out_case_id)))))

+Sum(Points))

/

(Sum(goal)*(Today()-QuarterStart(Today())-2)/

(QuarterEnd(Today())-QuarterStart(Today())))*100

I am attaching my app. Can some one help me please in getting the correct result.

Thanks

Anil

[dandaanilreddy · Accepted solution]

Hello developers

I got the result

=((count(distinct if(count_id=' ' And not Isnull(Bill_Type_Details),Reported_Out_case_id))*

(Sum(Points)/

(sum(goal_Reported_Out)-count(distinct if(count_id=' ' And not Isnull(Bill_Type_Details),Reported_Out_case_id)))))

+Sum(Points))

/

(Sum(goal)*(vMaxReportedOutDate-QuarterStart(vMaxReportedOutDate)+1)/

(QuarterEnd(vMaxReportedOutDate-QuarterStart(vMaxReportedOutDate)+1)))*100

The result is 91.31071...

How to round this to 91.31.

Can someone help me. I tried number format its not happening.

Thanks

Anil

[Anil_Babu_Samineni]

What does it is?

vMaxReportedOutDate, Does it is same as Today() only / Different

[Frank_Hartmann]

Hi

num(91.31071,'##.##') = 91.31

hope this helps