This forum is for user/member-created articles across the entire Qlik portfolio. Any member that is logged in can create and publish an article here. You must choose the appropriate label in order for the articles to be properly categorized.
In many industries including education and healthcare, it is necessary to mask or de-identify certain sensitive fields for certain user groups but also be able to see the data in total for the purposes of comparison or benchmarking.
This can be achieved by setting a flag in the section access table for users to determine whether they should see the real data or a masked version of the sensitive fields. In the example below, the code is restricting some fields for users at the individual school level but allowing schools to compare their results to the rest of the schools in the data set.
Please refer to the attached QVF and remember that Section Access does not function in Qlik Sense Desktop and must be deployed to a Qlik Sense Server environment. I've also attached the QVW for the QlikView solution.
Notes
userA from SchoolA will see just Teacher and Student for School A records ONLY. All other schools will have the words De-identified in the Teacher and Student columns:
Credit to my colleague Yaniv Feldman yfe for this solution.
Matt Nunn
Qlik Consulting
If you work regularly on Qlik Sense after a period of time you may have noticed a slowdown. After a while a published application can generate errors caused by:
To give you a view of the state of your applications, Qlik has created an app: App (Metadata) Analyzer which is part of the Monitoring Apps group that allows governance of the entire Qlik Sense environment.
Monitoring Apps are a set of nine Qlik Sense applications allowing to have a governance of its Qlik environment through the Log files that are generated. These apps retain historical data for trend analysis. By default, two Monitoring Apps are installed: License Monitor and Operations Monitor, other apps can be imported.
The App (Metadata) Analyzer provides dashboards to analyze the metadata of all your Qlik apps in your Qlik Sense Enterprise deployment. In other words, analyze the data that your applications are composed of: the tables and fields in each table.
Through the Analyzer App you will be able to know.
This will ultimately allow you to
And therefore, be proactive in the maintenance of your applications.
The App (Metadata) Analyzer is available on Qlik Sense Enterprise On Premise and also available on the cloud: Qlik Sense Enterprise Saas and Qlik Sense Business SaaS.
For more details you may refer to the below video (Qlik App Analyzer demo) by Qlik :
Tutorial: Qlik Sense + Nginx Reverse Proxy for Automatic, Free HTTPS Certificates
If you’re looking for a straightforward way to get automatically renewed HTTPS certificates for your Qlik Sense Enterprise server, Let’s Encrypt + Nginx may be the way to go. This article provides configuration details on placing an Nginx reverse proxy in front of Qlik Sense Enterprise, plus automatic HTTPS certificate provisioning and renewal through Certbot.
I spent a bunch of time on and off trying to figure how to generate an email alert when a reload fails. It's something I and I'm sure many others wish was built-in and worked out-of-the-box, but it's actually somewhat possible. There are some restrictions - for me, I sometimes get reloads that hang, even though I put in a max retry, and since they don't "fail," I never get the notification. And obviously, the email notification is generalized to the point where you have to log into the QMC to discover which app failed. But if you're a Qlik Sense admin, you're smart enough how to make customized email alerts for each reload task :).
Setting up Qlik Web Connectors
Setting up Task Failure Triggers
Editing the Notification App
As written above, the actual script that runs the SMTP Connector is complete and already published to Qlik Sense. In other words, if you ever need to edit or re-publish the app or change the SMTP settings, there is little to do. Details below:
[Redacted] QS Script for Send Email app
/**** you shouldn't have to modify these after setup ****/
let vQwcConnectionName = '[web file connector]';
let vTimestamp = timestamp(now());
/**** Edit these variables to change the email contents. ****/
let vMessageInput = 'Qlik Sense Task Failure at ' & '$(vTimestamp)' & '.<br><br>To Review, <a href="https://[Qlik Sense URL].com/qmc">go to the QMC.</a>';
let vSubjectInput = 'Qlik Sense Task Failure';
let vSMTPserver = ' ';
let vFromName = ' ';
let vSMTPPort = '25';
/**** use %40 in place of the @ symbol ****/
let vToEmail = '';
let vFromEmail = '';
/**** DO NOT EDIT ****/
/**** These variable text strings properly encode the text in the "input" variables ****/
/**** Replaces all spaces with plus signs in the message string above ****/
let vMessage = replace('$(vMessageInput)',' ','+');
let vSubject = replace('$(vSubjectInput)',' ','+');
/**** DO NOT EDIT ****/
SMTPConnector_SendEmail:
LOAD
status as SendEmail_status,
result as SendEmail_result,
filesattached as SendEmail_filesattached
FROM [$(vQwcConnectionName)]
(URL IS [http://localhost:5555/data?connectorID=SMTPConnector&table=SendEmail&SMTPServer=$(vSMTPserver)&Port=$(vSMTPPort)&SSLmode=None&to=$(vToEmail)&subject=$(vSubject)&message=$(vMessage)&html=True&fromName=$(vFromName)&fromEmail=$(vFromEmail)&delayInSeconds=0&ignoreProxy=False&appID=], qvx);
// IMPORTANT: If, when loading the above script, you receive a 'Script Error' Dialog box with a 'Field Not Found'
// (or other) error, the first thing you should do is copy and paste the full request URL (i.e. the URL between the square [...]
// brackets IN THE QLIKVIEW / QLIK SENSE SCRIPT ERROR DIALOG) into a browser address bar and check the response.
Hello Community,
we have a couple of use cases where we would like to display specific dashboards 24/7 on a screen. Unfortunately, the current Session Timeout does not make it possible to fulfil this requirement. As I read in other threads in the forum it is not possible to change the Timeout settings at the moment - we are using Qlik Sense Enterprise. Displaying the KPI's through NPrinting is not an option as the app would need to be refreshed every five minutes.
Is anyone facing the same problem and has an idea or a workaround to solve it?
Thank you very much in advance!
Best regards,
Vanessa
Almost 7 years ago, working for a consultancy as their Qlik SME, I was tasked to create a BI platform-comparison with focus on Qlik.
Naturally, I Googled this and found a whole host of pre-made lists, most of which were all mentioning front-end things like "no waterfall in QlikView".
I was not satisfied with these lists, as the whole USP of Qlik, I think, is quite different and barely visible: the "data cloud", "symbolic representations", "associative data model" - call it what you want.
So I built a quick app to try and give business people a way of visualising and understanding this quasi-invisible aspect.
The attached 1-minute video is a super-quick reference to my full demo...
Thoughts?
THE Qlik USP in less than 60 seconds (vs all other BI platforms)
U.S. Customs and Border Protection (CBP) is taking new steps to counter human smuggling and other crimes arising in business networks. New public-private sector partnerships with advanced analytics are now preventing these emerging criminal activities by combining data in new ways. This is part of a broader movement across Federal and law enforcement agencies to combine historical, public, and real-time data to detect and respond to illicit business behaviors.
This whitepaper aims to demonstrate how Qlik’s Active Intelligence is a new paradigm for rapid response analytics for using and sharing business intelligence from diverse sources. Qlik is designed for scale through a governed approach that creates in-the-moment awareness, triggers immediate actions, and automates interoperable updates.
Problematic researchers pose alarming new risks to U.S. national security, supply chains, and critical infrastructure. Wittingly and unwittingly, these researchers expose potent technology breakthroughs to malign foreign actors through normal research activities and cultures.
Open, collegial research cultures increase national security vulnerabilities in three ways:
Only advanced analytics - combining historic, real-time, and public data - can counter these risks. This investigative capability must include in-memory data associations, all-source market sensing, and process automation to support diverse economic and security analysis teams.
Qlik uniquely overcomes these challenges by ingesting more data sources than anyone else, automating analytical processes, and maturing the workforce’s use of analytics. This drives trusted decisions, automated discovery, workforce data literacy, and governed information sharing with approved agency stakeholders.
The Department of Defense (DoD) is in a never-ending race to design, deliver, and sustain capabilities that are both flexible and adaptable to ever-changing missions, threats, and technologies. Now imagine an environment where hundreds of programs and systems could be designed, assembled, tested, and even sustained before the first parts are purchased or even used in real life.
This whitepaper aims at demonstrating how Qlik is helping agencies across the depart move closer to these goals by enabling data-driven decision making throughout the acquisition lifecycle.
How the DoD makes decisions is changing. Historical transaction reporting and static batch data analyses are giving way to predictive data science, streaming analytics, machine learning (ML), and artificial intelligence (AI). The DoD must embrace these new paradigms for more informed, real-time decisions to impact business, operations, and mission performance.
This whitepaper will address how Qlik can enable the DoD to achieve it's mission.
Here are some example show conditions. The second is if you have multiple different groups that shouldn’t have access to a given field.
=if(OMITGROUP=’SALARY’,0,-1)
=if(match(OMITGROUP,’SALARY’,’CONTACTINFO’,’ACCOUNTING’)>0, 0, 1)
This document can help to transfer files from N-Printing to sharepoint link instead of sharepoint folder
Below steps for Office 365 power automate:
Below steps for N-Printing:
Enjoy your practice and do customization how you need it!
Recent research studies in educational cognitive theory suggested that digital representations and the creation of digital artifacts provided by decision aids like Qlik Sense can greatly enhance learning performance in Project-Based Learning.
Qlik Sense provides a range of powerful visualization formats and collaborative tools in data sourcing and visualization, which are relatively easy to use for participants to build and share mental representations, through which learners can ‘cognitively’ manipulate their problem under the Project-based Learning , and interact with each other.
Educators at Xi'an Jiaotong-Liverpool University (China) worked on a business scenario to prepare for a business case where it is necessary to develop and challenge assumptions at different stages. Participants are divided into project teams and discuss those assumptions in virtual rooms. Project teams collect, interpret, analyze various forms of internal and external data, and present their results in the form of Qlik performance dashboards to a Judge Panel. Meanwhile, participants are invited to confront their opinions, make decisions and visualize various forms of data when completing successive collaborative learning activities, either synchronous or asynchronous, as well as to collect, interpret, analyze various forms of internal and external data along different steps of the learning process. This process is facilitated by internal scripts providing a set of instructions to participants
However, this can be really effective only when mental representations are consistent with learning tasks and if the learning process is supported by written instructional scripts: such internal scripts or their combination with external scripts could be made available to educators on Qlik Learning and Community Portals.
Fore more information, watch the video COGNITIVE AND BEHAVORIAL SKILLS: QLIK to enhance cognitive learning in Virtual Constructivist Learning Environments: (Qlik Ambassadors Event, April 2022)
https://drive.google.com/file/d/1aw19hjzDZ2wghdR3Lp5mdk8w0n8vwzWv/view?usp=sharing
This video shows you how to add images to straight tables in Qlik Sense and Qlik Cloud.
This article says that we have an alternative to copy bookmarks from one QVF to another in Qlik Sense
- Duplicate the app from which app we wanted to copy the bookmarks in physical location
F://QlikSense/Apps
Duplicate only “.file” in physical location
Copy to somewhere and rename it to any name like “App2.qvf” with .qvf
- Import the above app into QMC and publish the app into stream where you wanted
- Work on PostgreSQL DB in Qlik Central server to update the bookmarks
- How to connect to PostgreSQL DB – follow the 2nd step
- Copy bookmarks from one app to another – follow the below steps
- Please be careful when you are executing any query on PostgreSQL DB since it will impact an application
- Check the existing Bookmarks – for App1
SELECT *
FROM public."AppObjects"
where "ObjectType"='bookmark' and
"App_ID"=’App1_ID’
---- you can add if you have any filters to apply like Description
- Execute below one to install uuid module.
CREATE EXTENSION "uuid-ossp";
- Run below one to check module is working or not.
select uuid_generate_v4();
- Execute below query to copy Bookmarks from one QVF to another
Insert into PUBLIC."AppObjects"(
"ID","EngineObjectType","Attributes","ObjectType","PublishTime","Published","Approved","SourceObject",
"Name","EngineObjectId","ContentHash","Size","CreatedDate","ModifiedDate","ModifiedByUserName","App_ID","File_ID",
"Owner_ID","DraftObject","Description","AppObjectBlobId") select uuid_generate_v4(),"EngineObjectType","Attributes","ObjectType","PublishTime","Published","Approved","SourceObject",
"Name","EngineObjectId","ContentHash","Size","CreatedDate","ModifiedDate","ModifiedByUserName", ‘App2_ID’,"File_ID",
"Owner_ID","DraftObject","Description","AppObjectBlobId" from PUBLIC."AppObjects"
where "ObjectType"='bookmark' and
"App_ID"=‘App1_ID’
- Restart Repository Database services on Qlik Central server
This article talks about how to restore app with the same app ID if app gets deleted unfortunately by someone.
There are many ways to restore an app with same app ID:
- Restore the VM image of Qlik central server where the QVFs are stored.
- Find out the app ID of the deleted app.
- Copy the deleted app ID “file” and “.lock” files into physical location path (F:QlikSense\apps) and replace with the ID which gets deleted.
- Open PostgreSQL editor on central node.
- How to connect to PostgreSQL DB – follow the 2nd step here
- Create the app in PostgreSQL DB by running below query with the help of any existing app id
Insert into PUBLIC."Apps"(
"ID", "Name", "AppId", "PublishTime", "Published", "Description", "LastReloadTime", "Thumbnail", "CreatedDate", "ModifiedDate", "ModifiedByUserName", "Owner_ID", "Stream_ID", "SavedInProductVersion", "MigrationHash", "DynamicColor", "SourceAppId", "TargetAppId"
) Select 'Deleted APP ID’,"Name", "AppId", "PublishTime", "Published", "Description", "LastReloadTime", "Thumbnail", "CreatedDate", "ModifiedDate", "ModifiedByUserName", "Owner_ID", "Stream_ID", "SavedInProductVersion", "MigrationHash", "DynamicColor", "SourceAppId", "TargetAppId"
from public."Apps"
where "ID"='any existing app ID’ // existing app
above query will create the deleted app on QMC
- Check the app and data on QMC/HUB
- Create reload task or try to run the app – there is an issue here to refresh the task
- It will throw an error without any logs if we refresh either app or task
- Alternative1: We must duplicate the app and refresh it then publish into actual one in QMC
- Alternative2: Open data load script editor and reload the script
- Automate the Alternative1 by using power shell script to refresh it on daily basis