Qlik Community

Qlik Design Blog

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

Employee
Employee

ICYMI: Not Another 2017 Year-In-Review Post

ny2018.pngWell guys - where do I begin? – Ah I got it, Happy New Year! <sigh> It feels like only yesterday that I was writing my first blog for 2017. However, after a long break, I’m excited to get back to work and contribute towards another prosperous year at Qlik! I didn’t want this to be another one of those “Year-in-review-type” posts…..so…I cleverly disguised it to highlight some of our product achievements during 2017. Think about it as a sitcom clip-show. So much Qlik goodness has transpired over the past year not only is it difficult to cover everything that has happened with the product, but as a consumer, I know it's difficult to keep track of it all, so I ‘ll do my best to summarize and consolidate where I can. This post is a bit long - so for some of you, I expect you to bookmark it and use it for later reference if needed.


ENTER TO WIN $50 Amazon Gift Card - Rules Below


So, let’s begin.

For those of you who want the short, short version:

  • Qlik GeoAnalytics
  • Qlik Sense 3.2
  • QlikView Converter
  • Qlik Sense Chat Bot
  • Data Connectivity
  • Qlik Sense June 2017
  • Advanced Analytics Integration
  • Qlik Sense September 2017
  • Qlik Sense November 2017
  • Qlik Sense Mobile
  • Qlik's Associative Difference

Qlik GeoAnalytics

Qlik GeoAnalytics Datasheet1-3.jpgIn January of 2017 – we kicked off the then new year with an acquisition of our Sweden-based partner, Idevio, creator of Idevio Maps. We introduced the recently acquired product as Qlik GeoAnalytics. Currently available as an extension for both Qlik Sense and QlikView, Qlik GeoAnalytics goes beyond traditional “points on a map” and adds a broader range of capabilities to support advanced geoanalytic use cases. During 2018 (no specific time-frame yet) we plan on integrating Qlik GeoAnalytics directly into Qlik Sense, so stay tuned.

ICYMI: Introducing Qlik GeoAnalytics

Qlik Sense 3.2

qlik_sense_3.2_highlights_0.jpg

Soon after, in March 2017 - we announced our first release of Qlik Sense for the year, version 3.2. 3.2 added the ability to easily create time-based measures (Calendar Measures), included additional chart options to support custom colors and color assignments, introduced the QlikView Converter and added a new configuration to improve the performance and stability of multi-node deployments (Shared Persistence)


ICYMI: Introducing Qlik Sense 3.2

The QlikView Converter

ui-qlikview-converter-example-01.png With version 3.2 we included a utility found in the Dev Hub that simplifies converting a QlikView document (.qvw) over to a Qlik Sense app (.qvf). You simply upload your .qvw to the converter to be analyzed, and it will extract the data model, script, measures, dimensions, expressions, variables and even compatible visualizations. The user can then choose what they want to convert to create a starter Qlik Sense app. Next they can create new or modify existing visualizations using the assets that were already available in QlikView.

ICYMI: QlikView converter - Qlik Sense - YouTube

Qlik Sense Chat Bot

1.pngApril 2017 set a new milestone for Qlik by pushing the boundaries of analytics.  We demonstrated the art of the possible using the Qlik platform, its awesome APIs, and various 3rd party technologies - to create the first ever Qlik analytics chat bot. Simply stated, imagine getting your answers to your business questions by asking your digital assistant. Since the original bot debuted at the Gartner BI Bake-off and Qonnections there has been tremendous interest in this concept, which has evolved rapidly over the 2nd half of 2017. There is now a new community group: https://community.qlik.com/groups/qlik-chatbots with many supporting resources and our own Todd Margolis is leading the charge to help enable our community to take advantage of our two open-source Qlik Bots.  Whether you’re a business user and want quick and easy access to your KPIs on the go or you’re a developer and want to extend them with new capabilities or integrate Qlik into your existing bots, we’ve got you covered.

ICYMI:

Data Connectivity

