Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 225,419 members
  • 4,094 online
  • 2,007,232 posts
  • 150,584 Solutions
Announcements
NEW Customer Portal: Initial launch will improve how you submit Support Cases. FIND OUT MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    Pulling data from Postgresql DB - Question about performance

    Hi, We work with Postgresql DB to retrieve data into Qlik Sense.We identified (in the attached example - retrieving 4 million records) that the query ... Show More

    Hi,

    We work with Postgresql DB to retrieve data into Qlik Sense.
    We identified (in the attached example - retrieving 4 million records) that the query at the SQL level ends in around 40 seconds, while another process takes 4 minutes.

    20240717T110810.305+0300 0024 LIB CONNECT TO 'PostgreSQL_localhost'
    20240717T110811.328+0300 Connected.
    20240717T110811.330+0300 0028 SQL SELECT *
    20240717T110811.330+0300 0029 FROM table1
    20240717T110811.330+0300 0030 WHERE "timestamp" > '2024-06-27 20:04:08'
    20240717T110855.187+0300 43 fields found: field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12, field13, field14, field15, field16, field17, field18, field19, field20, field21, field22, field23, field24, field25, field26, field27, field28, field29, field30, field31, field32, field33, field34, field35, field36, field37, field38, field39, field40, field41, field42, timestamp
    20240717T111256.239+0300 4,002,000 lines fetched
    20240717T111257.239+0300 Execution finished.


    Is it possible to get an explanation of what exactly happens after the query ends on Qlik side?

    What exactly is done in the fetching phase that takes 4 minutes?

    Is it possible to debug the matter using logs?

    Thanks,

    Eli.

    Show Less
  • forum

    Connectivity & Data Prep

    How to access an OneDrive folder shared with me by someone else

    Hi all, I created a OneDrive data connection and was able to pull data from any folders/files under OneDrive "My files" except for one folder shared w... Show More

    Hi all,

    I created a OneDrive data connection and was able to pull data from any folders/files under OneDrive "My files" except for one folder shared with me by someone else. I wonder if there's a way to pull data from there?

    Thank you in advance!

    Show Less
  • forum

    Qlik Application Automation

    ODAG - how to make bindings optional

    Hello! Does anyone by chance know how to make it so my bindings do not all have to be selected? Right now the on demand app is only generated correctl... Show More

    Hello!

    Does anyone by chance know how to make it so my bindings do not all have to be selected?

    Right now the on demand app is only generated correctly if all 3 “filters” have a selection in them.  If I only use 1 or 2 of them, it still turns green and meets the criteria but fails.

    So far can only get to work if all of them have something selected.

    Let vPostMonth = $(od_POSTING_EOM);

    Let vBranchName = $(od_ACCOUNT_ASSIGNED_BRANCH_COST_CENTER_NM);

    Let vRegion = $(od_RETAIL_REGION_CD);

     

    I have tried odo and odso  but it doesn’t like those.  Also odag didn't work for me.

    micklesj_0-1721236561056.png

     

     

    micklesj_1-1721236572338.png

    micklesj_2-1721236593336.png

     

    I think it’s trying to put a blank in the variable and then bombs down at the bottom in the where clause.  Is there a way around that?  I would like them to be able to select as many as they want or none at all.

    It does work if a branch is selected.

     

    micklesj_3-1721236613130.png

    Thank you!

     

    Show Less
  • forum

    Qlik NPrinting

    Using a link URL in an nPrinting Report

    In Qlik, I created a link url using a dimension. I then created an excel nPrinting report, where the intent was to have anyone accessing the report be... Show More

    In Qlik, I created a link url using a dimension.

    I then created an excel nPrinting report, where the intent was to have anyone accessing the report be able to utilize the link.

    The link works as intended in the qlik object, but on the excel report, the link is to a c: /downloads path and does not take the user to the intended site.

    I am working with nPrinting May 2023 SR1.

    Any solutions that can be offered would be much appreciated.

     

    Thank you for your time.

    Show Less
  • forum

    Qlik Reporting Service

    Tabular Reporting - On-demand - now available

    Since releasing Qlik Cloud Tabular Reporting in late 2023 a common Qlik Community question has been - what about On-demand reporting?  The wait is ove... Show More

    Since releasing Qlik Cloud Tabular Reporting in late 2023 a common Qlik Community question has been - what about On-demand reporting? 

    The wait is over - integrated into the native navigation flow, report developers can now make report templates available for users in app.  See:

    Now users can use their own selections to immediately download a tabular report that has been made available in app.   

    Show Less
  • forum

    Integration, Extension & APIs

    GET /v1/apps/{appId}/data/lineage not working well when using precedent loads

    Hi.I'm working on an app to navigate the lineage data from our apps.Everything went well until I've noticed the lineage is blank when precedent load i... Show More

    Hi.

    I'm working on an app to navigate the lineage data from our apps.
    Everything went well until I've noticed the lineage is blank when precedent load is used.

    Example:
    Load field1 From [lib://SomeDataSpace:SomeDataConn/SomeTable.qvd (qvd);

    The API request for that app will return:
    [
    {
    "discriminator": "lib://SomeDataSpace:SomeDataConn/SomeTable.qvd;",
    "statement": ""
    }
    ]

    If you add a precedent load:
    Load *, 1 as counter;
    Load field1 From [lib://SomeDataSpace:SomeDataConn/SomeTable.qvd (qvd);

    The new request will return 
    [
    {
    "discriminator": "",
    "statement": ""
    }
    ]

    This happens in Saas and in QSEoW (tested on Nov/23 and Feb/24). On QSEoW you can test this on the Qlik Engine Explorer, calling the GetLineage doc method.

    Show Less
  • forum

    New to Qlik Analytics

    Changing the colors of a stacked bar diagram

    Hello community,  I am trying to change the colors of these stacked bar diagrams, but I simply can't figure out how. When I open "Color and Legends," ... Show More

    Hello community, 

    I am trying to change the colors of these stacked bar diagrams, but I simply can't figure out how. When I open "Color and Legends," I cannot change the colors. Since these are not categories in one dimension but rather three different measures together, I can't do it in the Master-Element menu. Does anybody know how to do this?

    I also have a combined Line/Bar chart that i cant change the color.

    Thanks!

     

    Show Less
  • forum

    QlikView App Dev

    Performance degradation after upgrading from QV11 to QV12

    Hello. We had Qlikview server 11 and we have upgraded to release 12.8 on a different server. A reload of a document that extracts 8 Million records  f... Show More

    Hello.

    We had Qlikview server 11 and we have upgraded to release 12.8 on a different server.

    A reload of a document that extracts 8 Million records  from database, in release 11 took 3 minutes.

    After upgrading to 12 release, the same reload takes 20 minutes.

    Memory and CPU are the same on both servers .

    what can be the problem?

    is there a special setting that I need to set?

     

     

     

     

    Show Less
  • forum

    Component Development

    Developing Custom component using TCOMP and the documentation simply doesn't wor...

    I tested with older version, now it's 1.64.5 and still the problem persists : - IntelliJ plugin : impossible to click the "NEXT" button" (java.lang.Nu... Show More

    I tested with older version, now it's 1.64.5 and still the problem persists :

    - IntelliJ plugin : impossible to click the "NEXT" button" (java.lang.NullPointerException: Cannot invoke "org.talend.sdk.component.intellij.module.step.StarterStep$StarterPanel.getPanelLoaded()" because "this.starterPanel" is null). You will need to go through the starer kit on the website (it works now)

    - For a very simple Processor, impossible to display the incoming schema in the Studio, at design time, in a tableau in order to configure the order of field for example, or add any configuration on a field level. you can have single field, String, Number, etc, 

    This below doesn't show in the UI :

    @Option
    @Documentation("Incoming metadata.")
    @Structure(type = Structure.Type.IN)
    private List<SchemaInfo> incomingSchema;

    I'll wait for the version 1.65...

    Show Less
  • forum

    App Development

    Dynamic Set Analysis

    Hello everyone, Count({$<Date={'09/30/2019','09/30/2020','09/30/2021','09/30/2022','09/30/2023',"$(=Date(Date#(Today(),'M/DD/YYYY'),'MM/DD/YYYY'))"}>}... Show More

    Hello everyone,

    Count({$<Date={'09/30/2019','09/30/2020','09/30/2021','09/30/2022','09/30/2023',"$(=Date(Date#(Today(),'M/DD/YYYY'),'MM/DD/YYYY'))"}>}distinct Sales)

    I wrote this set analysis to resolve [show sale for past 5 years + running current year]

    Is it possible to make past years dynamic as well so that on 30 Sept 2024 09/30/2023 -> becomes 09/30/2024 and other previous year respectively? Or should I put current year on another sheet?

    FYI: My DIMENSION IS A "YEAR" FIELD.

    If you have an idea please help. 

    Thank you

    Show Less
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!