2017

It's time for the end-of-the-year in review post, it's time for the cream of the crop.

 

During 2017 six main authors and a respectable number of guest bloggers posted a total number of 85 articles (plus this one).

 

We wrote 39,822 words (7,819 distinct words), that’s 15% more than the number of words we wrote previous year. We wrote the word “Qlik” 566 times, an absolute record. You contributed 695 times to the success of this blog in the comments section, we truly appreciate your feedback and comments!

 

1.png

 

Most popular posts in 2017

 

Most read/visited posts

Don't be the last one to read it!

 

  1. Qlik Sense September 2017 - What's New
  2. Quotes in Set Analysis
  3. Push the Boundaries of Analytics - Qlik Sense Bot (video)
  4. Take a look at Qlik Sense June 2017
  5. Introducing DAR mashup template

 

Most commented posts of the year

Everyone is buzzing

 

  1. Quotes in Set Analysis
  2. Introducing Qlik Sense 3.2
  3. Take a look at Qlik Sense June 2017
  4. Qlik Sense September 2017 - What's New
  5. Push the Boundaries of Analytics - Qlik Sense Bot (video)

 

The underdogs 2017

They worth a second read.

 

  • Qlik Sense WordPress Plugin
    The world most popular CMS and the most powerful Analytics platform combined? it seems like a perfect match. This blog post is capturing a lot of comments, check it out and join the conversation.
  • Rank Function
    Some of the old Qlik functions still have secrets, check this post to learn what you are missing from the Rank function.
  • Intro to Qlik Open Source Software
    It feels great to contribute to the Open Software community, read what Qlik has to offer!
  • Salesforce and CIO dashboard mashups available to the public
    You can use these examples as templates or just dissect them into pieces to learn more about Qlik APIs and how to build impacting data sites.

 

 

I wish you an enjoyable New Year countdown!

Arturo (@arturoqv)

Wow! There are some really mind-blowing trends developing in BI and data analytics. Here are a few that have me the most excited, and my favorite examples of each from the past year.

 

Augmented Analytics

artificial-intelligence-2228610_640.jpg

Augmented intelligence incorporates machine learning to supplement and support human analysis. Qlik Sense is now capable of Advanced Analytics Integration through the use of server-side extensions, and Qlik Sense + Advanced Analytics = Augmented Intelligence. Go get started augmenting your own intelligence today, using Qlik Sense Advanced Analytics Toolbox.

 

speech-bubbles-303206_640.png

Conversational Analytics

As virtual assistants like Alexa and Google Assistant and chatbots in messaging services like Slack and Telegram become more ubiquitous, interest in conversational analytics continues to grow. Conversational analytics is the ability to provide a query in natural language, either spoken aloud or as text, and receive a response. The ability to simply ask a question and get an answer about your data is pretty cool. Ask some questions and get some answers by trying out QlikBotNode.

 

Immersive Analytics

thumbnail.png

Immersive analytics utilizes virtual and augmented reality to enable analytics in immersive environments. While widespread adoption of immersive analytics may be a little further off that either augmented intelligence or conversational analytics, the possibilities are truly exciting. Immerse yourself today and take a glimpse into the future with Qlik Healthcare Analytics AR.

vik.png

 

Hi Guys, we are almost at the finish line for 2017! So roll up your sleeves and get ready to show off that Qlik creativity and passion as we are ready to start accepting applications for our 2018 Qlik Luminary program. Here to tell you more is our Global Customer Communications Manager, Viktoria Lindback.


Viktoria Lindback has had many roles during her 5-year tenure at Qlik. Today, she runs global customer programs including the https://www.qlik.com/us/solutions/customers/qlik-luminaries which means she gets to spend the majority of her time interacting with the most enthusiastic Qlik users around the world.

 

If you haven’t heard of the Qlik Luminary Program yet, this is a great time to get educated about it because we’re accepting applications to the 2018 Qlik Luminary Program as we speak!

 

IMG_3397.JPG

Click here to see our awesome Qlik Luminary Class of 2017

 

Every year, we roll out the green carpet to a remarkable group of people who all receive the “Qlik Luminary” designation. With deep drive, passion and expertise, Qlik Luminaries are constantly pushing the envelope, finding new and innovative ways to use, deploy and talk about Qlik solutions. Some of them are BI thought leaders; others are recognized industry visionaries, business leaders, or masterful developers. But what they all have in common is a passion for innovating with Qlik and sharing their expertise with others in a global arena. You will catch them speaking at events, running Qlik Dev Group, writing blog posts, contributing to case studies, and participating in Qlik Community and other social networks. A great place to follow their work is #QlikLuminary on Twitter.

 

