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

• Uncomment the commented section of the code
• Change userA, userB and adminUser to users in your environment
• The solution works for both QlikView and Qlik Sense.
• Consider aggregating the de-identified facts to reduce the number of records in the app.

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:

• The continuous growth of data volume.
• RAM that saturates by the size of applications and the calculations made.

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.

• The load time and size of all your applications.
• The location and owner of the applications.
• The RAM consumption of all your applications.
• The number of tables and fields present in each application as well as their RAM consumption.
• A color code to highlight items that require your attention based on your criteria.

This will ultimately allow you to

• Compare RAM consumption to the limit of your server.
• Highlight the most resource-demanding applications/tables.
• Optimize your apps
• Detect anomalies.

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 : 

https://youtu.be/GawDAkZjFoQ

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

1. If necessary, whitelist your Qlik Sense server’s IP in your mail relay.
2. Download the QlikWebConnectors zip folder from the Qlik support site: https://us-d.demo.qlik.com/download/ 
   1. Filter down to "Qlik Connectors" and under the "Products" section, scroll down to find "Qlik Web Connectors."
   2. Find the most recent Initial Release and click on the name to download - March 2020 at time of writing.
3. Extract that folder to the root of the C drive. Rename the folder to QlikWebConnectors if it is not already named so.
4. You may notice no installation has ran yet. We will get back to that later. If you open the QlikWebConnectors folder, you can run QlikWebConnectors.exe to start the program. A window will appear in the bottom right of your screen.
   
    

   

5. Click "open in default browser" to begin setup. Accept the license agreement.
6. While you can technically write out the script directly in a Qlik Sense app, a sanitized version of which I will provide below, the following is how to set up through the SMTP Connector.
7. There are a lot of Connectors available. Browse to the "Standard" tab and open "Qlik SMTP Connector." Highlight SendEmail and click Parameters.
8. Set up the fields according to how your mail server requires. Mine is set up to allow anonymous authentication but only whitelisted servers are allowed. Below is how mine is set up, but yours may be different.
   1. SMTP Server: FQDN of your mail relay
   2. Port: usually 25
   3. SSL Mode: depends on your setup - mine is anonymous so I set to "None"
   4. To: email you want to receive the email alerts
   5. Subject: email subject
   6. Message: email body
   7. HTML: check this box so you can use HTML tags in your Qlik script
   8. From name: display name the email is being sent from
   9. From email: email address the email is being sent from
9. Click "Save Inputs & Run Table." On success, the To Email you entered above will receive the email.
10. Click over to the "Qlik Sense (Standard Mode)" tab. You will see some instructions and some auto-generated code. Copy it to the clipboard.
    
11. Create a new Qlik Sense app titled something descriptive (e.g. "Send Email"), open the Data Load Editor, and paste the code into the Data Load Editor. You may get a warning that the app has no data, which is expected and can be safely ignored.
    
12. Follow the instructions highlighted in red to set up the Web File connection. It should look as below. Give it a descriptive name as well. Make sure you create this as the Web Connector program is still running on the Qlik server.
    
13. Make sure the variable "vQwcConnectionName" matches the name of the email connection you just created.
    
14. Click "Load Data" to test the email and make sure it gets sent to the email you set above.
    
15. The obvious quirk of this set up is it requires the WebConnector program to be running constantly. Luckily, QlikWebConnectors can be set up to run as a service.
16. On the Qlik Sense server, browse to C:\QlikWebConnectors\BatchFiles.
17. Edit "Install Service.bat" and make sure the .NET and QlikWebConnectors_SVC.exe paths are valid.
    
18. Close Notepad and run the "Install Service.bat" as an admin. When the script has completed after a few seconds, press any key to close.
    
19. Open Services.msc, find Qlik Web Connectors, and change the Log On to your Qlik service account. You may otherwise run into errors in the future if you try to re-setup any connectors.
20. Start the service.
21. Right-click, Properties, and switch to the Recovery tab. Change the "First Failure" dropdown to "Restart the service." Change "Restart service after" to zero minutes. Click Apply and OK.
    
22. If you try to run the QlikWebConnectors.exe program again, you will get an error that the program is already running.
    

Setting up Task Failure Triggers

1. Log into the QMC.
2. Browse to Tasks either from the Dashboard or the sidebar.
   
   
3. Create a new task, name it something descriptive, and select the Send Email app you created above as the app. The email sends within seconds so it is recommended to lower the default timeout and increase the retries, though this depends on your environment.
   
   
4. Click the "Actions" dropdown and select "Create new task event trigger."
   
   
5. Name the trigger task something descriptive relative to the app, click "Add Task," change the dropdown to "Task Failed," and select the task you want to be alerted on a failure of. You can leave the time constraint as the default, it is not relevant when a task chain is only two tasks long, as is the case now. More information here: https://help.qlik.com/en-US/sense/June2019/Subsystems/ManagementConsole/Content/Sense_QMC/create-reload-tasks-from-tasks.htm
   
   
6. Repeat this process for each individual task you want to be alerted on. You can add a new Send Email app per app, new trigger event per Send email app, or new task per trigger event. I recommend the second for the sake of cleanliness and succinctness.
   
   
    