cloud+blog+2.pngOver the course of 2017 Qlik Sense and Qlik Sense Cloud had many improvements, especially in the area of connectivity. In May we introduced the first integration of our Web Connectors package to Qlik Sense Cloud – starting with access to Twitter, Facebook and Google Analytics.  Then in July we introduced on premise connections from Qlik Sense Cloud starting with MS SQL as well as the Web file connector. During 2017 we delivered over 20+ connectors to Qlik Sense and Qlik Sense Cloud Business including Dropbox, REST, Amazon Redshift, YouTube and many more.

ICYMI:

In addition to the aforementioned connectivity we also debuted our new release schedule and product naming convention when delivering Qlik Sense June 2017. No more dot releases for us – new releases are now identified by the month they are delivered in. June 2017 brought us new visualizations (Histogram, Distribution and Box plots), enhanced visual data preparation features that support data profiling and data quality and a new Advanced Analytics integration framework – allowing you integrate with advanced analytics engines such as R and Python.

7-20-2017+5-40-37+PM.png


Qlik Advanced Analytics Integration (AAI) enables direct server to server data exchange between Qlik Sense and 3rd party calculation / analysis engines via a connector or what we also call a plugin. So for example, a specific forecasting function that is part of an R library can now be called from within Qlik script and chart expressions and calculated on the fly. Passing the results back to the Qlik analysis engine and subsequent visualizations. With this capability we now support the APIs that provide connectivity to such engines and provide starter connector projects for R and Python.

ICYMI: Introducing Qlik Advanced Analytics Integration

Qlik Sense September and November 2017

9-5-2017 1-20-11 PM.png

Continuing our commitment to deliver iterative improvements and features every 10 weeks, we released our September and November 2017 releases, which introduced our new Waterfall chart, continuous transformations using visual data preparation, our Qlik Sense Mobile app, visualization and navigation improvements and the introduction of our extension certification pilot.

ICYMI:

Qlik Sense Mobile (offline)

552x414bb.jpg
Originally released to select participants in June, the Qlik Sense Mobile app for iOS became available to customers and partners in the Apple App Store later in the year. This iOS app enables its users to connect to their Qlik Sense Enterprise Server and download a local copy of their Qlik Sense app directly to their iOS device where they can analyze data on the device just as if they were connected to the server, allowing them to take Qlik Sense with them on the go in a disconnected state. (at this time Qlik Sense Mobile is for iPad only – a version for the iPhone is expected to be release early this this year.)

ICYMI:

Qlik’s Associative Difference

assoc_thumb.pngFinally, analytics is more than just creating charts, it’s about finding answers. Therefore, I’d like to give an honorable mention to our team, who has created resources to help our prospects, customers and partners clearly understand the benefits of Qlik’s Associative Difference, powered by our patented associative technology. Sometimes referred to by many different names (Associative Experience, Associative Model, Green-White-Grey), Qlik’s Associative Difference separates us from those traditional query-based visualization tools. Qlik’s Associative Difference allows you to explore data freely in any direction, automatically associating every dimension in the data model which visually reveals how the data are related using the colors green, white and grey - AND -  without leaving any data behind.

ICYMI:

Well guys – that’s it – your Qlik 2017 Year In Review – oh wait. - I said I wasn't doing a "year-in-review" post, ah @#$%&!.

Personal Giveaway Rules:

Do you have some interesting Qlik highlights or discoveries during 2017 that you would like to share? We want to know. Post them in the comments below OR if you would like to participate in my personal giveaway with a chance to win a $50 Amazon Gift Card (claim code) post a tweet using twitter http://twitter.com/ with your 2017 Qlik highlight or discovery and tag me using @mtarallo along with the hashtag:

#Qlik2017Highlights

...you will then be entered into a reviewed, random drawing to receive $50 Amazon Gift Card(claim code). Winner will be selected using Qlik's Twitter Connector and Qlik Sense app which will draw a random tweet using the hashtag: #Qlik2017Highlights. Winner will be announced on Twitter by @mtarallo on February 6th 2018 [UPDATE: Feb 13th 2018] and in the Tuesday edition of the Qlik Design Blog. Entry must be an interesting or valid Qlik highlight or discovery - if not it will be discarded and the next entry will be selected at random.

