Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 221,465 members
  • 5,956 online
  • 2,001,662 posts
  • 150,088 Solutions
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT

Welcome to Qlik Community

Recent Discussions

  • forum

    Design and Development

    tXMLMap with multiple lookups multiplies all loops. Is there any way to get dist...

    Hello,  I'm kind of struggling because of the the rest endpoint of one of our provider. It requires multiple loops per item/entity I have to send to t... Show More

    Hello, 

    I'm kind of struggling because of the the rest endpoint of one of our provider.

    It requires multiple loops per item/entity I have to send to them (I've made this with tXMLMap in order to fill each document) :

    HenriYan_1-1717154657883.png

    I had to make something that looks like a hack to me with the tJavaFlow, to force each result to generate only one document at a time (with the all in one set to "true" in order to get all the loop in one document for each entity)

    HenriYan_0-1717154629807.png

    I don't know if i'm doing it the right way, but that's the only way I found to make it ALMOST work...

    The issue i'm still facing, is that the multiples lookups multiply each other results numbers.

    Here's a result test : 

    HenriYan_2-1717155108067.png

    It should looks like : 

    [...] cdc_offer_photos: [
    [Object], [Object]
    ]
    },
    cdc_service: [
    158, 159, 162, 163, 166
    ],
    cdc_region: [
    '28-normandie'
    ],
    cdc_department: [
    '27-eure'
    ]
    }

     

    Once again, I'm not sure that I'm doing it the right way, and I can't believe that there's not a more elegant/simple way to achieve what I want..

    I'm spending so much time on this, I'm really close to drop Talend and rebuild all of this way more easily with a nodejs script....

    So I'll take with a great pleasure all your advices, thanks in advance !

    Show Less
  • forum

    Installing and Upgrading

    Help for products and prices

    I need help because I am make me crazy... We need to develop an ETL processes or data integration from file or database type sources. By de moment, so... Show More

    I need help because I am make me crazy...


    We need to develop an ETL processes or data integration from file or database type sources. By de moment, something simple, on a private confidential network without internet access.
    I have tried Talend Open Studio (v8.0.1) and Talend Studio would be perfect, but we and especially our client want to be support and possible updates so that the developed product not being deprecated.
    I wanted to know the currently product with support that best fits by simplicity of functionality, price... and of course, know the pricing of the license. Iam asking for it because I do know if search in Talend o Qlik web and do not understand the products, it is not clear, it is a roll. I wrote to Talend support and no clear response. I spent few days search for info, and I can not spent much more time to get info about products. If I do not get something clear, I will estudy other tools...
    Thank you so much.
    Regards

    Show Less
  • forum

    New to Qlik Analytics

    Script Placement

    How is a placement like 1.1 or 1.1.1 done on the qlik sense script side?
  • forum

    Qlik Application Automation

    Getting: Error calling endpoint "Qlik Cloud Services - Start Reload" when reload...

    Hi I am trying to make an automation which will reload a number of apps. Started with the template for reloading multiple apps in parallel, and copied... Show More

    Hi

    I am trying to make an automation which will reload a number of apps.

    Started with the template for reloading multiple apps in parallel, and copied the "reload app" block a couple of times, I started getting this error: 

    Martin_B_0-1717498996987.png

    When I cut the number of concurrent reloads down to 4, it works. 

    Anybody have an idea, how to increase the number of concurrent requests?

     

    I am working on a enterprise qlick cloud installation.

    Thanks 

       

    Show Less
  • forum

    App Development

    When you select Checkbox mode in filter object. you dont get selection color sta...

    Hi All,   Maybe this is qlik sense limitation. but in qliksense cloud, when you customize Filter Object to show all values as CheckBox using Checkbox ... Show More

    Hi All,

      Maybe this is qlik sense limitation. but in qliksense cloud, when you customize Filter Object to show all values as CheckBox using Checkbox mode. you loose ability to Selection State Colors.

    when using Checkbox mode:

    vighnesh2022_1-1717498974224.png

    When using normal mode:

    vighnesh2022_2-1717499011250.png

     

    does anyone know how to correct this behaviour?

     

    #Qlikcloud #Qliksense

     

    Show Less
  • forum

    Qlik NPrinting

    Variable misbehaved once

    I have an NPrinting report that runs every Sunday morning. It's been working perfectly for a few months - until yesterday. The report name includes a ... Show More

    I have an NPrinting report that runs every Sunday morning. It's been working perfectly for a few months - until yesterday. The report name includes a variable from Sense that evaluates this: 

    =date(WeekStart(Today()), 'YYYY.MM.DD')

    The report setup:

    Lauri_0-1717429591087.png

     

    Every week, the report has gotten the correct name. Yesterday, the report ran as usual BUT the file name contained 2024.05.26 instead of 2024.06.02 (yesterday's date). 

    Any ideas why?

    I could change the variable to =date(Today(), 'YYYY.MM.DD') but it's not ideal because sometimes the report needs to run on other days.

    Show Less
  • forum

    App Development

    Compare Sales of Current Year with Sales of Previous Year

    Hi all, it's driving me crazy and I found dozens of posts that all bring up the same solution that won't work for me. I'm trying to compare the Sales ... Show More

    Hi all,

    it's driving me crazy and I found dozens of posts that all bring up the same solution that won't work for me.

    I'm trying to compare the Sales with the Previous Year's Sales. Does anyone know why I don't get the correct numbers?

    holymosfet_0-1716990403167.png

    Any help is much appreciated.

    Show Less
  • forum

    Deployment & Management

    Qliksense Hub not loading - Began after update to February 2023 Instance

    15 users and 2 developers have reported that they receive the below loading screen indefinitely as they attempt to enter the Qliksense Hub.  Our admin... Show More

    15 users and 2 developers have reported that they receive the below loading screen indefinitely as they attempt to enter the Qliksense Hub.  Our administrators have advised us do the following:

    • remove everything in the URL after "....com/hub/"
    • Clear browser cache
    • Open the link in an incognito window

    All of these solutions work intermittently. Sometimes by switching internet browsers, from Chrome to Edge for example, one can fix the issue. But then it will reappear the following day where it worked the day before. 

    I wonder if it is an issue with our authentication -- which I know uses a VPN with SSO for users to enter. We started having this problem after we updated to the February 2023 Instance from the May 2021 Instance. 

    Has anyone else experienced this issue? Any advice you can offer besides those already mentioned?

    QLik Error.png

    Show Less
  • forum

    Qlik Replicate

    Error while loading XML data from DB2 z/OS to Postgres(AWS)

    Hi Team,  we were facing issues while loading the XML table from Db2 z/OS to RDS Postgres using Attunity (Qlik Replicate). The tables have around 2Mil... Show More

    Hi Team, 

    we were facing issues while loading the XML table from Db2 z/OS to RDS Postgres using Attunity (Qlik Replicate). The tables have around 2Million rows, and the max record length is of 47MB.  We are receiving below error when we try the load: 

    RetCode: SQL_ERROR  SqlState: 40003 NativeError: 
    -1224 Message: [IBM][CLI Driver] SQL1224N  
    The database manager is not able to accept new requests,
    has terminated all requests in progress, 
    or has terminated the specified request because of an error or a forced interrupt.  SQLSTATE=55032

     

    => We tried to break the data into chunks like in 20 different tables each table has around 13k rows. but still we are receiving the same error and we tried to option in the tool like "ALLOW UNLIMITED LOB" and "Limit LOB size to (KB) to 50MB" and breaking still further will be tedious task what if the table has millions of data more? We wanted to understand where the actual issue is? and is there any other option we need to consider for loading XML/LOB data .Kindly review above issue and let us know if further info is required from my end.

     

    Some more info :

    Datatype  : XML 

    Source : DB2 zOS V12 and Target : Postgres RDS 

     

    Show Less
  • forum

    Qlik NPrinting

    License question

    Greetings , we are still using Nprinting 16.9 and would like to know if we can still get a license if it ended ? Kindest Regards,
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

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!