Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 219,331 members
  • 6,965 online
  • 1,998,180 posts
  • 149,813 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    Integration, Extension & APIs

    Connect to Engine API from Python script

    Hi there 🙂 We are trying to connect to the Engine API of our Qlik Sense Enterprise (on Windows) installation from a Python script, using a websocket.... Show More

    Hi there 🙂

    We are trying to connect to the Engine API of our Qlik Sense Enterprise (on Windows) installation from a Python script, using a websocket. Qlik is running in a virtual machine in Azure.

    After following these instructions on how to call Qlik Sense Engine API with Python (thanks @Damien_Villaret) I get this response:

     

    {"jsonrpc":"2.0","method":"OnAuthenticationInformation","params":{"loginUri":"https://server.domain.com/internal_forms_authentication/?targetId={someID}","mustAuthenticate":true}}

     

    I understand from other posts that this means that there is a problem at the authentication stage. I have checked our certificates many times and everything seems to be normal there.

    In the other hand, we have managed to connect to the QRS from a Python script with "requests".  But the authentication through certificates failed again. We could only make it through by using Windows authentication. Which is an option not available to connect to the Engine API using a websocket, if I am not mistaken.

    So, it seems that there is indeed a problem with the certificates, although Qlik is working flawlessly (if this helps, I am running the scripts from the same server where Qlik is installed, which is already whitelisted in Qlik).

    So the question is: where should I start troubleshooting this issue? The virtual proxies? Security rules? Any kind of additional validation of the certificates I must do in Qlik?

    Any orientation will be hugely appreciated.

    Best,

    Ginés - Solvica

     

    Show Less
  • forum

    App Development

    How to only view records with 1 source

    Hi, I need your help quite urgently.  I have 2 sources, so 2 fields with the name 'code'. I need to compare them so I added a 'flag' into the sources:... Show More

    Hi, I need your help quite urgently. 

    I have 2 sources, so 2 fields with the name 'code'. I need to compare them so I added a 'flag' into the sources: 'Source 1' as Flag and 'source 2' as Flag. 

    I need to find the codes who only have 'source 1'. So they are missing in source 2. 

    All those codes have 2 sources in this example: source 1 and 2. 

    Femke_DPG_0-1715609582473.png

    I only need the codes with source 1 (and not source 2). 

    load script example (basic):

    load 

    code as 'check code'

    Source 1 as Flag

    From source 1

     

    load 

    code as 'Check code'

    Source 2 as Flag

    From source 2

     

    Can anyone please help me? 

    Many thanks! 

     

    Show Less
  • forum

    New to Qlik Analytics

    How to create YTD's (and MAT's) and create the chart as shown?

    I've been trying all day to create YTD perios in order to create a chart showing figures compared over the current year period. I'm used to having YTD... Show More

    I've been trying all day to create YTD perios in order to create a chart showing figures compared over the current year period. I'm used to having YTD's in my data and simply adding them to my chart in Excel but in Qlik, I can't seem to work this out.

     

    Below is how I would have it created in Excel:

    YTD.PNG

    This makes an easy year on year comparison possible.

    But how can I get ytd's and add them to a grouped bar chart like above AND have these refreshed automatically upon a new data load?

     

    I' ve been puzzling with expressions for dimensions in the chart but that didn't work out, I tried to add a variable containing the YTD (add wanting to add YTD-1 and YTD-2 later on).

    Show Less
  • forum

    Qlik Cloud Data Integration

    Synced users not able to authenticate

    I created 2 tables(qlik_users and qlik_attribute) in database (screenshot attached) and successfully synced then using user directory connector ,  But... Show More

    I created 2 tables(qlik_users and qlik_attribute) in database (screenshot attached)
    and successfully synced then using user directory connector , 

    But these synced users are failing to authenticate / login to Qlik hub and  QMC

     

    Tried different ways to resolve this , - 

    1. allocated license to user (Analyser and Professional)
    2.  allocated the role (root admin)
    3.  tried to check/uncheck "Sync user data for existing users" option
    4. create and modify security rules and license allocation rules.

     

    But nothing worked, please help if anyone can provide suggestions 

     

    Show Less
  • forum

    Qlik Application Automation

    Compare field value to list of values

    Hi everyone, I am currently working on one of my first automations. I have used this very good knowledge base article to create a Loop and reduce auto... Show More

    Hi everyone,

    I am currently working on one of my first automations. I have used this very good knowledge base article to create a Loop and reduce automation 

    https://community.qlik.com/t5/Official-Support-Articles/How-to-Loop-and-reduce-with-Qlik-Application-Automation-advanced/ta-p/1834378 

    I have a working solution. The field I use to loop over has more values than I want to use to create apps from.
    To filter them I use a condition. I wanted to list all the values in one condition. For this I tried to separate them by comma or semicolon, but this doesn't work. I also tried to compare with list contains or contains.

    Does anyone have a working solution on how to compare to a list of values?

    Benno_0-1714739817603.png

    Thanks a lot for your help!

     

    Show Less
  • forum

    App Development

    Tempo na automação

    Tenho um fluxo de automação, onde chamo alguns relatórios para um trigger atualizar e disparar alguns e-mails. Como coloco um timer entre um dash com ... Show More

    Tenho um fluxo de automação, onde chamo alguns relatórios para um trigger atualizar e disparar alguns e-mails. Como coloco um timer entre um dash com o outro? Deu Start no aplicativo 1, aguarde 10 minutos e inicie o 2 assim por diante e caso de erro rode de novo.

    Show Less
  • forum

    App Development

    Bullet chart: Alternate measure has greyed out segment option

    Hi everyone When using the bullet chart and adding a second measure as alternativ the segment option is greyed out and the expression for the colours ... Show More

    Hi everyone

    When using the bullet chart and adding a second measure as alternativ the segment option is greyed out and the expression for the colours to use also is not applied.

    Is this a bug?

    Show Less
  • forum

    Catalog and Lineage

    NPrint reports

    Hi! Has anyone had any issues creating a NPrint report and all the dashboard inserted on the template come out looking too wide or on 2 pages? I’ve pl... Show More

    Hi! Has anyone had any issues creating a NPrint report and all the dashboard inserted on the template come out looking too wide or on 2 pages? I’ve played with resolution settings, but no luck. Any guidance would be helpful! ty

    Show Less
  • forum

    App Development

    Why it is not possible to use drill down dimension in Variable Input Control

    Hi everyone Why is it not possible to use a drill down dimension in a Variable Input Control with which one could choose the desired dimension and the... Show More

    Hi everyone

    Why is it not possible to use a drill down dimension in a Variable Input Control with which one could choose the desired dimension and the change in dimension then automatically is overtaken to all diagramms in focus?

    Variable input control | Qlik Sense on Windows Help

    Thanks

    Show Less
  • forum

    New to Qlik Analytics

    Converting Date to MonthYear

    Hi, I have a date and time field. I want to convert the field to MonthYear and use it in a line chart. I used the expression below but the line chart ... Show More

    Hi,

    I have a date and time field. I want to convert the field to MonthYear and use it in a line chart. I used the expression below but the line chart is not showing the monthyear as expected. Can anyone help please. Thank you. 

    LOAD
    "Submission Date",
    date(MonthStart(date#([Submission Date], 'DD/MM/YYYY hh:mm')), 'MMM-YYYY') as MonthYearEX,

    Submission Date customer Amount Expected
    30/01/2022 14:10 John Doe 23 Jan-22
    01/08/2023 16:15 John Doe 56 Aug-23
    02/07/2021 08:31 John Doe 42 Jul-21
    02/03/2024 10:34 John Doe 87 Mar-24
    02/06/2024 16:19 John Doe 26 Jun-24

    Bob07_0-1715599570937.png

     

    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!