Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
For a Qlik sense training course I have created a gauge displaying the ratio of males as a percentage of the total population. Because I wanted to have a benchmark, I set a limit which is dynamic with the use of a set-expression.
Whenever I select a different age group, the gauge changes to display a new number.
I have created a master item (measure) for this ratio and added this expression:
count(distinct(if(Gender='Male',PatientID)))
/
count(distinct(PatientID))
I don't know why but I thought of finding out a different way to write this expression. I tried some things and finally ended up with this:
count({1<Gender={'Male'}>} distinct(PatientID))
/
count(distinct(PatientID))
Can I conclude that both expressions actually do the same and performance-wise: does one way have an advantage over the other?
Dear All
The include variable is located behind the exit clause.
This script is not interrupted in the exit clause.
Why is the include variable executed?
*********** Script new *****
*************** Script end
Qlik Sense Version : Nov 2023 patch 7
Best Regard
Hanna.choi
when i am trying to create connection with source like youtube ,azure ,amazon athena ,office 365 sharepoint
asking authentication how i can solve this problem ?
mention answer step by step
We are trying to login our html mashup to Qlik Cloud using JWT auth.
We have already setup the JWT identity provider in the Qlik management console.
The JWT token is created using a php library and send for authorisation using the following code:
var config = {
host: 'qwxxxxxxxxxxxxxx.eu.qlikcloud.com',
prefix: '/',
port: 443,
isSecure: true,
webIntegrationId: 'xxxxxxxxxx', // from qlik management console
jwt: "eyJhb....UA", //token created using the php library
};
async function login() {
function isLoggedIn() {
console.log("checking logged in");
return fetch("https://" + config.host + "/api/v1/users/me", {
method: 'GET',
mode: 'cors',
credentials: 'include',
headers: {
'Content-Type': 'application/json',
'qlik-web-integration-id': config.webIntegrationId
},
}).then((response) => {
return (response.status === 200);
});
}
return isLoggedIn().then((loggedIn) => {
if (!loggedIn) {
console.log("not logged in");
return fetch("https://" + config.host + "/login/jwt-session", {
method: 'POST',
mode: 'cors',
credentials: 'include',
headers: {
'Content-Type': 'application/json',
'qlik-web-integration-id': config.webIntegrationId,
'Authorization': 'Bearer ' + config.jwt,
},
}).then((response) => {
if (response.status !== 200) {
console.log("failed logged in");
throw new Error('failed to login via jwt');
}
});
} else {
console.log("already logged in");
}
});
}
The response we get from the request is the following:
{
"errors": [
{
"title": "Authentication failed",
"detail": "No identity-provider is able to complete the exchange",
"code": "LOGIN-1",
"status": "401"
}
],
"traceId": "9cf4f041f5b6aa685eca85cce00075c3"
}
The JWT token is valid and properly decoded. We tested it by removing the "nbf" from the payload and the response mentioned that the nbf was missing.
Any thoughts what can be the problem?
Thanks in advance
Dear Friends,
I have requirement in which there are two dates (for simplicity Date1 and Date2). Requirement is to have a value per month to be aggregated sum of 4 prior months considering both Date1 and Date 2
For example, On Dashboard when users select a Date1 = Dec'23 then they should get a value for Dec 23 to be sum of previous 4 months i.e., {Aug'23 to Nov'23} where both Date1 and Date2 coincide. for example here in this scenario we should get sum of values from Date2 to be oct'23 and nov'23 = 37
Date1 | Date2 | Value |
Apr-23 | Jun-23 | 1 |
May-23 | Jul-23 | 6 |
Jun-23 | Aug-23 | 19 |
Jul-23 | Sep-23 | 15 |
Aug-23 | Oct-23 | 18 |
Sep-23 | Nov-23 | 19 |
Oct-23 | Dec-23 | 7 |
Nov-23 | Jan-24 | 2 |
Dec-23 | Feb-24 | 5 |
Kindly help on this dear friends!
I want to display the top 20 rows split into two straight tables. My table has only one dimension column. The rest are all measure columns. The Top N is calculated on the first measure column.
The first table should show the Top 10 rows. I've achieved this by setting the limitation to a fixed number and entering a value of 10. I want the second table to show the subsequent 10 rows, i.e. 11 to 20. I tried implementing this with the following formula :
If(Match(RowNo(), 11,12,13,14,15,16,17,18,19,20), DimensionField)
It doesn't work for this table. But this worked formula worked for me when I used it on a table with dimensions only.
I would appreciate any help in solving this issue.
Hi Friends,
I got a requirement that is Categories the types of Incidents from ServiceNow data.
Our source data from ServiceNow, every day we will load data from ServiceNow to Qlik sense. Actually the data flow is ServiceNow >> Gsheet >> Qliksense.
Actually the requirement is in the below:
Please find the below sample incident data which was raised by users with different short descriptions.
Incident_number | Short Description | Created By | Open Date | Due Date | State |
INC001 | Unable to access XYZ stream, please provide access | ABC | 3/27/2024 | 4/1/2024 | Open |
INC002 | Got error message like 'Access Denied' while accessing the ABC dashboard URL link | CDE | 3/26/2024 | 4/1/2024 | Open |
INC003 | I am unable to access the folder | FGH | 3/25/2024 | 4/1/2024 | Open |
INC004 | I am unable to sign in Workday portal | IJK | 3/24/2024 | 4/1/2024 | Open |
INC005 | Can you grand me access to the database | LMN | 3/23/2024 | 4/1/2024 | Open |
INC006 | Batch job failed to run | OPQ | 3/22/2024 | 4/1/2024 | Open |
INC007 | XYZ Dashboard qmc task aborted | RST | 3/21/2024 | 4/1/2024 | Open |
INC008 | Failed - Informatica xyz_inflow task incomplete | UVW | 3/20/2024 | 4/1/2024 | Open |
Here row number from 1 to 5 should fall under "Access Related Issue" category and row number from 6 to 8 should fall under "Batch Job Related Issue".
Category | Count of Incidents |
Access Related Issue | 5 |
Batch Job Related Issue | 3 |
How can we achieve this. Can you please help me this.
Appreciate your help and thanks in advance.
QS Version: May2023
Server: Windows 2008 R2, 600GB RAM, 52 Core CPU
ErrorCode:29803 and Calculation timed out error on opening a dashboard after some time.
It was working till yesterday but throwing error today.
I can't run the job the following error appearsI can't run the job the following error appears
Error: Could not create the Java Virtual Machine.
Error: A fatal exception has occurred. Program will exit.
Error occurred during initialization of VM
Unable to allocate tables for parallel garbage collection for the requested heap size.
Job EXPORT_TO_SKK_VIEW ended at 13:08 28/03/2024. [exit code=1]
Following are the memory settings for the VM
then suddenly a garbage collection appears as follows
So what is garbage collection?
What do I have to do?
I have added xms and xmx but the same error
How do I delete the trash that causes memory to become full like this?
Elevate your career with Connect. 15 Hands-on workshops and certifications for Data and Analytics.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!