Hear directly from Qlik employees in our nine unique blogs. Check out the new Customer Success Blog!
Important and useful support information about end-of-product support, new service releases, and general support topics.
Updates for Qlik Community offerings, announcements and changes.
All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.
This forum was created for professors and students using Qlik within academia.
On this forum you can access and follow the latest updates of our courses and programs with the Qlik Education team.
Learn about what's new across all of the products in our growing Qlik product portfolio.
Information on all new product releases, connectors, beta programs, and technical product information.
Deep dives into specific back-end technologies which allow for the extension of Qlik to fit the needs of the enterprise.
All about Qlik's Voice of the Customer program and Customer Success initiatives
Simplified deployments… check! Lower infrastructure costs… check! Relief from entitlement management… check!
Thank you for your enthusiasm for QlikView year after year. As the Qlik offerings evolve, we want to make sure to keep you apprised of the latest news and developments. We invite you to join us for our latest Product Spotlight OnDemand webinar: “Protect and Extend Your QlikView Investment” for an update on QlikView, our strategy, and go forward plan.
During this webinar, product leadership will discuss Qlik direction and how our commitment to QlikView plays into the overall Qlik strategy and development trajectory. We will introduce the concept of product co-existence and how we’re making it simple and cost-effective to extend QlikView capabilities through Dual Use licensing. We will also introduce you to our roadmap and release plan, so you can gain insight into valuable and complementary updates recently added to Qlik Sense.
Visit this link to attend “Protect and Extend Your QlikView Investment”.
First of all, the Load statement is in itself a loop: For each record in the input table, the field values are read and appended to the output table. The record number is the loop counter, and once the record is read, the loop counter is increased by one and the next record is read. Hence – a loop.
But there are cases where you want to create other types of iterations – in addition to the Load statement.
For - Next Loops
Often you want a loop outside the Load statement. In other words; you enclose normal script statements with a control statement e.g. a "For…Next" to create a loop. An enclosed Load will then be executed several times, once for each value of the loop counter or until the exit condition is met.
The most common case is that you have several files with the same structure, e.g. log files, and you want to load all of them:
For each vFileName in Filelist ('C:\Path\*.txt')
'$(vFileName)' as FileName
Another common case is that you already have loaded a separate table listing the files you want to load. Then you need to loop over the rows in this table, fetch the file name using the Peek() function, and load the listed file:
For vFileNo = 1 to NoOfRows('FileListTable')
Let vFileName = Peek('FileName',vFileNo-1,'FileListTable');
'$(vFileName)' as FileName
Looping over the same record
You can also have iterations inside the Load statement. I.e. during the execution of a Load statement the same input record is read several times. This will result in an output table that potentially has more records than the input table. There are two ways to do this: Either by using a While clause or by calling the Subfield() function.
One common situation is that you have a table with intervals and you want to generate all values between the beginning and the end of the interval. Then you would use a While clause where you can set a condition using the loop counter IterNo() to define the number of values to generate, i.e. how many times this record should be loaded:
Date( FromDate + IterNo() - 1 ) as Date
While IterNo() <= ToDate - FromDate + 1 ;
Another common situation is that you have a list of values within one single field. This is a fairly common case when e.g. tags or skills are stored, since it then isn’t clear how many tags or skills one object can have. In such a situation you would want to break up the skill list into separate records using the Subfield() function. This function is, when its third parameter is omitted, an implicit loop: The Load will read the entire record once per value in the list.
SubField(Skills, ',') as Skill
Bottom line: Iterations are powerful tools that can help you create a good data model. Use them.
There are a lot of people that use Wordpress as their company's portal. If you are one of these people then, you may find this plugin very useful. You can create a mashup from within wordpress, using the Capabilities API, without writing a single line of code. Just add the settings with the host and the App ID, then the shortcode for the objects that you want and you are done.
Here, I will show you how to do that.
- id: is the unique div id. This is needed especially when you want to display the same object in 2 different instances
- qvid: Is the object id as found in the "dev-hub/single-configurator"
- height: The height of the visualization in pixels
- nointeraction: Add this if you want to disable interactions. If you want the objects to have interaction, you can just omit this.
- app2: Add this if your object is coming from the second app that you have specified in the settings
Make sure you whitelist your url in the virtual proxy.
If you use it and like it, please give it a 5 star in Wordpress.
This is it!
Hi folks - this video will show you how to get started with Qlik Sense Mobile from a basic sense. There have been some signifcant changes since I last recorded a video on this and it was time for a brief update. Due note that we have much more for those of you who administer, secure and deploy mobile BI. We work with Enterprise Mobile management vendors to tightly integrate our solution with their platforms. See the resource links below.
In this video you will learn how to:
Note: Offline access via the Qlik Sense Mobile App is only available to Qlik Sense Enterprise customers. However, Qlik Sense servers and Qlik Sense Cloud can be quickly and easily accessed via a mobile device such as a tablet or smart phone by simply using a mobile browser that supports HTML5 - i.e. Chrome, Safari, etc. Check out these 2 videos to learn more:
Please let me know if you have any comments or questions.
Qlik Sense Mobile
Can't see the embedded video? YouTube blocked by your organization or region? Download the .mp4 to watch on your computer or mobile device.
A big part of the value is integrating with many platforms. Things change – you might start your analytics on AWS, then try certain workloads on Azure and Google. Your company might acquire a business unit that runs production data on SQL Server rather than Oracle. Your CIO might institute a data modernization effort that requires you to offload analytics queries from your DB2 z/OS systems to Kafka. Whatever direction you take, it helps to have a consistent, automated data pipeline process.
Here at Attunity, now part of Qlik, we cast an ever-widening net with our pipeline automation. Attunity version 6.5 extends our leadership in enterprise data integration with enhanced platform support, performance and security capabilities, as well as additional platform configuration options for flexibility.
Platform Integration Leadership in Enterprise Data Integration
Attunity now integrates with new end points that organizations are embracing for both operations and analytics. We have added support for Salesforce, MongoDB and Google Cloud SQL as sources, and Google Cloud BigQuery, Azure Databricks (beta) and Azure Data Lake Storage (ADLS) Gen2 as targets.
Attunity Data Integration: Any Source to Any Target
Here are a few example use cases to see what this looks like in action.
We continue to reduce latency and increase throughput via deep integration with the most common enterprise platforms. Here is a look at the performance enhancements of Attunity Replicate 6.5.
We have also improved our management flexibility, pushing out the envelope with new configuration options for some of our most popular sources:
Finally, Attunity 6.5 hardens security controls on a number of fronts to ensure data integrity and support compliance efforts across all platforms. For example, Attunity Replicate now includes a Secure Sockets Layer (SSL) option to encrypt client-server connections for email notifications. This SSL capability also includes the ability to verify “peer” and “host” fields by validating server certificates. We also have added non-privileged accounts on Windows, enabling users to run Replicate with restricted capabilities compared with the default account. Finally, new installations now require strong passwords.
To download the software and try it for yourself, check out the Attunity Replicate Test Drive.
Article by Kevin Petrie
Product Marketing Director
Check out this video to see it in action:
Hi all QlikView users
We have released a new version of our brilliant QlikView Governance Dashboard which is now available on our download site. This new dashboard was developed to help administrators have oversight of their QlikView implementation and contains new functionality aimed at the upcoming QlikView November 2017 release. We previously highlighted the changes which QlikView November 2017 will bring to Search and Select ( https://community.qlik.com/blogs/supportupdates/2017/09/22/upcoming-changes-in-search-select-qlik-sense-and-qlikview ) and the new Governance Dashboard will help you identify which QlikView documents may have Set Analysis expressions affected by the changes.
For more details please see the attached release notes. Thank you for choosing Qlik software.
Global Support Team
As part of our ongoing SaaS product roadmap, we are excited to announce the launch of Qlik Sense Business, our newest SaaS offering designed to help groups and teams collaborate on analytics and make faster data-driven decisions.
Is this the same as Qlik Sense Cloud Business?
No, and it’s not just a name change, either. Qlik Sense Business is a new, enhanced offering with more capabilities that groups and teams can use to build and share apps for greater discoveries.
Qlik Sense Business runs on Qlik Cloud Services, our cloud-native, Kubernetes-based SaaS platform that also hosts Qlik Sense Enterprise. Qlik Sense Business users will now benefit from the same speed, performance, and availability as our enterprise SaaS users. Additionally, Qlik Sense Business also shares the same enhanced and redesigned user interface, cloud hub, and management console as Qlik Sense Enterprise on Qlik Cloud Services.
Qlik Sense Business users benefit from:
• Full Qlik Sense analytics capabilities, including the Associative Engine
• All of Qlik’s latest augmented intelligence capabilities, including insight suggestions
• Drag-and-drop app creation and fully interactive apps
• A personal space to create your own content and share with anyone you wish
• Five shared spaces where your team members can do-develop and share apps
• Direct data connectivity to over 40 data sources
• Automated data refreshes
The global roll out of Qlik Sense Business is underway. Be one of the first by to start your 30-day trial now. You will be able to create your tenant in minutes, and begin creating and sharing apps immediately – all without any downloads or installations.
If you’re ever ready for more enterprise features – additional governance, API integrations and more data capacity – you can easily upgrade to Qlik Sense Enterprise on Qlik Cloud Services at any time.
Currently a Qlik Sense Cloud Business user?
Stay tuned for upcoming details next months. We’ll tell you how you can migrate from Qlik Sense Cloud Business and subscribe to Qlik Sense Business. You’ll also be eligible for a limited-time offer savings when you migrate your existing cloud subscription.
At Qonnections 2019 I hosted a session called “Qlik Sense Visualizations, best practice and top tricks”. I have received a lot of positive feedback, so I decided to make a part 2 with 41 more or less useful new tips.
Recent feature additions to Qlik Sense have certainly helped to expand the possibilities of customizing Sense, such as the container object, the dashboard bundle, alternate states, show conditions to name a few. But it’s also the power of the calculation engine and the expression language that many times provides a way forward tweaking the look and feel of Sense.
Most of the tips I will share in this post are invented by others and have been published before on Qlik Community. I highlighted some examples below, but there are many more tips included in the app.
Pad with Unicode white breaks, add a center line and use the absolute max as denominator. Showing two version, plain bars and circles, filled or empty. Sparklines are covered in the first set of tips.
Use the filter pane one grid high and change the label hold all values =concat(distinct Year,' | ').
Add two measures, one for line and one for the symbol. Use master measures to keep colors consistent.
Use the combo chart and custom marker layers on a secondary axis. Add a custom expression for the marker and the label. Tweak the axis and the expression to get the markers on the right place.
Create a copy of the combination field in the load script, in this case, ProductNames. Add to a pivot table, use count(OrderID) as measure, mask duplicates values with white text color. Credit: Swuehl, link to post.
This is a strict Venn diagram with all areas always present. Use an image of Venn diagram and the area layer of the map chart. Check out how to make a clickable chart of an image.
Can be made with the line chart in area mode with measures for the bands. Create a line chart, set to area mode, unstacked. Add master measures for the bands with the wanted color. Add master measure for actual. Add measures to chart, starting with actual and the bands in progressive order. Add reference lines for the bands with label and color.
Create bar chart, Add measure =1 label =' '. Color by the wanted measure, add label. Switch of axis, labels and value. Set number of bars to "Max". Set bar width to max in "Styling". Add legend at the bottom. Switch of legend title.
Full instructions and working examples can be found in the app below. Some of the tips are very easy to implement while others require a little more work. Most of them are independent of the Qlik Sense version but I recommend using the latest version.
To download the app, visit the Community post, 41 tips.
If you missed my previous postings, check out the previous apps I’ve shared on our community:
If you interested in visualizations, you should also check out Qlik GeoAnalytics, our highly capable add-on for geographic analysis. I've published two posts with advanced tips for Qlik GeoAnalytics:
Product Manager, Qlik Sense Visualizations and Qlik GeoAnalytics
No, all versions of Qlik Sense Desktop will no longer allow free access after 30 June 2020.
In Set Analysis, it is straightforward to make selections; to define the criteria for inclusion. But it is not as straightforward to define an exclusion. But there are in fact several ways to do this.
First of all, an inclusion can be defined the following way:
This expression is equivalent to saying “Sum the Amounts where Field equals X”.
But if you want to say the opposite – “where field does not equal X” – it becomes more complicated. The relation “not equal to” is not a Set operation. However, one way to do this is to use the implicit exclusion operator:
Note the minus sign in front of the equals sign. This will create an element set based on the existing selected values, but with the value X removed.
A second way to do this is to use the unary exclusion operator:
This will return the complement set of X and use this as element set in the set expression.
In many situations the two methods return identical sets. But there are cases when they are different. In the table below you can see that it makes a difference if there already is a selection in the field.
Note the difference on the row with the C. Since the implicit operator (the 2nd expression) is based on current selection, also the value C is excluded from the calculation. This is in contrast to the unary operator (the 3rd expression) that creates a completely new element set, not based on current selection.
We can also see that both of the above expressions exclude records where the field is NULL (the line where Field has a dash only). The reason is simple: As soon as there is a selection in the field, the logical inference will exclude NULL in the same field.
So what should you do if you want to exclude X but not NULL?
The answer is simple: Use another field for your selection. Typically you should use the primary key for the table where you find the Amount.
Here you need to use the element function E(), that returns excluded values. Hence, the above Set expression says: “Select the IDs that get excluded when selecting X.”
The table confirms that we get the records we want: X is excluded but NULL is still included.
With this, I hope that you understand Set Analysis somewhat better.
Further reading related to this topic:
The Qlik Academic Program has been working with students and lecturers from Birmingham City University for several years now, to introduce students to Qlik software and to help them to upskill in Data Analytics. We are pleased to announce that we have been able to go one step further, and the Academic Program resources are now part of the University’s Graduate+ Award Framework.
Graduate+ is a programme available to all students at Birmingham City University. It focuses on turning high-calibre students into work ready graduates, allowing them to develop professional and personal attributes. One of the skill areas included here is digital literacy, and as part of this, the Qlik Academic Program resources will allow students to develop data literacy and analytics skills. The resources offered by Qlik include training in Qlik Sense software and associated qualifications, as well as general training in analytical theories and concepts.
We are thrilled to have the opportunity to provide students across the whole University with our great resources. As data is becoming increasingly important across all levels of all organisations, it’s more important than ever that everyone has fundamental analytics skills. Being part of Graduate+ means that students from all disciplines can be exposed to the training materials and qualifications, not just those from traditional STEM subjects.
You can read the full article here on FENews. We are looking forward to seeing how this new partnership helps students at Birmingham City University to secure the jobs that they want in 2020 and beyond.
If you are a University student or lecturer and you would like to sign up for the free Qlik Academic Program, apply today!