Contest starts Tuesday Jan 9 2018 and ends on Tuesday Jan 30 2018. We want to hear from you!

Enjoy!

Regards,

Michael Tarallo (@mtarallo) | Twitter
Qlik

28 Comments
YoussefBelloum
Esteemed Contributor

Hi mto‌, Happy new year

It is a summary "a year in review" extremely well detailed.

I look forward to what will come this year !

Thanks for sharing, very good job

57 Views

Qlik Highlights and Discoveries in 2017.

Qlik Sense Utilities.

On Demand App Generation

Extension Development

"Qlik Sense Admin Course" in Continues classroom.

57 Views
YoussefBelloum
Esteemed Contributor

mto question about the Qlik Geoanalytics, if you integrate it directly on Qliksense, it means it will be an out-of-the-box feature with qliksense tokens/ maybe with the desktop also ?

57 Views
Employee
Employee

Hi Youssef - yes, I believe that is the current plan. It most likely will be replacing the current map component, but it is still too early to dive into the details yet. As more information evolves over the year I will definitely update you and the community! Thanks for the question.

57 Views
YoussefBelloum
Esteemed Contributor

Excellent ! Ill make a Tshirt for it as soon as it comes out

57 Views
Employee
Employee

LMAO

57 Views
YoussefBelloum
Esteemed Contributor

I promiss   ... make the FLOWS free ! Make the FLOWS free !

57 Views
nikoskavroulaki
New Contributor II

Hi Michael and happy new year,

Thanks for summarising all the great things Qlik had done over the past year.

The integration of qlik geo analytics seems a great addition as the current mapping functionality is somewhat limited.

Talking about the future though I have two questions.

Is there a statement of direction 2018(it usually comes out on Jan) ?

Also when is the next QS release planned?

57 Views
Sajid_Mahmood
Contributor

Hi Michael and happy new year

I have two major requirements since last year.

Pivot Table major enhancement

Extensions Certified for Production Use

What features will include in Jan 2018 Qlik sense release

57 Views
Sajid_Mahmood
Contributor

Hi Michael,

I have a question which really surprises me and makes me think twice whether to move out of qliksense or not.

Why Qlik cannot make better visualizations  similar to VizLib a third party extension which is based on highly cost subscription based per tokens. We are already paying Qlik for tokens plus annual support then why to pay additional charge to third party of using much better extensions with tons of features compared to out-of-box features from Qlik

57 Views
Employee
Employee

Hi Nikolaos - great to hear - thanks for your comment - in regards to statement of direction - I will find out and the next release is planned for February - and it's looking pretty sweet.

0 Likes
57 Views
Employee
Employee

Hi Sajid - Happy New Year! - you have a valid point - I will see if I can get some answers for you. To clarify, there will not be a January 2018 release but rather a February 2018 release.

0 Likes
57 Views
Employee
Employee

Hi Nik - Statement of direction is being prepared as we speak and should be up this month I am told.

0 Likes
57 Views
Employee
Employee

Hi Sajid - we love VizLib and what they are doing - but there is more to this than just cranking out pretty data vizs  - there are certain standards that we must adhere to such as:

will it work offline, or on mobile devices, does it work with data stories, does it meet the responsive design specs for supported devices and screen resolutions, will it work with Qlik NPrinting, does it pass our certifications.etc.   Let me know if you have any other questions.

57 Views
dverbeke
Contributor III

Hi Michael,

I understand, but it would be a big benefit if the documentation was updated to create our own extensions to adhere to these new and more elaborate standards. I predict qlik sense + certified extensions to be on par with Tableau in no time.

I am missing:

* cool slider

* non horizontal Trendlines

* Drop downs

* Date picker

....

Kind Regards,

Dion

57 Views

mto‌ One of the most helpful and best thing about 2017 was your video's.

Those are amazing, it helped me to understand entire Qlik portfolio in better way.

Hope to see more in 2018.

Regards,

Kaushik Solanki

57 Views