Here are some of the characteristics of a Qlik Luminary:

  • Passionate about Qlik and widely recognized as a BI innovator and expert in his or her field
  • Active and consistently helpful on Qlik Community
  • Active on online forums, industry social networks, and/or organizational or personal blog
  • Willing to share best practices and knowledge at industry events, forums, in the press, and with industry analysts
  • Prolific content creator who creates or contributes to blogs, white papers, reviews, articles, videos, etc.

There are also plenty of benefits to being a Qlik Luminary. They enjoy free access to state of the art Qlik training, custom merchandise, exclusive engagements with R&D, Product Management, and Support teams, membership in a private Qlik Community group, NDA briefings with Qlik product executives, and VIP treatment at Qonnections.

 

 

We are accepting applications for the 2018 cohort until December 31st here: https://www.qlik.com/us/solutions/customers/qlik-luminaries


Don't miss your chance to join a group of the sharpest brains and most skilled users in the BI industry!

 

Kinds Regards,

Viktoria (@VLindback) | Twitter
Global Communications Manager
Qlik

Today I thought I would share how I used the system functions OSUser() and DocumentName() in a Qlik Sense app.  Here is some background on the app - the app resides on a server and users must log in to access it.  Users can have multiple copies of the app and each file name is unique.  The app allows users to store the results of their analysis in QVDs and I wanted the QVDs to include the QVF name/id as well as the logged in user name to ensure that there is one set of QVDs per app.  To do this, I used the OSUser() and DocumentName() functions.


Let’s learn a little more about these functions.  According to Qlik Sense Help, OSUser() returns the name of the user currently connected and DocumentName() returns the name of the current Qlik Sense app.  In the script below, I created variables that store the results of these functions.

script.png

OSUser() returns a string formatted like this:

UserDirectory=xxx;UserId=xxx

 

This is what I stored in the vFullUser variable.  Then in the vUser variable, I used the Right, Len and Index functions to capture just the UserId portion of the string.  DocumentName() returns the app ID for the QVF.  I use the vUser and vAppName variables later in the script when I am storing the data into QVDs.  Below is an example of what that script looks like.  I append the user ID and the app ID to the name of the QVD.

store.png

Qlik Sense offers many system functions that can be used in both the script and chart expressions to provide system, device and Qlik Sense app properties.  Here is a list of the available system functions:

 

AuthorDocumentTitleIsPartialReload
ClientPlatformEngineVersionOSUser
ComputerNameGetCollationLocaleProductVersion
DocumentNameGetObjectFieldReloadTime
DocumentPathGetRegistryStringStateName

 

You can learn more about the system functions available in Qlik Sense Help.  The OSUser() and DocumentName() functions are easy to use and capture the information I need to make the QVDs specific to a user and an app.  Keep these functions in mind the next time you need information about a Qlik Sense app or the system/device it is running on.

 

Thanks,

Jennell

Qlik_BOT_Headers_Telegram.jpg

Hello everyone. After I saw the popularity of Juan's Qlik Bot for Telegram written all in C#, I decided to create another one in JavaScript with Node.js and Enigma.js. Today I am going to share with you the code and how to get started creating your own bot for Telegram on any Operating System that has Node.js installed.

 

The server will be running under https so if you do not have valid certificates for your domain, or localhost if you are testing it on your local computer, you can have Qlik Sense Enterprise take care of that for you. From QMC, go to start->Certificates and then export for localhost using the "Platform Independent PEM-format"

export-certificates.png

Copy these certificates and paste them into {QlikBotNode folder}/app/server/certs/localhost

 

I have used 3 apps in this, helpdesk, Salesforce and CIO dashboard. The qvf for helpdesk is bundled in your Qlik Sense Desktop while the Salesforce one you can get from Salesforce/Files at master · yianni-ververis/Salesforce · GitHub and the CIO Dashboard one from CIO/Files at master · yianni-ververis/CIO · GitHub.

 

Now lets get the code from GitHub - qlik-bots/QlikBotNode: QlikBotNode is a server build in nodejs, expressjs and MySql that connects to chat and m…

 

From the command line using your favorite tool, I am using Git Bash for this one, type Npm install to get all of the required modules.

 

