Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
yashcena
Contributor III
Contributor III

Properties of Circular Gauge representation in Pivot Chart

Hi,

I have the following data in my data model:

Resource NameProject TypeProject NameProjected HoursProjected DollarsActual HoursActual Dollars

I have ProjectedHours and ActualHours week-wise in my data model. I have taken the sum(ProjectedHours) and sum(ActualHours) directly in my attached sample data.

I have to show the how much is the Actual against Projected in a Guage chart inside Pivot Chart

Capture.JPG

The needle should move according to the Actual Hours.

Green: 0-65% Actual of Projected

Yellow: 65-90% Actual of Projected

Red: >90% Actual of Projected

However, the needles aren't moving correctly.  In the above snapshot,

136 Actuals is about 65% of the Projected. So the needle should be in yellow zone

235 Actuals is about 90% of the Projected. So the needle should be in red zone.

I have attached the sample app. Can someone please help?

Thanks,

YASH

1 Solution

Accepted Solutions
neelamsaroha157
Specialist II
Specialist II

Check this -

Change your expression to  -

=num(Sum([Actual Hours])/ sum([Projected Hours]),'##%')

View solution in original post

2 Replies
neelamsaroha157
Specialist II
Specialist II

Check this -

Change your expression to  -

=num(Sum([Actual Hours])/ sum([Projected Hours]),'##%')

yashcena
Contributor III
Contributor III
Author

Thank you so much Neelam...really appreciate it!