Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This space offers a variety of blogs, all written by Qlik employees. Product and non product related.
By reading the Product Innovation blog, you will learn about what's new across all of the products in our growing Qlik product portfolio.
The Support Updates blog delivers important and useful Qlik Support information about end-of-product support, new service releases, and general support topics.
This blog was created for professors and students using Qlik within academia.
Hear it from your Community Managers! The Community News blog provides updates about the Qlik Community Platform and other news and important announcements.
The Qlik Digest is your essential monthly low-down of the need-to-know product updates, events, and resources from Qlik.
The Qlik Education blog provides information about the latest updates of our courses and programs with the Qlik Education team.
Hi everyone,
Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from Qlik experts.
The Techspert Talks session from March looked at Understanding Set Analysis.
But wait, what is it exactly?
Techspert Talks is a free webinar held on a monthly basis, where you can hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners today.
This session covers:
Click on this link to see the presentation.
What if you could prepare data (join, transform, STORE, etc.) using Qlik script - WITHOUT creating a standalone app - without sheets? Would you like that? Well, would you? Well now you can - introducing our new script object and script editor - with data preview and more! Watch this #qlik #SaaSin60 to learn more!
We have now added the ability to create Qlik scripts directly from the hub, ana managed in the catalog - using a new and improved script editor. Users can now build and deploy Qlik scripts upstream of analytics apps, which can be executed and result in output files in formats such as QVD and PARQUET that can be stored in the hub and used for analytics and AutoML applications. The script editor also now includes a data preview feature, allowing users to get better insight when developing scripts. This provides our customers with an improved workflow for preparing data, while setting the stage for future enhancements to analytics data prep capabilities.
Share data from Qlik outside of the standard business delivery systems such as Teams, Slack and Email. Have conversations with your
Governed conversations, data and updates can now be shared to both Customers and Colleagues via WhatsApp, enabling them delivery and key data points from Qlik without needing Qlik licensing, or corporate comms infrastructure such as Teams or SharePoint.
Ideal for rolling out updates for Customers to WhatsApp directly from Qlik. Examples include delivering order status updates, surveys and regular KPI delivery.
Gather ultra-responsive feedback from clients and colleagues via a native and frequently used platform in WhatsApp.
Discover how sunburst charts can help you. Explore multiple ways of displaying hierarchies and measures, drill-down, flexible labels, custom colors, center content, HTML tooltips, and more.
Experience firsthand how an interactive sunburst chart can empower intuitive exploration of hierarchical data structures through a set of sliced concentric rings and how it can be tailored to specific needs.
Everyone looking to enable more efficient and insightful exploration of hierarchical datasets within their Qlik environment.
This app features sunburst visualizations powered by AnyChart's Sunburst Chart extension for Qlik Sense, using U.S. Census data for illustration.
There have been new Qlik Sense features the past few months that I was excited to see. One of my favorites, which I am sure you are aware of, is the layout container. If you have not heard about it, check out Michael’s blog post here. Another favorite of mine is the copy and paste style feature which allows developers to copy and paste styles from one visualization to another. With all the styling options available in visualizations, being able to copy and paste styles saves time and eliminates the need to go into the styling properties of each visualization and set all the styling options you would like to use.
Some of the latest charts that have been upgraded to the new styling property panel are the Grid, Funnel and Sankey, giving users the ability to customize the title, subtitle, footnote, and background of a chart as well as the style the axes, labels, legends, and values in a visualization. Borders and shadows can be added to these visualizations as well.
The Filter Pane now has font styling for the title, subtitle, footnote, and header as well as font header and content styling. Like the charts above, borders and shadows can be added as well. Developers can change the background color or use an image in the background and control the color of the selected state. Here are a few examples.
With all these styling options, it is awesome that developers can now copy and paste the style from one visualization to another. If you remember the QlikView days, you know how valuable this feature is. Assume I have an app with a theme applied and have made some styling changes to the Margin KPI (see image below). If I want to apply the same styling changes to the Margin %, I have two options. One option is to open the styling properties of the Margin % KPI and make the same changes to the background color, border color and shadowing.
The second option and the easiest option is to right click on the Margin KPI while in Edit mode, click on the three dots (…) and select Copy style.
Then right click on the Margin % KPI, click on the three dots (…) and select Paste style.
That is a lot easier than styling the KPI manually, especially if there are multiple visualizations to update.
There are a few limitations to using the copy and paste style - you cannot copy and paste the style in a map or a master visualization. New styling properties for visualizations are being add all the time, giving users many options to style and make their app stand out. The copy and paste functionality is a great addition to Qlik Sense and makes designing and styling apps easier.
Thanks,
Jennell
A common situation when loading data into a Qlik document is that the data model contains several dates. For instance, in order data you often have one order date, one required date and one shipped date.
This means that one single order can have multiple dates; in my example one OrderDate, one RequiredDate and several ShippedDates - if the order is split into several shipments:
So, how would you link a master calendar to this?
Well, the question is incorrectly posed. You should not use one single master calendar for this. You should use several. You should create three master calendars.
The reason is that the different dates are indeed different attributes, and you don’t want to treat them as the same date. By creating several master calendars, you will enable your users to make advanced selections like “orders placed in April but delivered in June”. See more on Why You sometimes should Load a Master Table several times.
Your data model will then look like this:
But several different master calendars will not solve all problems. You can for instance not plot ordered amount and shipped amount in the same graph using a common time axis. For this you need a date that can represent all three dates – you need a Canonical Date. This is how you create it:
First you must find a table with a grain fine enough; a table where each record only has one value of each date type associated. In my example this would be the OrderLines table, since a specific order line uniquely defines all three dates. Compare this with the Orders table, where a specific order uniquely defines OrderDate and RequiredDate, but still can have several values in ShippedDate. The Orders table does not have a grain fine enough.
This table should link to a new table – a Date bridge – that lists all possible dates for each key value, i.e. a specific OrderLineID has three different canonical dates associated with it. Finally, you create a master calendar for the canonical date field.
You may need to use ApplyMap() to create this table, e.g. using the following script:
DateBridge:
Load
OrderLineID,
Applymap('OrderID2OrderDate',OrderID,Null()) as CanonicalDate,
'Order' as DateType
Resident OrderLines;
Load
OrderLineID,
Applymap('OrderID2RequiredDate',OrderID,Null()) as CanonicalDate,
'Required' as DateType
Resident OrderLines;
Load
OrderLineID,
ShippedDate as CanonicalDate,
'Shipped' as DateType
Resident OrderLines;
If you now want to make a chart comparing ordered and shipped amounts, all you need to do is to create it using a canonical calendar field as dimension, and two expressions that contain Set Analysis expressions:
Sum( {$<DateType={'Order'}>} Amount )
Sum( {$<DateType={'Shipped'}>} Amount )
The canonical calendar fields are excellent to use as dimensions in charts, but are somewhat confusing when used for selections. For this, the fields from the standard calendars are often better.
Summary:
A good alternative description of the same problem can be found here. Thank you, Rob, for inspiration and good discussions.
Hello Qlik Users!
An issue has been identified for Qlik Replicate users when using Google Big Query as the Target Endpoint. The load may fail if the dataset is outside the US and the region is not set for the INFORMATION_SCHEMA.
The current workaround is as follows:
$info.query_syntax.check_schema_exist
For its vale enter - select count(*) from region-eu.INFORMATION_SCHEMA.SCHEMATA where SCHEMA_NAME = '${TABLE_OWNER}'
4. Save and restart the task.
Note: The above script will force Qlik Replicate to query with the syntax of ‘region-eu’. Please use the relevant region value.
For more information, please see Unqualified INFORMATION_SCHEMA queries views will default to returning metadata from outside the US.
If you have any questions, please let us know in the comments below. If you found this information useful, give the post a ‘like’! Make sure you’re subscribed to the Qlik Support Updates Blog to get the latest information from Qlik Support.
Thank you for choosing Qlik!
Kind regards,
Qlik Global Support
Table of Contents
Version 5.1. Current as of: 29th February 2024
Qlik and Talend, a Qlik company, may from time to time use the following Qlik and Talend group companies and/or third parties (collectively, “Subprocessors”) to process personal data on customers’ behalf (“Customer Personal Data”) for purposes of providing Qlik and/or Talend Cloud, Support Services and/or Consulting Services.
Qlik and Talend have relevant data transfer agreements in place with the Subprocessors (including group companies) to enable the lawful and secure transfer of Customer Personal Data.
You can receive updates to this Subprocessor list by subscribing to this blog or by enabling RSS feed notifications.
Third party subprocessors for Qlik Cloud |
||
Third Party |
Location of processing |
Service Provided |
Amazon Web Services (AWS) |
If EU region is chosen: - Ireland (Republic of); & Paris, France (back-up); or - Frankfurt, Germany; & Milan, Italy (back-up); or - London, UK; & Spain (back-up).
- Frankfurt, Germany (Blendr only). If US region is chosen: - North Virginia, US; & Ohio, US (back-up). Customer may select one of three APAC locations: - Sydney, Australia; & Melbourne, Australia (back-up); or - Singapore; & Seoul, South Korea (back-up ); or - Tokyo, Japan; Osaka, Japan (back-up). |
Qlik Cloud is hosted through AWS |
MongoDB |
If EU region is chosen: - Ireland (Republic of);& Paris, France (back-up); or - Frankfurt, Germany; & Milan, Italy (back-up); or - London, UK; & Spain (back-up)
- Frankfurt, Germany (Blendr only). If US region is chosen: - North Virginia, US; & Ohio, US (back-up). Customer may select one of two APAC locations: - Sydney, Australia; & Melbourne, Australia (back-up); or - Singapore; & Seoul, South Korea (back-up). |
Any data inputted into the Notes feature in Qlik Cloud |
Third party subprocessors for Qlik Support Services and/or Consulting Services The vast majority of Qlik’s support data that it processes on behalf of customers is stored in Germany (AWS). However, in order to resolve and facilitate the support case, such support data may also temporarily reside on the other systems/tools below. |
||
Amazon Web Services (AWS) |
Germany |
Support case management tools |
Salesforce |
UK |
Support case management tools |
Grazitti SearchUnify |
United States |
Support case management tools |
Microsoft |
United States |
Customer may send data through Office 365 |
Ada |
Germany |
Support Chatbot |
Persistent |
India |
R&D Support Services |
Jira Cloud |
Germany, Ireland (Back-up) |
R&D support management tool |
Altoros |
United States |
R&D Support Services |
Ingima |
Israel |
R&D Support Services |
Galil |
Israel |
R&D Support Services |
Third party subprocessors for Qlik mobile device apps |
|
|
Google Firebase |
United States |
Push notifications |
Third party subprocessors for Talend Cloud |
||
Third Party |
Location of processing |
Service Provided |
Amazon Web Services (AWS) |
Talend Cloud AMERICAS: - Virginia, US; & Oregon, US (backup). EMEA: - Frankfurt, Germany; & Ireland (Republic of)(backup). APAC: - Tokyo, Japan; & Singapore (backup); or - Sydney, Australia; & Singapore (backup).
Stitch AMERICAS: - Virginia, US; & Oregon, US (backup). EMEA: - Frankfurt, Germany; & Ireland (Republic of) (backup). |
These Talend Cloud locations are hosted through AWS |
Microsoft Azure |
United States: California; Virginia (backup) |
These Talend Cloud locations are hosted through Microsoft Azure |
MongoDB |
See Talend Cloud locations above |
|
Third party subprocessors for Talend Support Services and/or Consulting Services: In order to provide Support and/or Consulting Services, the following third party tools may be used. |
||
Sub-processor |
Data Center Location |
Service Provided |
Github |
United States |
Support ticket replication, troubleshooting |
Intercom |
United States |
In-app customer support messaging service |
Atlassian |
France United States |
Project management; support issue tracking |
Jira Cloud |
Germany, Ireland (Back-up) |
R&D support management tool |
Microsoft |
United States |
Email provider, if the Customer sends Customer Personal Data through email. |
Proofpoint Secure Share
|
United States
|
File sharing if Customer files include Customer Personal Data. |
Salesforce |
United States |
CRM; support case management |
Affiliate Subprocessors These affiliates may provide services, such as Consulting or Support, depending on your location and agreement(s) with us. Our Support Services are predominantly performed in the customer’s region: EMEA – France, Sweden, Spain, Israel; Americas – USA; APAC – Japan, Australia, India. |
|
Subsidiary Affiliate |
Location |
QlikTech International AB, Talend Sweden AB |
Sweden |
QlikTech Nordic AB |
Sweden |
QlikTech Latam AB |
Sweden |
QlikTech Denmark ApS |
Denmark |
QlikTech Finland OY |
Finland |
QlikTech France SARL, Talend SAS |
France |
QlikTech Iberica SL (Spain), Talend Spain, S.L. |
Spain |
QlikTech Iberica SL (Portugal liaison office), Talend Sucursal Em Portugal |
Portugal |
QlikTech GmbH, Talend Germany GmbH |
Germany |
QlikTech GmbH (Austria branch) |
Austria |
QlikTech GmbH (Swiss branch), Talend GmbH |
Switzerland |
QlikTech Italy S.r.l., Talend Italy S.r.l. |
Italy |
Talend Limited |
Ireland |
QlikTech Netherlands BV, Talend Netherlands B.V. |
Netherlands |
QlikTech Netherlands BV (Belgian branch) |
Belgium |
Blendr NV |
Belgium |
QlikTech UK Limited, Talend Ltd. |
United Kingdom |
Qlik Analytics (ISR) Ltd. |
Israel |
QlikTech International Markets AB (DMCC Branch) |
United Arab Emirates |
QlikTech Inc., Talend, Inc., Talend USA, Inc. |
United States |
QlikTech Corporation (Canada), Talend (Canada) Limited |
Canada |
QlikTech México S. de R.L. de C.V. |
Mexico |
QlikTech Brasil Comercialização de Software Ltda. |
Brazil |
QlikTech Japan K.K., Talend KK |
Japan |
QlikTech Singapore Pte. Ltd., Talend Singapore Pte. Ltd. |
Singapore |
QlikTech Hong Kong Limited |
Hong Kong |
Qlik Technology (Beijing) Limited Liability Company, Talend China Beijing Technology Co. Ltd. |
China |
QlikTech India Private Limited, Talend Data Integration Services Private Limited |
India |
QlikTech Australia Pty Ltd, Talend Australia Pty Ltd. |
Australia |
QlikTech New Zealand Limited |
New Zealand |
In addition to the above, other professional service providers may be engaged to provide you with professional services related to the implementation of your particular Qlik and/or Talend offerings; please contact your Qlik account manager or refer to your SOW on whether these apply to your engagement.
Qlik and Talend reserve the right to amend its products and services from time to time. For more information, please see www.qlik.com/us/trust/privacy and/or https://www.talend.com/privacy/.