Install MySql or Xampp / Wamp and connect to it. Xampp is bundled with phpmyadmin so you can use that. Then create the database and the tables by running sql query (QlikBotNode/sensebot.sql at master · qlik-bots/QlikBotNode · GitHub)

 

Every platform, upon creation of the bot, it gives you some tokens so your code can authenticate with the platform's servers. Once we have these tokens, for security reasons, we need to set them as environment variables. So, lets create our bot and get our token.

 

Once you install Telegram Desktop, go to your "BotFather" contact and type "/newbot". Everything in Telegram that starts with "/" is a command. So we typed the command to create a new bot. This will give you an options menu to configure your bot.

settings.png

Go ahead and give your Bot a name, an icon and a description. If you click on "Back to Bot", you will get a button with the "API Token". Take that token and store it as Environment Variable.

In windows you have to go to "Control Panel" -> "System" -> "Advanced System Settings" -> "Environment Variables" and set a new one as "TELEGRAM_BOT_TOKEN", while in Linux, from your directory (~), type "nano .bash_profile" or "vim .bash_profile" and enter a new line with the token "export TELEGRAM_BOT_TOKEN=######".

 

Now you should be ready to run your code. From the command line (Git Bash), type "gulp". If everything goes well and you do not have any errors, you should see a message "[nodemon] starting `node app/server/server.js`". Your server is up and running and communication via the Token auth has been established.

 

Now lets explore the Bot.

  • Type help to view all of the available commands main.png

 

  • Click on the Salesforce button or type /salesforce salesforce.png
  • Here, there are some buttons to get KPIs and one that takes you to the mashup for validation. Try them all!!!!!
  • Click on the CIO button or type /cio and then click on "Management" to get the set of KPIscio-dashboard-management.png
  • Click on the Helpdesk button or type /helpdesk helpdesk.png

That's it! Now you can a have a Node.js server running with your QlikBotNode and you can start experimenting with KPI commands in the Telegram app.


The code is open sourced at GitHub - qlik-bots/QlikBotNode: QlikBotNode is a server build in nodejs, expressjs and MySql that connects to chat and m…

Certificate_color_new.png
Hey Guys! - Happy Friday! Yep I'm blogging on Friday this week and our Demo and Design Team will be taking my usual Tuesday slot next week, to blog about something many of you have been waiting for (mark my words) I think you ALL are going to love it - so until then you'll have to deal with me for today. So what difference does that make to you for today's blog?!?! Absolutely nothing!

 

Seriously though - back in September, with the announcement of Qlik Sense September 2017 Qlik Sense September 2017 - What's New - I made mention of an Extension Certification Pilot program which will allow extension authors to submit their extensions to Qlik for review, to be certified and supported by the author for use within the Qlik platform. So in this blog I am making good on my promise to update you on the progress of this with some detailed information that should answer a few questions.

 

In the November 20017 -  What's New in Qlik Sense November 2017 we made mention that certified extensions are now going to have some badging to identify that they are certified -- and that they will be made available on Qlik Market - our online partner solution showcase. However - we have had some members and partners with additional questions and I think the answers will benefit everyone.

 

What extensions are certified? (There is currently no badging or filter on Qlik Branch for these items)

The only certified extensions currently are the ones that we are planning to put on Qlik Sense Cloud in the near future. Once certified they will automatically be part of Qlik Sense Cloud and be available for installation with Qlik Sense Desktop and Enterprise. (available form Qlik Market)

 

Do you have any extensions that will be certified first?

 

These 4 are on the certification list, and final certification will be made shortly:

 

It’s important to note that the versions of these extensions available on Branch are NOT certified. Certified versions will only be available for use on Qlik Sense Cloud or available for download from Qlik Market (market.qlik.com). Only the versions on Qlik Market will be badged. The plan is for those versions on Qlik Branch to be the open source, work-in-progress versions, subject to change at any time, and therefore, can’t be certified.

 

What does certification entail for our customers, partners, community ?

For a customer, certification doesn’t entail anything different except using the certified version. For developers (whether they be our customers or partners, or outside of those communities) the certification process will mean submitting the extension to be run through a battery of tests to ensure that they run correctly, don’t use any undocumented APIs, contain no malicious code, and some other tests. If they want the extension to be listed on Qlik Market, there is another check that the QM team makes before they can be posted (mostly around brand compliance and usability).

 

How can I submit and extension?


