Qlik Community

Qlik Design Blog

All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.

Employee
Employee

Google Gauge - A Qlik Sense Extension

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
36 Views
thornofcrowns
Valued Contributor 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
36 Views
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
36 Views
b_garside
Valued Contributor

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.

36 Views
thornofcrowns
Valued Contributor II

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

0 Likes
36 Views
Employee
Employee

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

0 Likes
36 Views
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
36 Views
paulyeo11
Valued Contributor II

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
36 Views
Not applicable

Nice work, Yianni. Will look forward to the update

0 Likes
36 Views