mto Great Article and Globe altogether !! OH. I should've congratulate to you a part of sense.

OMG, I missed it !! * Happy New Year *

I would like to add some value points, Qlik has some features like array [{Hide and show}] And my question was Why not with Qliksense even Sense came after view only. It kills the performance if we have something called 3rd party tools (Extensions, Widgets., Vizlib (in place). but exclude Mashups (Really awesome)).

57 Views
Employee
Employee

Hi Dion - I can appreciate your statement. Being a Qlik advocate I have to say that we are WAY above par in many other areas over query-based data viz tools. Anyone can create pretty visualizations. I too scratch my head as to why some of these components are not available, but I trust that the company has a plan and knows what it is doing etc. - and I know they are investing in resources and technologies to meet the future needs of BI. So I know they rely on our valued partners to supplement certain areas where needed. QlikView has not had a default mapping component at all - but yet the product is still very successful in many organizations. Stay tuned for more greatness coming in 2018! I know you all will be pleased.

By the way - remember our patented associative difference, should always be a leading differentiation when compared to query-based tools.

57 Views
devarasu07
Honored Contributor II

Hi mto

Happy New Year! this article very informative. by the way just wanted to check whether below feature included in this Feb'18 batch?

FYI check the below link for the detailed issue.

Simple Table extension help

Thanks

Deva

57 Views
gamaescalante
New Contributor II

Love the way you share new info in a very visual and concise way!  Makes for consuming the data much easier and faster!

57 Views
Employee
Employee

Hey Gama - thanks!

0 Likes
57 Views
Employee
Employee

Hi Devarasu - thank you - unfortunately - using images in tables is not yes supported yet. I see you are using the Simple Table Extension and that you contacted the developer - have they contacted you in this regard?

Have you seen some of the other extensions that use images for data - perhaps you may want to investigate those.  Check out my sample retro-gaming app:

http://ec2-54-226-137-24.compute-1.amazonaws.com/sense/app/ccf7cbbc-53dc-4d39-a455-ce2d53b1df53/shee...

Note the bottom with the video title images, I am using an extension named: MSO Image Grid: Qlik Branch

I understand the simplicity of what you want - but being the extension was developed externally - that developer would need to add or adjust features.

57 Views
vangurideepu
Contributor

Hi Michael,

Congratulations and thanks a lot, Michael.

Providing such a wonderful growing Qlik technology in BI, I appreciate your endeavor with us.

QlikView supports Actions, why not in Qlik Sense.

Regards

Pradeep

0 Likes
57 Views
simondachstr
Valued Contributor III

Don't forget testing different browser, Chrome, IE, FireFox

0 Likes
57 Views
simonsunke
New Contributor II

Hi mto

Thanks for that great review-post! Made me go back and re-think some of the stuff I developed last year!
My highlight was the Histogram Chart (June 2017 release) - continues to save me lots of hours as we use them extensively.
However, there is one thing missing with them to make them perfect for me: vertical reference lines (Vertical Reference Line in Histogram). Is there a way to submit a feature wish for this?

Again, thanks for the great work to you and your team!
Regards, Simon

0 Likes
57 Views
Employee
Employee

Hi Simon - great to hear! Currently we really don't have a "community" ways to submit features - however I will enter it into our ideation system, where I will act as a liaison on your behalf. I have entered it for you - let's see and keep in touch with me from time to time.

57 Views

Hi mto‌,

Who earned your $50?

Regards,

Kaushik Solanki

57 Views
Employee
Employee

Hi Kaushik, et Aa - at this moment, I am verifying the randomly selected winner and will be announcing this in next Tuesday's design blog! - I loved doing this and the participation was excellent - I hope to do it again soon. I want to thank you all for submitting your awesome Qlik 2017 Highlights! I'll be running more of these in the near future so if you would like to participate, please join Twitter and follow me Michael Tarallo (@mtarallo) | Twitter - I have some tools that allow me to produce winner selection results (including Qlik Sense) and using Twitter makes it very easy and helps promote your own personal Qlik brand!  Thanks again guys!

57 Views