Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Analytics & AI
Forums for Qlik Analytic solutions. Ask questions, join discussions, find solutions, and access documentation and resources.
Data Integration & Quality
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Explore Qlik Gallery
Qlik Gallery is meant to encourage Qlikkies everywhere to share their progress – from a first Qlik app – to a favorite Qlik app – and everything in-between.
Qlik Community
Get started on Qlik Community, find How-To documents, and join general non-product related discussions.
Qlik Resources
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Qlik Academic Program
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
Recent Blog Posts
-
Aggregations and Function Classes
A typical QlikView application may have one million records in the data, one hundred rows in a pivot table and a single number, a KPI, in a gauge or t... Show MoreA typical QlikView application may have one million records in the data, one hundred rows in a pivot table and a single number, a KPI, in a gauge or text box. Although different in magnitudes, all three numbers may still represent all data. The numbers are just different aggregation levels.
There are many functions in QlikView that can help you write the necessary formulae to calculate aggregated KPI:s. Some will collapse many records into one value, others will not. Today I will write about the different function classes, and how you can combine them.
The Scalar Functions constitute the first class. Typical for these is that they are one-to-one functions, i.e. they take a single value as parameter and return a single value (of the dual data type). Examples: Left(), If(), Num(), Date(), Year(), Subfield(), etc.
The Aggregation Functions constitute the second class. These are many-to-one functions, i.e. they use the values from many records as input and collapse these into one single value that summarizes all records. Examples: Sum(), Count(), Avg(), Min(), Only(), Concat(), etc.
Aggregation functions are special: You must use one to collapse several records into one number – which means that you need them in pretty much any formula in QlikView: In Chart expressions, in Text boxes, in Labels, etc. If you don’t write an aggregation function in your expression, QlikView will assign one for you: It will use the Only() function.
Scalar functions can be used both inside and outside the aggregation function:
Date( Min( Date )
Money( Sum( If( Group='A', Amount ) ) )
There is one restriction: You can normally not use an aggregation function inside another aggregation function. Hence, you usually need every field reference to be wrapped in exactly one aggregation function.
The next function class has only one member: The Aggr Function. It is – in spite of its name – not an aggregation function. It is a many-to-many function, rather like a tensor or a matrix in mathematics. It converts a table with N records to a table with M records. In other words: It returns an array of values. Regard it as a virtual straight table with one measure and one or several dimensions.
Most places in QlikView demand that you write your expression so that it returns one single value. This means that you must wrap the Aggr function in an aggregation function to get a meaningful result. The only exception is if you use the Aggr function to define a calculated dimension or field. This means that you have two aggregation steps; one nested in the other:
Avg( Aggr( Sum( Amount ), Month ) )
Charts complicate the matters slightly: A chart is like a For-Next loop where the number of distinct dimension values determines the number of loops. In each loop, the expression must return one value only, and this is the value used for the bar/slice/pivot table row.
However, sometimes you need values from other rows in the chart, and it could even be that you need values from several rows. To solve this, there are two additional classes of functions that should be used together:
The Chart Inter-record Functions return values fetched from other rows in the chart. Some of these can return several values, i.e. an array of values. These functions are only meaningful inside a chart or Aggr() function. Examples: Above(), Below(), Top(), etc.
The Range Functions are functions that can collapse a chart inter-record array into one single value. Examples: RangeSum(), RangeMin(), RangeMax(), etc.
Example:
RangeSum( Above( Sum( Amount ), 0, 12 ) )
Bottom line: Know your functions. It will help you write correct expressions.
See also
-
Calculated Dimensions
In most cases, you will use an existing field as dimension, i.e. an attribute that exists in the source data. In such a case, the answer to the above ... Show MoreIn most cases, you will use an existing field as dimension, i.e. an attribute that exists in the source data. In such a case, the answer to the above question is easy: Just make sure to load the field in the script, and you're done.
But in some cases you want to use derived attributes: Attributes that do not exist in the source data but one way or another can be calculated from existing fields.
One example is the fields of the Master Calendar: Year, Month, etc. These can all be derived from a date found in the source data:
Month(Date) as Month
Year(Date) as Year
A more advanced example is if you want to classify or rank a field. The following expression returns ‘A’ for the 10 best customers and a ‘B’ for the rest:
If(Aggr(Rank(Sum(Sales)),Customer)<=10,'A','B')
For such fields the above question is very relevant: Should they be calculated in the script and saved as fields, or should they be calculated on the fly in a sheet object?
There are pro:s and con:s with both approaches: A field calculated in the script is calculated once and for all, so it does not need to be re-calculated every time the user clicks. Hence, response times will be slightly shorter if the field is calculated in the script.
On the other hand, in some cases you want the field to be re-calculated every time the user clicks. A good example is the classification using Rank() above. Most likely you want this field to depend on the selection made: If you have selected a product, you want to see the classification of the customers given this selection. Such a number is in its nature dynamic and should be calculated every time the user clicks.
The key is whether the calculated field should be static or dynamic. The field Month is static: A specific date always belongs to the same month, irrespective of user selection. As opposed to a classification or a rank where the calculation usually should be dynamic, since the result potentially could change every time the user clicks.
Bottom line is that dynamic fields must be calculated in the chart or the list box. But for static fields it is better if they are calculated in the script, since precious CPU-time otherwise will be unnecessarily spent every time the user clicks.
Note: The Rank() function cannot be used in the script, so if you want to calculate a static rank in the script, you need to do it in a different way, using e.g. a combination of Order By and RecNo().
Further reading related to this topic:
-
Keep Your Head in the Clouds
3 minute read♫ Ding Dong! ♪ It’s here! I tore open the Amazon package to reveal my new Nest Cam. It was so shiny. I could not wait to set it up. One ... Show More3 minute read
♫ Ding Dong! ♪ It’s here! I tore open the Amazon package to reveal my new Nest Cam. It was so shiny. I could not wait to set it up.
One of the most innovative features it provided was state-of-the-art surveillance software and video history running from within a hosted cloud solution. It basically was plug and play. While I was setting up my camera this past weekend it made me appreciate how far cloud technology has come and sparked some initial thoughts on our own cloud-based solutions. I wanted to share some of these with you and give you a glimpse into Qlik’s cloud-based future.A Brief History of Cloud Computing
Cloud computing has grown in popularity over the years however, a steady increase has only been seen within the last 6 years or so. The arrival of Salesforce.com in the late 90s paved the way for software companies to deliver their software over the internet, by collecting data in the cloud and therefore Salesforce created the space for cloud CRM and ERP. In the early 2000s we saw Amazon Web Services (AWS) and (Elastic Cloud Computing) EC2 offer cloud-based services for computation, storage and virtualization. This helped many organizations reduce costs and allowed IT departments to focus more of their attention on pressing business matters. With the increase in bandwidth and a maturing internet web specification, logically, browser-based applications soon followed. (Anyone remember how cool it was to first use Google Docs??)
So why am I telling you all this?
Because…."As cloud computing extends its reach beyond a handful of early-adopter Google Docs users, we can only begin to imagine its scope and reach. Pretty much anything can be delivered from the cloud." - Cloud computing pioneer Jamie Turner.
That’s right, anything can be delivered from the cloud, and Qlik is building cloud solutions that will support the future. We are seeing a shift in data gravity to the cloud so now cloud analytics makes much more sense, pun intended. Sure there were some early movers who just took on-premise software and packaged it in cloud-style – but they were not engineered to be cloud first and some still aren’t. That being said - Qlik Sense is truly a cloud analytics product that was built to work within virtualized and global environments.
Qlik Sense Cloud
That brings me to Qlik Sense Cloud. A global, fully operational cloud analytics solution that you don’t have to setup or maintain. Quickly approaching 100,000 users from over 170 countries, this is definitely no passing fad and it will only get better. If you look at the evolution of Qlik Sense Cloud from its early release in 2015 to now – you have seen a tremendous transformation in a very short period of time. In little over a year Qlik Sense Cloud has evolved from a simple read-only app sharing platform to a 100% online analytics and collaborative solution. In January 2016 we introduced Qlik Sense Cloud Plus, offering more storage, larger apps sizes, unlimited shares and access to our Data As a Service offering, Qlik DataMarket (providing easy access, cloud-based, syndicated external data, directly into your analysis).
Continuing down this path of innovation, later this year we will have Qlik Sense Cloud Business, enabling groups and teams to create, manage, and collaborate with visual analytics in the simplicity of the cloud. That’s right, workgroups. You will be able to privately manage your own data and applications, schedule data refreshes and collaboratively develop with your invited peers, from either inside or outside your organization. You can check out the Qlik Sense Cloud Business product preview available in the Qlik Community (requires community login).
AND - It just keeps getting better… with the acquisition of Industrial Codebox (makers of the popular QVSource data connectors for Qlik) – we plan to integrate a number of cloud-based data source connectors such as Salesforce, REST, Google, Facebook, Twitter and many more. Further out on our roadmap, we plan to integrate Qlik Market to enable 1-Click Application solutions provided by Qlik Partners, similar to what you see on many web hosting platforms that offer 1-Click installation for blogs, databases, shopping carts and portals.
The future is bright my friends, and the old idiom “Get your head out of the clouds” does not apply here. If the best and brightest minds stopped dreaming, they might've never dreamt what is possible today with cloud computing, and you and I should thank them for that. I implore you, keep your head in the clouds and see what the future has to offer.
Happy Qlikking,
Michael Tarallo (@mtarallo) | Twitter
Senior Product Marketing Manager
Qlik
-
Mid-Week Humor with the Marketoonist
Over the next few weeks we will be posting weekly 'funnies' by the Marketoonist. Each one has a humorous take on BI or Business Information in the cor... Show MoreOver the next few weeks we will be posting weekly 'funnies' by the Marketoonist. Each one has a humorous take on BI or Business Information in the corporate world. We hope you enjoy them
Here's this weeks:
Feel free to click on the image/link to share your feedback or rate the document.
Cheers, Qlik Community team
-
App API and Viz API noSelections option
Sometimes you may want to use a chart in a mashup that does not allow selections. Before Qlik Sense 3.0, you basically had three options. One of those... Show MoreSometimes you may want to use a chart in a mashup that does not allow selections. Before Qlik Sense 3.0, you basically had three options. One of those options I blogged about before Disable selections in charts using Capability APIs. With this approach, you basically locked the field used in the chart to not allow any selections on that field. This had the side effect of not allowing a selection on that field anywhere in the mashup. The other two options were very similar. You could "mask" the chart with a div that sat over top of the chart, or you could use the noInteraction option that basically did the same thing. The problem with these approaches was that you could not scroll the chart or see the tooltips.
A better solution
Introduced with Qlik Sense 3.0, the noSelections option is a much better solution to this problem than any that previously existed. It disallows selections in the chart, without affecting the tooltips, ability to scroll, or the field used in the chart. And it's really easy to use.
Using noSelections option with the App API
To use the noSelections option with the getObject() method of the App API, simply set it in the options parameter like below
app.getObject(<htmlElement>, <objId>, {noSelections: true});
It's really that simple.
Using the noSelections option with the Visualization API
Using the noSelections option with the Visualization API is just a tiny bit trickier. I didn't realize I could even do it at first, because it's a little buried in the docs. But all you have to do is set the noSelections option in the options parameter of the show() method, like below.
qlik.app.visualization.create(type, cols, options).then(function(viz) {
viz.show(<htmlElement>, {noSelections: true});
});
And that's it. I find that this can often be really useful, because many there are many use cases where I want to embed just a chart or two into a page, and it makes no sense to allow selections on those charts, and now that we have the noSelections option is definitely the best way of accomplishing this.
-
The Qlik Continuous Classroom
Have you subscribed to the Qlik Continuous Classroom (QCC) yet?! If not we recommend you visit the Qlik Continuous Classroom and watch the free modul... Show MoreHave you subscribed to the Qlik Continuous Classroom (QCC) yet?!
If not we recommend you visit the Qlik Continuous Classroom and watch the free modules to learn everything it has to offer! From product training to Data Analytics concepts, the QCC has everything you need to understand the why and the how of analytics!
-
Mobile Friendly Horizontal Bar Chart
In our Qlik Demo Team we are trying to create mashups that are suitable for all devices. This is why we created another version of a Horizontal Bar Ch... Show MoreIn our Qlik Demo Team we are trying to create mashups that are suitable for all devices. This is why we created another version of a Horizontal Bar Chart that we use almost exclusively. This has various options like setting the bar height, color, text color, text hover color etc. It can also change from regular Horizontal Bar Chart to Horizontal Stacked Bar Chart, Grouped Bar Chart or a Lollipop.
All of the UI/UX guidance is coming from my colleague Michael Anthony | Qlik
Installation
- Download Zip file from Branch: http://branch.qlik.com/#!/project/57161998713777448667b063
- Desktop - Unzip at the extension folder (C:\Users<user>\Documents\Qlik\Sense\Extensions\SenseUIBarChart)
- Server - Upload the zip file
Settings
Dimension and Measures
- Set 1 dimension for the Labels and
- up to 5 Measures for Grouped, Stacked Bar or Lollipop
General Settings
- Text Color
- Font Size
Bar
- Height
- Comma separated colors for the stacked bar fill color
- Fill color when you mouse over
- Text Color for each bar
- Text Color when you mouse over
- Border Weight
- Border Spacing
- Enable Selections
- Toggle between Stacked and Grouped Bar Chart
Tooltip
- Enable Tooltip
- Show Dimension in the Tooltip
X-Axis
- Show X-Axis
- Show Legend (check Stacked Bar image below)
Y-Axis
- Show Y-Axis
- Label Width (Usually 150px, even for the smallest device )
- Number of visible characters, if you want to truncate your labels.
Even though we still have a long way to go to make this perfect, features are always welcome!
YIANNI
Files
-
Qlik Sense Certifications now available in multiple languages!
We have wonderful news to share for those of you who are looking to get Qlik Sense certified! All three Qlik Sense Version 2 exams for System Adminis... Show More
We have wonderful news to share for those of you who are looking to get Qlik Sense certified! All three Qlik Sense Version 2 exams for System Administrator, Data Architect and Business Analyst – are now available in eight languages:
- Brazilian Portuguese
- Chinese
- English
- French
- Japanese
- Korean
- Spanish
Also, FREE Qlik Sense Practice Questions are now available here: Qlik Sense Certifications
-
Pivot Table Loading
With the release of Qlik Sense 3.1 this week came the Pivot Table Loading feature. This feature provides the ability to “un-pivot” data that is store... Show MoreWith the release of Qlik Sense 3.1 this week came the Pivot Table Loading feature. This feature provides the ability to “un-pivot” data that is stored in a pivot table format. I am excited about this new feature because I often have data that I need to “un-pivot” in Qlik Sense. I must admit that in the past I occasionally used QlikView to generate the script to load this type of data using the CrossTable wizard but now with the Pivot Table Loading feature, I can do it all in Qlik Sense.
Let’s take a look at an example. Assume I have a data set that looks like the image below where the first column is country and I have data values for various years.
When I load this into Qlik Sense, the data is loaded just like the Excel file with a field named Country, 2013, 2014 and 2015 (see image below). What I would prefer is to have a country field, a year field and then a field that stores the data values. This is where the Pivot Table Loading comes into play.
In Qlik Sense, I can drag my Excel file into Qlik Sense to load it. Once the file is loaded I can open the Data Manager and click on the edit icon for the table.
Below in the Data Manager window, there is now the Unpivot option.
When Unpivot is clicked, you are prompted to select the fields that you want to transpose into rows. Since I want to transpose the 2013, 2014 and 2015 fields into rows, I will select those three columns and select the Apply unpivoting button. At the bottom of the screen, I am provided a preview of the data and I can see that my years are all in one field now.
Once the unpivoting is applied, I can rename the attribute and data fields and load the data.
Now if I preview the table I loaded, it looks like this:
The 2013, 2014 and 2015 fields have been transposed into rows and I now have a Year field that I can use in a filter pane or in my visualizations. My script was auto-generated and you can see the use of the CrossTable prefix to load the Excel file.
The Pivot Table Loading feature is a valuable new feature in Qlik Sense 3.1 that will make it easier to load pivot table formatted data. Check out Michael Tarallo’s video titled Qlik Sense 3.1 - Using Unpivot (video) to see the Pivot Table Loading feature in action.
Thanks,
Jennell
-
Learning Is Not Just For Newbies
Never stop learning, because life never stops teachingIn today’s workplace, where technology is rapidly changing and evolving, there’s no doubt that l... Show MoreNever stop learning, because life never stops teaching
In today’s workplace, where technology is rapidly changing and evolving, there’s no doubt that learning has to play an important and ever-present role. But often, training programs fail to go beyond the needs of the uninitiated ‘new’ student which has to be brought up to speed. In fact, there are at least five, and all just as important, use cases that a learning platform should support.
- The “first” experience
- The “continuous” experience
- The “knowledge refresh” experience
- The “real world” experience
- The “keep current” experience
So what is Qliks solution to ensure you never stop learning? Visit the full blog to learn!
-
What’s new in Qlik Sense 3.0 - Time-aware Charts
One of my personal favs and long time awaited features that ships with Qlik Sense 3.0 is the new time-aware charts. We could simply describe it as con... Show MoreOne of my personal favs and long time awaited features that ships with Qlik Sense 3.0 is the new time-aware charts.
We could simply describe it as continuous scale in x-axis line chart but it’s much more than that, let me show it to you.
Before the introduction of Qlik Sense 3.0 Time-aware charts, line charts displaying a time dimension in the X-axis would show a portion of the line at a reasonable scale although the complete sequence was still visible in the mini-chart at the bottom of the object.
Time-aware charts are visualizations that use a continuous scale to provide a complete and accurate view of time-based data. That is, when you enable continuous scaling on the x-axis in a chart with date fields, data points are separated from each other by a distance relative to their associated time. As well, the axis labels are evenly separated whether or not there is data for that point and the chart view is compressed to avoid scrolling.
You can zoom in, zoom out or modify the size of the visible window that appears over the mini-chart at the bottom of the object to get a closer look into the data. As you can see in the animation above, content gets immediately adjusted showing the relevant x-axes label information at any zoom level.
Selections are smart as well, when browsing the chart at a yearly level any selection in the chart will perform a selection in the year derived field, but when a more detailed view of the data is visible, for example at day level, selections will be performed in day (derived) field in the data model.
How to get it working?
Time-aware charts needs, of course, a time dimension to work. Good thing is since Qlik Sense 1.1 we can declare and derive time fields in our data model. Read Jennell’s blog post to learn how to do it. Alternatively, if you are loading data using the data load wizard, then chances are Qlik Sense will automatically detect your field(s) containing a date and it will do the rest for you.
Once you have your time dimension working the next step will be pretty straightforward, as shown in the animation above you just need to activate it by checking the box “Use continuous scale”.
Thanks,
Arturo
-
QlikView 11.2 SR5 and Maps
You wake up in the morning and head down to the living room; faintly you hear a lingering “hohoho” from the chimney. Santa was here – and he left us s... Show MoreYou wake up in the morning and head down to the living room; faintly you hear a lingering “hohoho” from the chimney. Santa was here – and he left us something wonderful!
Santa is early this year, not only did he bring us a new and shiny service release for QlikView he also included a free to use mapping extension!
When you install the latest version of QlikView, http://www.qlik.com/download/, we now ship an Example Extension Object that makes use of OpenLayers and MapQuest.
So how do I make use of this sweet nectar you say?
Let me take you on a journey and explore some mapping possibilities!- Head out and install the latest version of QlikView, make sure you install the examples.
- Navigate to C:\Program Files\QlikView\Examples\Extensions and double click the “Extensions Examples.qar” file. This will install all of the extension examples.
- Open the QlikView “Extension Examples that you can find in C:\Program Files\QlikView\Examples\Documents\
- In the Mapping tabs you will find examples on how to plot either dots/points, lines or polygons.
Attached to this post you will also find a dataset and an app that contains all of the high speed cameras in Sweden with corresponding latitude and longitude points if you want to play around with the extension, make sure you install the extension first, on your own.
Keep on Qliking!
Keep in mind
Extensions are generally built upon web technologies such as HTML and JavaScript and for QlikView to be able to render these objects on the screen you will need to run QlikView Desktop with WebView mode enabled or access the document through the AJAX-client over AccessPoint. The IE-plugin does not support extensions.
Disclaimer
The QlikView Mapping Example Extension can be configured to use many different map tile sources.
Each map tiles source has its own terms and conditions and the user assume all responsibility for the selection of a source for map tiles and for compliance with the terms and conditions of the selected source. Any and all liability associated with the selection of a tile source and the compliance with the terms and conditions of the selected source is hereby disclaimed.
-
Qlik Sense 3.1 - Improved User Experience and Enhanced Data Prep
Qlik Sense 3.1 is our first release after June’s Qlik Sense 3.0. Qlik Sense 3.0 introduced us to major new innovations including Visual Search, Visua... Show MoreQlik Sense 3.1 is our first release after June’s Qlik Sense 3.0. Qlik Sense 3.0 introduced us to major new innovations including Visual Search, Visual Data Preparation as well as developer and user experience improvements. (In case you missed it you can see this 50 second action inspired trailer that shows highlights of what was previously released in Qlik Sense 3.0.) Qlik Sense 3.1 builds on many of the same themes that improve the user experience, enhance data preparation and address our developer community. During this release schedule we also have a few other "extras" that will both please and surprise you. Read on to learn more my friends.
User Experience
We continue to focus on driving our user experience alongside enhancements to our engine and ecosystem. In 3.1 we made a number of chart improvements including more granularity in time-aware charts which were introduced in 3.0. We’ve added more controls to line and combo charts and added auto recognition of city and country data to our mapping. We’ve added the capability to "unpivot" pivot table and cross table data in the data manager and included the ability to pre-filter data via selected bundled connectors and made the visual data preparation algorithm even smarter. We’ve also added a number of UI enhancements including drag and drop chart coloring.
You can view a brief presentation on the new feature highlights in this video below and see some of these features in action by clicking the links mentioned above
Embracing Developer Innovation
We not only continue to build and invest in our 9,000 strong developer community via Qlik Branch but we continue to create tools for developers to better experience the power of our platform and make it easier to build on. Our new Qlik Playground™ does just that. It is a free, one-of-a-kind programming environment that allows developers to learn about, use, and experiment with Qlik‘s associative engine and APIs.
By accessing public data sets (including your own Twitter data) through our available APIs; Playground allows you to get hands-on with your data and create cool data-driven apps using powerful search and other capabilities that Qlik offers quickly and easily.
AND Finally let me introduce you to ....
Qlik Sense Cloud Business
Qlik Sense Cloud Business empowers groups of people within your organization to deploy and manage a series of analytical apps. Qlik Sense Cloud Business adds additional security and governance features within your managed work group. Control which users have access to your shared apps, and allow them to collaborate, create, edit and access group data and content. This cloud-based model allows you to add new users and apps as requirements change, with the ability to scale to support current and future needs. Also included is the ability to schedule data refreshes and additional data connectivity to cloud-based sources. You can get a sneak peek at Qlik Sense Cloud Business right now and learn more by visiting our preview page.
Well friends, that is all I have. For a "point release" there's lots of goodness to go around both in and out of the product. I hope you enjoy it. Remember to reach out to myself or my colleagues in the qlik community with any questions and we will to our best to help.
Regards,
Michael Tarallo
Qlik
-
Aligning objects and making a mashup responsive using Twitter’s Bootstrap and jq...
From my previous blog Creating a webpage based on the Qlik Sense Desktop Mashup API, we've learned how to get the objects from our app and display the... Show MoreFrom my previous blog Creating a webpage based on the Qlik Sense Desktop Mashup API, we've learned how to get the objects from our app and display them on our website with the Mashup API. These are individual objects though and most likely we would like to display them as we do in the app sheet.
For this blog we will use the sheet from the "How European are you" app. So here is the sheet with objects.
- Make sure you add bootstrap css and js references in your html.
<!-- CSS -->
<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css">
<!-- Optional theme -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap-theme.min.css">
<link rel="stylesheet" href="https://sense-demo.qlik.com/resources/autogenerated/qlikui.css">
<link rel="stylesheet" href="https://sense-demo.qlik.com/resources/assets/client/client.css" media="all">
<!-- Custom -->
<link rel="stylesheet" href="css/style.css">
<!-- JS -->
<!-- Latest compiled and minified JavaScript -->
<script src="//code.jquery.com/jquery-1.11.3.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/js/bootstrap.min.js"></script>
<script src="https://sense-demo.qlik.com/resources/js/external/requirejs/require.js"></script>
<!-- Custom -->
<script src="js/index.js"></script>
- In my previous blog in step 7, I used app.getObject(), to place the object into a specific div id. Now, we will go one step further and we will just use the object id from the app as our html data-qvid and we will let jquery handle the rest.
- So we start by laying out the grid for the above sheet. We need 3 columns and for the 3nd column we will need three rows.
<div class="container">
<div id="template">
<div class="row">
<!-- Left Column -->
<div class="col-md-2">
<article style="height: 600px" class="qvobject" data-qvid="ZZpXPE" id="filterCountry"></article>
</div>
<div class="col-md-2">
<article style="height: 600px" class="qvobject" data-qvid="TrjNJ" id="filterYear"></article>
</div>
<!-- Right Column -->
<div class="col-md-8">
<div class="row">
<article style="height: 300px" class="qvobject" data-qvid="KtCKy" id="lifeCostByCountry"></article>
</div>
<div class="row notification">
Select a category in the chart below to see individual product cost details
</div>
<div class="row">
<article style="height: 300px" class="qvobject" data-qvid="jsmEE" id="avgLifeCost"></article> </
</div>
</div>
</div>
- We overwrite bootstrap's css for some elements that do not show up properly, like the icons below with:
.sel-toolbar-span-icon {
top: -10px;
}
- and we make sure that all of the qlik sense objects are visible by setting their width to match bootstraps grid.
.qvobject {
width: 100%
}
- Now we add in our js jquery's $.each method to display the objects in our grid.
$('#template').find('.qvobject').each(function() {
var qvid = $(this).data("qvid");
app.getObject(this, qvid);
})
- Finally, we need to add a clear selection button to mimic the app. In our html we add the button.
<div class="row">
<div class="col-md-12">
<a id="clear" class="btn btn-default" href="#">Clear Selections</a>
</div>
</div>
- and in our js catch the click event with jquery and use the app.clearAll() method.
$('#clear').on('click', function(event) {
event.preventDefault();
app.clearAll();
});
There are times that you will want to use many objects in your page and you just do not want to split them up in multiple pages. If you see that there is not scrolling on the page, you need to add the following in your css.
body {
overflow: auto !important;
}
Here is our final page that looks exactly like we have the objects in our Qlik Sense Desktop Sheet
That's it! I Hope you have fun with your webpages!
Project Files: yianni-ververis/how-european-are-you · GitHub
Website: Qlik Demos: See Qlik Sense in Action | Sense-Demo.Qlik.Com
-
Getting Started with Qlik Sense for QlikView Customers
Greetings Qlik Community. Our resident guest Blogger Marcus Spitzmiller is back with an introductory video of how and why QlikView customers should g... Show MoreGreetings Qlik Community. Our resident guest Blogger Marcus Spitzmiller is back with an introductory video of how and why QlikView customers should get started with Qlik Sense.
What better way to get started with Qlik Sense than to be a QlikView customer? Of course having knowledge of QlikView is certainly not a requirements but, you’ve got a head start! This video shows you why.One great thing about QlikView and Qlik Sense together is that many of the skills and assets you’ve accumulated in QlikView can be directly used in Qlik Sense, and there are several ways to get started making use of it.
We’re really excited how Qlik Sense expands the many use cases you can deliver using existing QlikView (and non-QlikView) data. Self-Service, guided analytics, embedded analytics, custom analytic applications, and even reporting - with the help of Qlik NPrinting are all available and to you. You can learn more about these mentioned capabilities here in our Qlik Platform-enabled analytics video series.
Enjoy the video!
Marcus Spitzmiller
Master Principal Enterprise Architect
-
Hello Data, what are you trying to tell me?
Greetings Qlik Community. Our resident guest Blogger David Freriks is back with an interesting and innovative spin on data presentation. David is a T... Show More
Greetings Qlik Community. Our resident guest Blogger David Freriks is back with an interesting and innovative spin on data presentation. David is a Technology Evangelist on the Innovation and Design team at Qlik. He has been working in the "big data" space for over three years, starting with Hadoop and moving onto Spark in this continuously evolving ecosystem. He has 18+ years in the BI space, helping launch new products to market. Natural Language Generation and Qlik Sense
How do we perceive value and how do we understand information when it is presented to us? Sometimes it is easy, many times it is not and the difference is usually based on literacy and context. The solution to accelerate understanding of data in relation to analytics can be found in simplifying charts, graphs, and visual elements into natural language or NLG (natural language generation). The simple definition of NLG is taking data and generating observations that are distilled into textual explanations.
My teammate Murray Grigo-Mcmahon has an excellent post on the nature and theory behind the concepts and design on how to approach solving data literacy, but I’m going to focus on why Qlik has been and remains a pioneer in bringing NLG into the visualization and analytics space.
Qlik has been working with Narrative Science and YSEOP since 2015 (well before analysts such as Gartner began to talk about it) to inject NLG natively into visual analytics applications and dashboards. The reason why these two NLG leading companies chose Qlik first was because of the nature of the Qlik Platform. The Qlik Indexing Engine (QIX) that powers our API’s is a unique differentiator in the BI/Analytics space as it’s the first truly open and extensible platform to encourage and support 3rd party extensions through an open source repository called Qlik Branch.
"Other vendors" may have some limited amount of 3rd party plugins now, but Qlik was first to embrace this developer Ecosystem. With well over 300 custom open source solutions (powered by Qlik and hosted on Qlik Branch) Qlik has been in a strong position to be an attractive partner to the NLG space. YSEOP and Narrative Science (NS) are the leaders in this space and we’ll focus on a use case by NS, but it’s worth pointing out each vendor has their strengths. YSEOP is unique in that is support multiple languages for their NLG.
Ok, enough about how Qlik was the first to market with NLG – let’s talk about why Qlik is a great fit for these technologies.
How about we start with an example, let’s observe this chart…
(click to enlarge)
What can we surmise?
- Revenue seems to be improving.
- Revenue is higher by $2 million dollars (ish) from Jun 2012 to Jun 2014
- There is some seasonality
Those are interesting, but lack any specifics. I would have to go create another chart or download the data to excel to calculate the specifics. This chart by itself has given me the trends (albeit, with a very pretty chart) but I haven’t actually gained any concrete knowledge.
Let’s apply Narratives for Qlik from Narrative Science to this chart.
(click to enlarge)
Now, let’s analyze the results based on the NLG analysis.
- I now know total revenue over the period ($90M over 30 months)
- I know the specifics of the revenue ranges ($1.1M to $3M per month)
- Revenue improved 333% over the time analyzed, and the biggest jump between Jan 2012 to Feb 2012 by 110% and $1.1 million dollars.
- I see my peaks of revenue, I see net growth peaks
- I have a trend of $78k growth per Month over the 30 months
- I have a projection of growth to $4.4M in revenue over the next 3 months.
This is a dramatic difference in my data narrative. No more approximations, no more guesses, no need to go and create further analysis. I understand a much clearer picture, in context, of what my data is trying to tell me.
So why is Qlik so well suited for working with NLG technologies? The answer lies in our platform powered by the QIX engine. The QIX engine creates a subset of data (called a hypercube) from the overall in-memory model to stream to the NLG engine. Unlike other NLG integrations, it’s not a separate query to a database, but a leverage of the data in context being analyzed. This hypercube contains the information not only of the selections (filters) that are being applied, but by correlation the associations of the selections as well as the non-correlated values. This is quite unique, as any basic query tool can pass filters – but Qlik being able to include correlated (or uncorrelated) values provides a much richer analysis.
Imagine in the above analysis, I could also include additional data (i.e. products) and understand the relationship between products sold that contribute to the spikes in revenue and conversely the products not sold (market basket) during the negative spikes. I can truly unlock the secrets of my data as never before.
Only the Qlik platform has the power to understand all your data – and the power of NLG gives it the power to tell you why. Oh and did I tell you - Qlik was the first to have this capability?
Regards,
David Freriks
Emerging Technology Evangelist
Follow me: David Freriks (@dlfreriks) | Twitter
-
Decision Makers: Is Your Analytics Tool Worthless?
Why you need the right skills to interpret your data, not just the tool."Just because you have access to great software, does not automatically make y... Show MoreWhy you need the right skills to interpret your data, not just the tool.
"Just because you have access to great software, does not automatically make you an expert" - Kevin Hanegan, VP Knowledge and Learning.
Today, the volume of data available to decision makers is simply massive. However, in spite of all this great data, and access to the best analytics tools, poor decisions continue to be made. Why? Here’s the plain truth: investments in analytics are worthless if employees cannot incorporate that information accurately into their decision making process
So what's the solution? To learn, visit http://global.qlik.com/us/blog/posts/kevin-hanegan/decision-makers-is-your-analytics-tool-worthless
-
Hierarchy of Information
Not all of your data is equally important. Some things are more important than others. It’s your job as the creator of a guided analytics application ... Show MoreNot all of your data is equally important. Some things are more important than others. It’s your job as the creator of a guided analytics application to prioritize information, to create a hierarchy for users to better understand the information. There is an implied level of importance based on where you place something and what it looks like.
Be on the front page
Being on the first page someone sees when starting an experience is best. Like the front page of a newspaper the Dashboard of an application has an added level of importance by the very nature of being first. What you choose to lead with says a lot about what you want your audience to know above all else. It isn't that the subsequent pages aren't important it is just that they are perceived as less important in the hierarchy of pages because they aren't first. Leading with a Dashboard page is all a part of the DAR methodology which is a useful way to organize your content across multiple pages.
Top of the page
Like being the first page a user sees, being at the top of the page is prime real-estate. Designers use placement to denote importance online all the time. In ecommerce design the top area (the Aspot) is the largest marketing space and has the greatest prominence. From there subsequent spaces (B spots, C spots, etc.) cascade down the page in lesser and lesser importance. The further down the page something is, the less important it is. Content at the top of the page sits above the fold (to reference newspapers again) and therefor should be universally seen by users on any device resolution before scrolling.
F formation down the page
While we may read long-form content in a Z formation down a page we scan/read most online content in an F formation. We read the first line, then a bit of the second line, then sort of work our way down the left side of a page hunting for keywords. This works for article pages online but it also works with larger object oriented pages like shopping experiences with product photos. Again this reaffirms that the content at the top of the page is the most important real-estate on a page especially the top left. The top of the page gives a reader an idea of what content a page may contain and the scent of whether or not he/she is on the right track to finding what they are looking for.
Style
Other than being at the top of the first page a final technique to denote importance is how you choose to size & style your content. Most people are familiar with this concept as it applies to typography. Magazines, newspapers, websites, etc. all make the most important information the largest type size. As the type sizes are reduced the implied importance of that information is also diminished. You can also use contrast to set some information apart from the rest. Where all of your text is a dark gray perhaps one part is bright red. Where most of your lines in a line chart follow a similar color scheme, perhaps one contrasts that scheme to stand out. Essentially you are telling the user that this thing that visually stands apart from the rest is important and something they should focus on.
Establishing a hierarchy of information is beneficial to the user of a guided analytics application because it reduces the cognitive load of the user. When users don't have to sift through all of the content to decided what is most important they have more time to focus on using the application and meeting their business needs.
-
Qlik Announces the Premier of Qlik Sense 3.0
Note: If you do not have access to YouTube, most videos mentioned are available as attachments (.mp4) for download on their appropriate pages. It was ... Show MoreNote: If you do not have access to YouTube, most videos mentioned are available as attachments (.mp4) for download on their appropriate pages.
It was back in early May, at our Qonnections 2016 event that our CTO and SVP of Products, Anthony Deighton, first previewed a number of exciting and new announcements to our visual analytics platform. In true "Hollywood style"
- I was very excited to share what I witnessed, but only could reveal so much. I thought I could add to the suspense with a movie-like teaser trailer. Some that saw it even joked that it almost gave them a seizure. Well I’m even more excited to announce that we have now delivered on the first batch of these innovations with the general availability of Qlik Sense Enterprise 3.0, new Qlik Connectors, the release of NPrinting 17.1 and new topical packages for Qlik DataMarket. There is just way too much in 3.0 to list so I suggest you watch this 7 min video presentation which explains what’s new in greater detail.
In Summary:
- Visual Data Preparation
- Visual Search
- Automatic Recognition and Creation of location keys for point maps
- DataMarket Topical Packages
- NPrinting Support for Qlik Sense
- Time-aware Charts
- Widgets
- Connectors
If you want to learn about each of these features and more, view the What's New in Qlik Sense 3.0 video index page available here, complete with samples, data and video download. Now of course picking up on my movie theme if you’re like me, you don’t always trust the movie critics, and you’ll want to try these new capabilities for yourself. One of the best ways to do this is to simply try Qlik Sense Cloud (www.qlikcloud.com) because by the time you are reading this we will have upgraded Qlik Sense Cloud to version 3.0. Get the Popcorn ready and enjoy the show!
Regards,
Mike Tarallo
Qlik
-
QlikView Joins the Qlik Continuous Classroom
We are excited to announce the QlikView Business Analyst track is now live in the Qlik Continuous Classroom! The QlikView Business Analyst track conta... Show More
We are excited to announce the QlikView Business Analyst track is now live in the Qlik Continuous Classroom!
The QlikView Business Analyst track contains basic to advanced modules that teach the Business Analyst how to build analytical QlikView applications. The track covers QlikView concepts, demonstrates how to use the rich set of QlikView features, provides hands-on exercises, and supplies quizzes to test your knowledge.
Subscriptions are user-role based, so users with a subscription to the Qlik Sense® Business Analyst role will automatically be subscribed to the new QlikView Business Analyst role!
In addition to this new offering, the QCC platform has been enhanced and is even more user friendly! The new “My Training Dashboard” view gives subscribed users easy access to all of the learning components that make the Qlik Continuous Classroom valuable.
To get started with the QlikView Business Analyst visit Qlik Continuous Classroom and select the V for QlikView.
If you are not a subscribed user, we recommend trying the free modules to get started.
