Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 272,700 members
  • 4,677 online
  • 2,046,007 posts
  • 154,711 Solutions
Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!

Welcome to Qlik Community

Recent Discussions

  • forum

    Integration, Extension & APIs

    Qlik Sense load script trigger NPrinting task through API, intermittently gettin...

    We have an app that runs in Qlik Sense to trigger NPrinting task, which is chained to a main app, meaning once the main app runs finish, this NPrintin... Show More

    We have an app that runs in Qlik Sense to trigger NPrinting task, which is chained to a main app, meaning once the main app runs finish, this NPrinting trigger API task will then run to trigger the NPrinting tasks. We have been experiencing frequent failures of the NPrinting Trigger Tasks recently. This works well most of the time but once it fails, the NPrinting task has to be recreated.  

    -Retrieved 0 rows when retrieving task_name from NPrinting tasks

    Recreating the task in NPrinting resolved the problem. However, the same issue has continued to occur intermittently on other tasks, and this workaround is not a sustainable solution for us.

     

    QS Script as below:

    vURL is being maintained in excel.

     

    LIB CONNECT TO 'NPrinting Rest Login (GET)';
    
    RestConnectorMasterTable:
    SQL SELECT
    "Set-Cookie",
    "__KEY__response_header"
    FROM JSON "_response_header" PK "__KEY__response_header";
    
    Let vCookieRaw = Peek('Set-Cookie',0,'cookie_items');
    Let vCookie = TextBetween(
    vCookieRaw,
    'SameSite=None,',
    ' Path=/',
    SubStringCount(vCookieRaw,'SameSite=None')-1
    );
    
    
    LIB CONNECT TO 'NPrinting Rest Login (GET)';
    
    RestNPTasksMasterTable:
    SQL SELECT
    "__KEY_data",
    (SELECT
    "id",
    "name",
    "enabled",
    "__FK_items"
    FROM "items" FK "__FK_items")
    FROM JSON (wrap off) "data" PK "__KEY_data"
    WITH CONNECTION(
    URL "$(vURL_1)",
    HTTPHEADER "cookie" "$(vCookie)"
    );
    TRACE **$(vURL_1) **;
    
    
    
    [task_items]:
    LOAD
    [id] AS [tasks_taskId],
    [name] AS [tasks_taskName]
    RESIDENT RestNPTasksMasterTable
    WHERE NOT IsNull([__FK_items])
    //AND [enabled] = 'True'
    AND [name] = 'Sales Report - 01';
    
    LET vTaskCount = NoOfRows('task_items');
    
    IF $(vTaskCount) = 0 THEN
    TRACE *** ERROR: NPrinting task not found! ***;
    EXIT SCRIPT 1;
    ENDIF;
    
    DROP TABLE RestNPTasksMasterTable;
    
    
    
    LET vNumberTasks = NoOfRows('task_items');
    
    FOR i = 0 TO vNumberTasks - 1
    
    LET vTaskId = Peek('tasks_taskId', i, 'task_items');
    LET vTaskName = Peek('tasks_taskName', i, 'task_items');
    
    TRACE Triggering NPrinting Task: $(vTaskName);
    
    LET vPublishURL =
    '$(vURL_1)' &
    '$(vTaskId)' &
    '/executions';
    
    // REST Connection (POST)
    LIB CONNECT TO 'NPrinting Rest Connection (POST)';
    
    RestNPTaskTriggerTable:
    SQL SELECT "__KEY_data"
    FROM JSON (wrap off) "data" PK "__KEY_data"
    WITH CONNECTION(
    URL "$(vPublishURL)",
    HTTPHEADER "cookie" "$(vCookie)"
    );
    
    DROP TABLE RestNPTaskTriggerTable;
    
    NEXT
    
    Drop Table [task_items];
    
    
    
    Sleep(180000);
    
    LIB CONNECT TO 'NPrinting Rest Login (GET)';
    
    RestConnectorMasterTable:
    SQL SELECT
    "Set-Cookie",
    "__KEY__response_header"
    FROM JSON "_response_header" PK "__KEY__response_header";
    
    Let vCookieRaw = Peek('Set-Cookie',0,'cookie_items');
    Let vCookie = TextBetween(
    vCookieRaw,
    'SameSite=None,',
    ' Path=/',
    SubStringCount(vCookieRaw,'SameSite=None')-1
    );
    
    
    LIB CONNECT TO 'NPrinting Rest Login (GET)';
    
    RestNPTasksMasterTable:
    SQL SELECT
    "__KEY_data",
    (SELECT
    "id",
    "name",
    "enabled",
    "__FK_items"
    FROM "items" FK "__FK_items")
    FROM JSON (wrap off) "data" PK "__KEY_data"
    WITH CONNECTION(
    URL "$(vURL_1)",
    HTTPHEADER "cookie" "$(vCookie)"
    );
    TRACE **$(vURL_1) **;
    
    
    
    [task_items]:
    LOAD
    [id] AS [tasks_taskId],
    [name] AS [tasks_taskName]
    RESIDENT RestNPTasksMasterTable
    WHERE NOT IsNull([__FK_items])
    //AND [enabled] = 'True'
    AND [name] = 'Sales Report - 02';
    
    LET vTaskCount = NoOfRows('task_items');
    
    IF $(vTaskCount) = 0 THEN
    TRACE *** ERROR: NPrinting task not found! ***;
    EXIT SCRIPT 1;
    ENDIF;
    
    DROP TABLE RestNPTasksMasterTable;
    
    
    
    LET vNumberTasks = NoOfRows('task_items');
    
    FOR i = 0 TO vNumberTasks - 1
    
    LET vTaskId = Peek('tasks_taskId', i, 'task_items');
    LET vTaskName = Peek('tasks_taskName', i, 'task_items');
    
    TRACE Triggering NPrinting Task: $(vTaskName);
    
    LET vPublishURL =
    '$(vURL_1)' &
    '$(vTaskId)' &
    '/executions';
    
    // REST Connection (POST)
    LIB CONNECT TO 'NPrinting Rest Connection (POST)';
    
    RestNPTaskTriggerTable:
    SQL SELECT "__KEY_data"
    FROM JSON (wrap off) "data" PK "__KEY_data"
    WITH CONNECTION(
    URL "$(vPublishURL)",
    HTTPHEADER "cookie" "$(vCookie)"
    );
    
    DROP TABLE RestNPTaskTriggerTable;
    
    NEXT

     

    Seeking advise from API experts. 

     

    Best Regards,

    Nelson

    Show Less
  • forum

    Qlik Connect Lounge

    Issue with the unveiled capabilities link

    Posting this here because it's Connect-adjacent. Looks like the link in the top bar is set to point at a non-public page: 
  • forum

    Visualization and Usability

    Muliple KPI's on a sheet, but "buttons" ?

    Hi. We were given a mockup of an app for CSO and CEO-level users.  It needs to be direct and simple, and not look like a spreadsheet.  Hence the "butt... Show More

    Hi. 

    We were given a mockup of an app for CSO and CEO-level users.  It needs to be direct and simple, and not look like a spreadsheet.  Hence the "button" look as proposed.   Maybe not possible, but perhaps we can get close or similar.

    The catch here is that there are many KPI's on the sheet, and our first attempt takes 30+ seconds to load.
    Beyond that, I'm not sure we can format the sheet close to the way they requested.  The key element here is that we want KPI $ and KPI % on the same block/button.  Qlik KPI is close, but it makes the second KPI look like superscript.  (See images)

    Take a look at the attached images and give me your ideas, if you have any.  In the images, you can see the mockup, and where we currently are.  I am not a Qlik pro, but we have some (limited) access to one.

    Any suggestions are appreciated!
    Thanks
    Rob

     

    Mockup (goal):

    Mockup_KPI_masked.jpg

    Qlik:QlikTry1_masked.jpg

     

     

     

     

     

     

     

     

     

     

     

     

    QlikTry1a_masked.jpg

     

     

     

    Show Less
  • forum

    Qlik Automate

    Automating creation of space links (generic links) via Qlik Automate / API

    Hi all,I’m trying to automate the creation of “generic links” inside a Qlik Cloud space.Use case:I have an on-prem Qlik Sense appAt the end of the rel... Show More

    Hi all,

    I’m trying to automate the creation of “generic links” inside a Qlik Cloud space.

    Use case:

    • I have an on-prem Qlik Sense app

    • At the end of the reload script, I trigger a REST call

    • This call invokes a Qlik Automate automation (webhook trigger)

    • The payload contains:

      • link name

      • link URL

      • target space

    Goal:
    Automatically create a link in a Qlik Cloud space pointing to external resources (e.g. dashboards, apps, tools).

    What I found so far:

    • Automations can be triggered via webhook ✔️

    • But I couldn’t find any API or block to create “links” in a space

    Questions:

    1. Is there any supported API to create these links programmatically?

    2. Is this feature planned or intentionally UI-only?

    3. Are there recommended alternatives for this use case?

    Thanks!

     

    Show Less
  • forum

    Management & Governance

    Updating section access with partial reload does not overwrite old section acces...

    Dear all, we try to update our section access, when doing a partial reload. Attached is the code of the sample application, we use. If we run the code... Show More

    Dear all,

    we try to update our section access, when doing a partial reload. Attached is the code of the sample application, we use. If we run the code as full reload, everything works as expected. The user FISCHERD has access to the number 3 only.

    If we run the same script as partial reload, the user FISCHERD has access to the numbers 3 AND 5 instead of 5 only.

     

    Does anybody have an idea, where this is coming from and how to overcome this problem?

     

    Thank you very much for your support.

     

    Best regards

     

    Dirk

     

    ZAHLEN:
    Replace Load * inline [ ZAHL, WORT, REDUCTION
    1,  EINS, 1
    2,  ZWEI, 2
    3,  DREI, 3
    4,  VIER, 4
    5,  FUENF,5
    6,  SECHS, 6
    7,  SIEBEN, 7
    8,  ACHT, 8
    9,  NEUN,9
    10, ZEHN,10
    11, ELF,11
    12, ZWOELF,12
    13, DREIZEHN,13
    14, VIERZEHN,14
    15, FUENFZEHN,15
    16, SECHSZEHN,16
    17, SIEBZEHN, 17
    ];
     
    /*
    Call createBaseUserTable;
    call DropTable('TEMP_ACCESS_TABLE');
    Rename Table 'BASE_USER_TABLE' to 'TEMP_ACCESS_TABLE';
    Exit Script;
    Left Join(TEMP_ACCESS_TABLE)*/
    If IsPartialReload() Then
    TEMP_ACCESS_TABLE:
    Replace NoConcatenate Load * Inline [ACCESS, USERID   ,REDUCTION
    USER, ACCOUNTS\FISCHERD, 5
    ADMIN, ACCOUNTS\SCHMIDRU,3
        ADMIN, ACCOUNTS\SCHMIDRU,5
    ADMIN, INTERNAL\SA_SCHEDULER,
    ADMIN, INTERNAL\SA_API, 
    ];
    Else
    TEMP_ACCESS_TABLE:
    Replace Load * Inline [ACCESS, USERID   ,REDUCTION
    USER, ACCOUNTS\FISCHERD, 3
    ADMIN, ACCOUNTS\SCHMIDRU,3
        ADMIN, ACCOUNTS\SCHMIDRU,5
    ADMIN, INTERNAL\SA_SCHEDULER,
    ADMIN, INTERNAL\SA_REPOSITORY, 
    ADMIN, INTERNAL\SA_API, 
    ];
    End If
     
    Section Access;
    ACCESS_TABLE:
        NoConcatenate
        REPLACE LOAD * Resident TEMP_ACCESS_TABLE;
    Section Application;
    DropTable TEMP_ACCESS_TABLE;

     

    Show Less
  • forum

    Data Movement & Streaming

    Recargas distintas en función del espacio

    Hola,Tengo una app en Qlik Sense Saas que tiene que cargar distinta información en función del espacio en que se encuentre. No quiero crear distintas ... Show More

    Hola,

    Tengo una app en Qlik Sense Saas que tiene que cargar distinta información en función del espacio en que se encuentre. No quiero crear distintas apps (una por espacio) ya que el mantenimiento sería más costoso. 

    ¿Existe alguna manera (con automatizaciones o similar) para con una única app poder cargar información distinta dependiendo del espacio en que se encuentre? Se me ocurre con una variable o que pueda leer de un fichero de configuración en el espacio actual, pero no consigo hacerlo.

    Gracias

    Show Less
  • forum

    Women Who Qlik

    Welcome Women Who Qlik!

    Welcome to all new members and hello to our OGs!  We’re happy to have you here and excited for you to be part of this growing, global community.   Wom... Show More

    Welcome to all new members and hello to our OGs! 

    We’re happy to have you here and excited for you to be part of this growing, global community.  

    Women Who Qlik exists to connect, support, and empower women and allies across the Qlik ecosystem through shared experiences, learning opportunities, career growth, and access to expertise and resources. Our mission is to create an inclusive space where women can learn from one another, amplify their voices, and grow their careers while deepening their impact with Qlik. 

    The Women Who Qlik Community Group is the place to access all the exciting events and content around the Women Who Qlik program. 

    Throughout the year, you can look forward to:  

    • Quarterly engaging virtual events (LinkedIn Live streams, networking, speaker sessions) 
    • In-person event experiences at Qlik Connect  
    • Career development and Qlik product resources  
    • Opportunities to learn, share, and connect with peers across industries and roles 

     All members will receive the Women Who Qlik badge to share on your social shortly, as well as one to share on Community.  We will send you your social Credly badge via email.  If you have any objections, please let us know!

    How to get started: 

    1. Introduce yourself! 

             Reply to this post and tell us: 

    • Who you are 
    • What you do 
    • What you hope to learn or share here 
    1. Take our short survey 

             This helps us shape future events, speakers, and topics around you. 

    1. Subscribe to the group 

             Subscribe so you don’t miss event invites, discussions, and announcements. 

    1.  Leadership & Mentorship: A Women Who Qlik Conversation with Sadie St Lawrence 

    Join us for an exclusive conversation on mentorship and leadership with Sadie St. Lawrence, tech influencer and founder of Women in Data and founder/CEO of the Human Machine Collaboration Institute. On March 26 at 10am EST/4pmCET get ready to share your thoughts and experiences in a discussion with Women Who Qlik leaders right here in the Women Who Qlik Community! 

    I’m excited to get to know you all throughout the year! 

    Warm regards,  

    Sarah  

    Show Less
  • forum

    Integration, Extension & APIs

    if we can sync AZURE AD groups into Qlik sense and provide group section access

    I want to check if we can sync AZURE AD groups into Qlik sense and using those groups can we implement section access? Has anyone implemented section ... Show More

    I want to check if we can sync AZURE AD groups into Qlik sense and using those groups can we implement section access? Has anyone implemented section access using this way?

    Show Less
  • forum

    Qlik Replicate

    Intermittent Special Characters ("NANA") for Blank CHAR(2) Field from DB2 z/OS

    Hi Team,We are encountering an issue while replicating data from DB2 z/OS to the target using Qlik Replicate.In the source DB2 z/OS table, a column wi... Show More

    Hi Team,

    We are encountering an issue while replicating data from DB2 z/OS to the target using Qlik Replicate.

    In the source DB2 z/OS table, a column with data type CHAR(2) contains blank values (spaces) for several records. However, in the target system, we are observing inconsistent behavior:

    • Most records are correctly replicated as blanks
    • But for a few records, the same field is populated with unexpected special characters like "NANA"

    So, not all blank fields are impacted—only a subset of records shows this issue.

    Thanks in Advance

    Show Less
  • forum

    Visualization and Usability

    Fields from single table not syncing correctly

    Hey all, I have a table that is stored in a qvd file. The setup is as follows: [UpdatedClients]: LOAD [ClientID], [ClientName], [CorporateID], [Co... Show More

    Hey all,

    I have a table that is stored in a qvd file. The setup is as follows:

    [UpdatedClients]:
    LOAD
    [ClientID],
    [ClientName],
    [CorporateID],
    [CorporateName],
    [BusinessClassID],
    [BusinessClass]
     FROM [lib://Operations:DataFiles/UpdatedClients.qvd](qvd);
     
    Upon using this table, with several others associated by ClientID, i created filter panes for ClientID and ClientName as some people use the ID while others use the name. However, when ClientName is selected all data goes blank, and the corresponding ClientID filter pane doesn't reference any ClientID correlated to the client name. Using the ClientID filter pane, everything works as expected with the exception of correlating to the client name filter pane. This is very confusing as they are fields on the same table, and all ClientIDs have a corresponding ClientName. Anyone have any thoughts on why this may be happening? Thanks.
    Show Less
Leaderboard

Qlik community MVPs

Qlik Community MVPs — trusted experts driving collaboration, learning, and innovation.

mvp-banner-side-image

Customer Story

Data Drives the Reconstruction of an Entire State

Data Restores Confidence: How SEFAZ-RS Used Qlik to Support the Rebuilding of a State.

Customer Story

Qlik platform helps structure an analytics ecosystem to support diagnostic medicine and healthcare.

AFIP revolutionizes management, optimizes resource allocation and strengthens data-driven culture

Customer Story

Hapag-Lloyd Enables Smart Decisions With Qlik

Global container shipping giant delivers data transparency to enable confident decision-making and operational efficiency.

Customer Story

Students See Data Come to Life With Qlik Academic Program

Qlik turns raw data into valuable learning experiences, empowering both students and faculty at TTUHSC.

Customer Story

MillerKnoll Unifies Data with Qlik Talend

MillerKnoll partnered with Qlik Talend® data solutions to unify data across its diverse systems, accelerating critical processes and nearly eliminating data integration issues organization-wide.

Customer Story

Radiall Embraces the Cloud and Improves Operational Efficiency

Migration to Qlik Cloud Analytics optimizes analytics applications within months.

Customer Story

French Ministry of Armed Forces Develops a Data-Centric Culture

With Qlik Cloud Analytics, Rexel boosts performance by enabling self-service analysis, reducing prep time, and giving 3,000 users access to trusted insights.

Your Place, Your People

Choose a Group

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

Collaborate

Qlik en México

Qlik en México

Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.

All are welcome

Hello from Japan

Japan

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

Request to join

Parlons Données

Parlons Données

Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.

open to all

Did you know...

Qlik Connect 2026: Be Bold. Be Different. Be Here.

Join us April 13–15, 2026 in Kissimmee, Florida for 2+ immersive days of innovation, hands-on learning, and powerful connections shaping the future of data and AI.

Did you know...

Qlik Free Trials

You can test-drive Qlik for free? Try Qlik Talend Cloud to integrate and clean data without code, or explore Qlik Cloud Analytics to create AI-powered visualizations and uncover insights hands-on.

Did you know...

Mastering Change Data Capture

You can move beyond batch processing and harness real-time data to power AI and faster decisions? Discover how in our new eBook, Mastering Change Data Capture.