Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,274 members
  • 5,774 online
  • 1,991,552 posts
  • 149,197 Solutions
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    Script error: Invalid expression

    I have employee data - EmpName, Joining Date, Exit Data and added Flag value status as current, New and exit. Each month there are new and exit employ... Show More

    I have employee data - EmpName, Joining Date, Exit Data and added Flag value status as current, New and exit. Each month there are new and exit employees. The next month current is a calculated value using previous month data.

    I am getting Invalid Expression for the below script. Can someone please help me understand what is missing in the below.

    Load
    count(if(status='Current',"EmpName")) as JanExisting,

    count(if(status='Current',"EmpName"))
    +count(if(status='New' and Month='Jan',"EmpName")) -
    count(if(status='Exit' and Month='Jan',"EmpName"))
    as JanFinal
    Resident MyTable;

    Load
    JanFinal +
    count(if(status='New' and Month='Feb', "EmpName", null())) -
    count(if(status='Exit' and Month='Feb', "EmpName", null()))
    as FebFinal

    Resident MyTable;

    Load
    FebFinal +
    count(if(status='New' and Month='Mar', "EmpName", null())) -
    count(if(status='Exit' and Month='Mar', "EmpName", null()))
    as MarFinal
    Resident MyTable;

    Show Less
  • forum

    App Development

    Creating Timeline hart on Qlik Sense

    I have a list of different projects with their planned start/ finish date .Can any one help me to crate timeline chart in dash board ?
  • forum

    New to Qlik Analytics

    Link table for accounting data in OLE DB data and budget data from Excel File

    Hi, I have a problem where I need to get Transaction data from a OLE DB data source and then add en Excel file with manually entered Budget data for f... Show More

    Hi,

    I have a problem where I need to get Transaction data from a OLE DB data source and then add en Excel file with manually entered Budget data for four different companies, the load data look like this compressed with the relevant fields for two of the companies as below.

    I add the company name as Client field for every company and the joined data for Transactions table is working as supposed.

    My problem is that the budget data is added on the last day of the month because it's mainly relevant to look at this aggregated per month. But since there are multiple transactions in the Transaction data the last day of the month every month the Budget data get multiplied for every occurrence of that date.

    What I've found is that I should use a Link table to solve this issue but it seems that my skills is not enough to get the script right.

    I would like to group interval of accounts for example revenue, material cost, gross profit etc. for set analysis and add a master calendar (or similar) to do analysis on different time periods. Is it possible to have a Link table for Client, account and date fields and then add grouping and master calendar connected in the Link table or do you have to do this in the Load for the original data sources?

    LIB CONNECT TO 'Briljantdata - MGA (ad_ext_kons)';
     
    Transactions:
     
    LOAD 
     
    'MGA' as Client,
        bel, // (amount field)
        kto, // (Account field)
        trdat; // (Date field)
    SQL SELECT
        bel,
        kto,
        trdat
    FROM rtr;
     
     
    LIB CONNECT TO 'Briljantdata KJ (ad_ext_kons)';
     
    join(Transactions)
    LOAD
    'KJ' as Client,
        bel, // (amount field)
        kto, // (Account field)
        trdat; // (Date field)
    SQL SELECT
        bel,
        kto,
        trdat
    FROM rtr;
     
    LOAD
    'MGA' as Client,
        kto, // (Account field)
        trdat, // (Date field)
        Budget_belopp // (Amount field)
    FROM [lib://AttachedFiles/Qlik sense Budget MGA 22-23 & 23-24.xlsx]
    (ooxml, embedded labels, table is Budgetdata_MGA);
     
    LOAD
    'KJ' as Client,
        kto, // (Account field)
        trdat, // (Date field)
        Budget_belopp // (Amount field)
    FROM [lib://AttachedFiles/Qlik sense Budget KJ 22-23 & 23-24.xlsx]
    (ooxml, embedded labels, table is Budgetdata_KJ);
     
    Help is much appreciated!
    Show Less
  • forum

    App Development

    Why is the include variable executed?

    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... Show More

    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 *****

    vServername = ComputerName() ;
    trace $(vServername);
    if '$(vServername)' = 'QlikDev' then 
    trace '------1';
    else
    trace '------2';
    end if
     
    exit script;
     
    vTargetPath_qvs = 'lib://File_Folder ;
    $(Must_Include=[$(vTargetPath_qvs)/AUTH/Authorization.qvs]);
     
    exit script;

     

    *************** Script end

     

    Qlik Sense Version : Nov 2023 patch 7

     

    Best Regard

    Hanna.choi

    Show Less
  • forum

    New to Qlik Analytics

    marketing campaign analysis

    Hi guys,Are there any resources regarding qlik sense marketing campaign analysis? Any help will be appreciated. Thanks a lot!
  • forum

    New to Qlik Analytics

    difference in meaning in (set) expressions

    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 hav... Show More

    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?

    Show Less
  • forum

    Installing and Upgrading

    Connexion à une base de données HFSQL

        Bonjour, Je rencontre actuellement un problème de connexion à une base de données hfsql Type de base de données : JDBC généralURL : jdbc :... Show More
     
     

    Bonjour,

    Je rencontre actuellement un problème de connexion à une base de données hfsql

    Type de base de données : JDBC général
    URL : jdbc : odbc : nom du serveur 
    Jar Pilote : rt (à partir de jre 7 64 bits)
    Nom de la classe : sun.jdbc.odbc.JdbcOdbcDriver
    Lorsque je vérifie la connexion, j'obtiens ce message d'erreur :

    Aucun pilote approprié trouvé pour jdbc

    J'ai besoin d'aide à ce sujet. Merci d'avance .

    Show Less
  • forum

    Connectivity & Data Prep

    Connection issue

    when i am trying to create connection with source like youtube ,azure ,amazon athena ,office 365 sharepoint    asking authentication  how i can solve ... Show More

    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 ?

    venkatesh143_0-1711611479716.png

    mention answer step by step

    Show Less
  • forum

    Integration, Extension & APIs

    JWT authentication in mashup

    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.Th... Show More

    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

    Show Less
  • forum

    New to Qlik Analytics

    Need Help on How to handle two dates filter conditions

    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 aggrega... Show More

    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!

    Show Less
Leaderboard

Customer Story

Qlik Data Integration & Qlik Replicate story

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.

Customer Story

Building a Collaborative Analytics Space

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.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!