7. Make sure this trigger event process is repeated for each new app that is published in the future.
8. When you go to the Tasks page in the QMC, you will notice little chain symbols for every app that is connected to the Send Email app and vice versa. You can click on this chain symbol to view the task chains from either direction.
   

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:

1. When you set up the SMTP Connector and run the parameters, you will be given the below line of Qlik script. Notice how hard-coded the (unredacted) bold parameters are.
   
2. Of course, hard-coding is not best practice and the syntax is not obvious at first glance. The bold parameters are replaced by variables in the actual published Qlik Sense app.
   
   
3. Variables, when placed in the URL script line, must be in the form of $(variablename). If you look closely, every parameter is simply "parameter1=$(variable1)&parameter2=$(variable2)&..." The parameters from the original script block are untouched while the hard-coded values are now variables.
   
   
4. The script blocks are separated into sections, marked by comment sections. To go through them one-by-one:
   1. The first section is for script neatness. vQwcConnectionName pulls the webfile defined above into the script. vTimestamp is used for the email body.
      
   2. These variables are the content that you will edit. The two "...Input" variables define the content of the email body and subject. More on them in the next section. The rest of the variables are what they sound like.
      
   3. I would strongly recommend never touching these lines. The URL script line in Qlik Sense requires plus signs in the place of spaces for each value. These two lines replace the spaces with plus signs for you so editing the value is easier.
      

[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:

1. Creating undetected gaps in military and civilian technology development ecosystems
2. Expanding the attack surface exposed to cybersecurity and supply chain threats
3. Obscuring and blending financial flows between legitimate and malign funding sources

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:

• Please log in to this https://flow.microsoft.com/en-us/
• Use your credentials to login (Should be linked with Office 365)
• You will see this home page

• Search for template (Ex: Search string: Attachment)
• And you will see some option below, please click below highlighted one

• It will go to connection validation

• Click Continue, before that please make sure validation success, if fails you should be fix to continue
• Please scroll right on the window If that is not popup after you hit Continue
• You will see this

• Please select as per below using “Show advanced options” from above screenshot

• Here, from 3rd step you no need to select only Inbox It’s up to you in case If you have outlook rules on Office 365
• After my selection, it is like this

• If you scroll down, there is a section called “Apply to each” and “Apply to each Attachment on the email”. In both section you need to fill your destination sharepoint address and path

• Here, you can select Site address and Folder path
• And after that, this is how it looks for me

1. Sites address you can click drop down and It will search If you part of any?
   1.       For this, you should have read & write access
2. And for Folder path I have used one of the common, this is for your destination and your list how you want to be store

• Scroll down and look for Save

• Once you Save, you will be landing same section, for that you can check If that success correctly or not?

• If you don’t want, you can turn off them

• If you want to check option what you have done just click on flow, that will point to below

• If you want to check your Run history, you can click option above with

   

Below steps for N-Printing:

• Go to N-Printing and try to trigger task which you want to generate and wait until you receive an email to outlook

• Once you receive, please wait few minutes to start process in Power automate to trigger that, you can refresh and see like below?

• Go to sharepoint and look for attachment. If that is not available, it means you have something wrong in Office 365

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. 

Environment

• Qlik Sense
• Qlik Sense Business
• Qlik Cloud

Transcript

This article says that we have an alternative to copy bookmarks from one QVF to another in Qlik Sense 

1. 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

2. Import the above app into QMC and publish the app into stream where you wanted
3. Work on PostgreSQL DB in Qlik Central server to update the bookmarks
4. How to connect to PostgreSQL DB – follow the 2^nd step
5. Copy bookmarks from one app to another – follow the below steps
6. Please be careful when you are executing any query on PostgreSQL DB since it will impact an application 
   1. 1. 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

   2. 1. Execute below one to install uuid module.

       

      CREATE EXTENSION "uuid-ossp";

   3. 1. Run below one to check module is working or not.

      select uuid_generate_v4();

   4. 1. 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’

   5. Restart Repository Database services on Qlik Central server
   6.  

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:

1. Restore the VM image of Qlik central server where the QVFs are stored.
2. Find out the app ID of the deleted app.
3. Copy the deleted app ID “file” and “.lock” files into physical location path (F:QlikSense\apps) and replace with the ID which gets deleted.
4. Open PostgreSQL editor on central node.
5. How to connect to PostgreSQL DB – follow the 2^nd step here
6. 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

 

7. Check the app and data on QMC/HUB
8. Create reload task or try to run the app – there is an issue here to refresh the task
   1. It will throw an error without any logs if we refresh either app or task
   2. Alternative1: We must duplicate the app and refresh it then publish into actual one in QMC
   3. Alternative2: Open data load script editor and reload the script
   4. Automate the Alternative1 by using power shell script to refresh it on daily basis