The "official" certification program is not yet in place. The four extensions we certified were Qlik-created. We are not yet ready to accept outside submissions for certification but will have a process in place early next year, so please stay tuned.

 

Hope this information is helpful to you all and if you have any questions please post them below and I'll do my best to address them for you.

 

Have a great weekend everyone!

 

Regards,

Michael Tarallo (@mtarallo) | Twitter

Qlik

 

Additional Reference Resources:

 

QlikHelpTypemark-Vertical-Web.png


Hello Qlik Community! In Tuesday's edition of the Design Blog I highlight some of the latest features found in our new Help Site - created with collaboration from our engineers, technical writers and our Product Content and Media team. We hope that the site's new layout and navigation features make it easier to find the information you need, when you need it.





The New Qlik Help Site



"Teamwork for results" -- this is one of Qlik's core values that many of us embrace when creating content that makes our community successful with the Qlik platform. However, few are aware of our unsung heroes that work behind the scenes to bring you this great content, delivered to the Qlik Help site as well as our Qlik Help YouTube channel. I'd like to take this moment to thank and recognize them on behalf of the Qlik Community.


There is a small army led by Renata Rieschel, Director Product Content and Media. Renata manages the development and maintenance of all the content, design and infrastructure of the Qlik Help site. Our technical writers and architects not only design and write the help documentation, but they are also tasked with writing video scripts and verifying content from a linguistic point of view for many of the structured help videos you will find on the Qlik Help Channel. We have even enlisted the appealing voice talents of our Collaboration Product Designer, Stephen Jasionowski and our Internal Communications Manager Helene Rudzinski to provide the voice-overs for many of the help channel videos created by our interaction designer Giuseppe Panella, including those from our new series Qlik Tuesday Tips and Tricks - found on YouTube.

 

With all this great content being created, both visual and text-based - how should it be hosted, what will the UI look like, how will people search, navigate and find what they need? That is where Magnus Franzen and Tobias Leander come in. They have built a framework and implemented a platform to host all this content and strive to improve the performance, accuracy and usability of it daily, providing you with the best user experience possible.


I'd also like to recognize our technical writers, interaction designers, web developers, architects and engineers in Product Content and Media whom all work together to bring you the best content in a timely and efficient manner.

Sara Garmark

Jim Siwila

Mary Newell

Chris Bushnell

Konstantinos Fioretos

Thomas Oxenby

Thomas Lewis

Daniel Chabot

Daniel Rignell

Filippo Guizzetti

Greg Ralston

Julia Beingessner

Kyle Weishaar

Mary Newell

Michelle Thomas

Ralf Narfeldt

Sarah Anderson

Ingemar Hansson

Karin Dahlgren

Swati Jha


Thank you Team!

 

Regards,

Michael Tarallo (@mtarallo) | Twitter

Senior Product Marketing Manager
Qlik

 

 

Can't see the video?

 

Download the .mp4 and watch from your computer or mobile device.

Since the introduction of Data Manager (the Data manager is where you visually add and manage data from your own data sources, or from Qlik DataMarket, so that you can use it in your app) Qlik has been constantly improving the set of features that makes the task of loading data an enjoyable part of the analysis process.

 

One of the most recent (and genius) additions to Data Manager is the “Summary card

 

 

1.png

 

So what is the Summary card?

 

Summary data profiling card is a visual representation of your data. It contains a set of elements, values and charts, that let you better understand each field in your data set.

 

Summary card has been designed to help you anticipate and prevent data quality issues before loading data into Qlik Sense. The Summary card content adapts to the field selected, so depending on the column data type, measure, dimension, or time it will present you with different insights.

 

For measures the following information is provided

  • Field name
  • Field type
  • Distinct Values
  • Total Values
  • Preview of the distinct value distribution in a bar chart showing the 20 highest count elements.
  • Value Range. It is a very interesting chart itself, for a measure field it will show a distribution chart showing the Min, Median, Average, and Max values for the field.
    If a temporal field is selected the Value Range will display the first and last date in the range.
  • Null Values and Mixed values charts only appears based on the field data.

 

5.png

 

How to access the Summary card

 

To see and use the Summary card by yourself you have to get to Data manager, In Data manager, select a table and click the pencil icon, then select a table field and the Summary card appears. Or just check the animation below:

 

dp2.gif

 

Enjoy it!

Arturo (@arturoqv)

Filter Blog

By date:
By tag: