Skip to main content
Yianni_Ververis
Employee
Employee

Since my last blog where I created a Google Annotation Chart (Google Annotation Chart - Qlik Sense Extension and Angular Directive), I thought it would be interesting to add more extensions based on Google's visualization library.

Here I created a simple gauge based on Google's Gauge found at Visualization: Gauge  |       Charts  |       Google Developers.

  • Download the zip file as found at the end of this blog,
  • unzip it in your extensions folder, C:\Users<user>\Documents\Qlik\Sense\Extensions\GoogleGaugeChart
  • Open your Helpdesk app and drag and drop the extension into the canvas
  • As for the first measure put
    Count( {$<Priority={'High'}, Status -={'Closed'} >} Distinct %CaseId )
    with a label "High Priority Cases"
  • For the second measure, put
    Count( {$<Status -={'Closed'} >} Distinct %CaseId )
  • with a label "Total Closed Cases"
  • Make selections and see the Gauge animate

preview.png

Coming up: Extension settings...

Branch: http://branch.qlik.com/#!/project/57b76c10b3122e2cd1e7305d

Yianni

9 Comments
Not applicable

GREAT!!!

0 Likes
1,351 Views
ThornOfCrowns
Specialist II
Specialist II

Whilst this looks lovely, it still needs the big 72 to show the actual number. This is my greatest bugbear with gauges!

0 Likes
1,351 Views
Yianni_Ververis
Employee
Employee

Hello James,

What do you mean? The 72 in the Gauge is the same as the one from the KPI in the helpdesk app...

Yianni

0 Likes
1,351 Views
b_garside
Partner - Specialist
Partner - Specialist

I think what James is saying is the 72 in the gauge is barely noticeable at first glance, hence the need for the large text KPI on the left.  Thanks for the post.

1,351 Views
ThornOfCrowns
Specialist II
Specialist II

That's exactly what I meant, Brian, thanks for the clarification.

0 Likes
1,351 Views
Yianni_Ververis
Employee
Employee

I am working on it. Unfortunately, we do not have much flexibility with google charts!

0 Likes
1,351 Views
Yianni_Ververis
Employee
Employee

OK please try and use it now. I Increased the font size but I removed the label from inside the Gauge. You will have to put it in the title....

Let me know if you like this more

Yianni

0 Likes
1,069 Views
paulyeo11
Master
Master

Hi Yainni

I think you should not removed the label from inside the Guage. Because if you remove you need create additional label , which occupy space , just remove the large text on the left.

Paul

0 Likes
1,069 Views
Not applicable

Nice work, Yianni. Will look forward to the update

0 Likes
1,069 Views