Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 230,910 members
  • 5,540 online
  • 2,013,508 posts
  • 151,148 Solutions
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.

Welcome to Qlik Community

Recent Discussions

  • forum

    New! Qlik Answers

    QlikView Uograde from MAY 2022 patch to Qlikview May 2024

    Hi Folks, Did any one faced major challenges while upgrading from QlikView May 2022 patch2 to QLIKVIEW MAY 2024.   Kind Regards, Raju
  • forum

    Qlik Application Automation

    Problem with selections

    Hello everyone,I have a group of scenarios that correspond to different sections of a highway as can be seen in the following table: I have an expres... Show More

    Hello everyone,
    I have a group of scenarios that correspond to different sections of a highway as can be seen in the following table:

    alexdelagarza_1-1725981194433.png

    I have an expression that should return the records that are at the intersection of scenarios 204 and 208, but it returns records from other scenarios as well, such as 104, 107, 108, etc., as can be seen in the following table:

    alexdelagarza_3-1725981372989.png

    This is the expression:

    =count( {$<ID_CARD= P({<Escenario2={'208'}>})*P({<Escenario2={'204'}>})>} ID_CARD )

    If I use the filters and select only the scenarios I want, I get the result I expect:

    alexdelagarza_4-1725981514526.png

    But, I need you to give it to me without using the filters.


    I hope you can help me.
    Thank you very much

    Show Less
  • forum

    App Development

    Incremental only update..

    Dear all, I have table such as below  without any modification date fields and every day the period is changes based on backend calculations. Day:1 ID... Show More

    Dear all,

    I have table such as below  without any modification date fields and every day the period is changes based on backend calculations.

    Day:1

    ID        Period

    1         2Yrs-3months-10days

    2         4Yrs-5Months-0days

    3         0Yrs-1Month-10days

     

    Day:2

    ID        Period

    1         2Yrs-3months-10days

    2         7Yrs-2Months-0days

    3         0Yrs-1Month-11days

     

    Our requirement is display the latest Period for each ID. How can we achieve this.

     

     

     

     

    Show Less
  • forum

    App Development

    function with single parameter

    Dear all, I have below code running in qliksense to get the profit and margin for each ID from the fact table. I have total 300000 unique ID for each ... Show More

    Dear all,

    I have below code running in qliksense to get the profit and margin for each ID from the fact table.

    I have total 300000 unique ID for each of them I am gettting profit  from database package.

    Problem is it is taking too much time which is offcourse because for each single ID it is getting connected to database package which has its own script and then as function it is returning its profit to the qliksense.

    I need to understand if there is any possible solution to fetch the records faster..

     

    Fact:

    LOAD 

    ID 

    FROM TEST.QVD;

     

    For i=0 to fieldvaluecount('ID)'

    Let vFieldIDValue =FieldValue('ID','$(i)');

    Profit:

    LOAD*;

    Select ID, Profiltfrom table (pkg.profilt('$('vFieldIDValue '))

    NEXT;

    DROP TABLE FACT;

     

    So, in above code the highlighted is the database package and profitmargin is the function which takes single ID from fact table as parameter and do its CALCULATION AND RETURN the result as profit.

     

    NOTE: when we execute "Select ID, Profiltfrom table (pkg.profilt('$('vFieldIDValue '))" in database directly it takes very lesss time than the qliksense

     

     

     

    Show Less
  • forum

    Qlik Replicate

    Matching Nullability in Target and Change Table

    Hello Qlik Community, We are currently trying to replicate various tables from a DB2-ZOS to a DB2-LUW using Qlik Replicate, and we have noticed that t... Show More

    Hello Qlik Community,

    We are currently trying to replicate various tables from a DB2-ZOS to a DB2-LUW using Qlik Replicate, and we have noticed that the nullability in the target table and the corresponding __ct table are different. Are there ways to keep these consistent?

    some snippets of the corresponding log:

    Spoiler
    00008364: 2024-09-13T09:17:21 [TARGET_LOAD ]T: Create table statement: CREATE TABLE "POC_CDC_QLIK"."NULLTEST_TAANSAKT__ct" ( "header__change_seq" nvarchar(35) NOT NULL, "header__change_oper" nvarchar(1) NOT NULL, "header__change_mask" VARBINARY(128), "header__stream_position" nvarchar(128) NOT NULL, "header__operation" nvarchar(12) NOT NULL, "header__transaction_id" nvarchar(32) NOT NULL, "header__timestamp" TIMESTAMP NOT NULL, "ANSAKT_VNR" INTEGER, "ANSAKT_PB" nvarchar(1), "ANSAKT_SP" SMALLINT, "ANSAKT_GEVO_ID" TIMESTAMP, "ANSAKT_PA_ID" INTEGER, "ANSAKT_GES" nvarchar(3), "ANSAKT_SG" nvarchar(3), "ANSAKT_AKTION" nvarchar(10), "ANSAKT_ANS_DAT" DATE, "ANSAKT_A_KZ" nvarchar(1), "ANSAKT_G_KZ" nvarchar(1), "ANSAKT_CODE" nvarchar(20), "ANSAKT_ZAE_1" SMALLINT, "ANSAKT_ZAE_2" SMALLINT, "ANSAKT_ZAE_3" SMALLINT, "ANSAKT_ZAE_4" SMALLINT, "ANSAKT_E_STAMP" TIMESTAMP, "ANSAKT_L_STAMP" TIMESTAMP, "ANSAKT_RC" SMALLINT, "ANSAKT_WERTE_1" nvarchar(100), "ANSAKT_WERTE_2" nvarchar(100), "ANSAKT_ERIN_REL" nvarchar(1) ) (provider_syntax_manager.c:1815)

     

    Spoiler
    00008364: 2024-09-13T09:17:23 [TARGET_LOAD ]T: Create table statement: CREATE TABLE "POC_CDC_QLIK"."NULLTEST_TAANSAKT" ( "ANSAKT_VNR" INTEGER NOT NULL, "ANSAKT_PB" nvarchar(1) NOT NULL, "ANSAKT_SP" SMALLINT NOT NULL, "ANSAKT_GEVO_ID" TIMESTAMP NOT NULL, "ANSAKT_PA_ID" INTEGER NOT NULL, "ANSAKT_GES" nvarchar(3) NOT NULL, "ANSAKT_SG" nvarchar(3) NOT NULL, "ANSAKT_AKTION" nvarchar(10) NOT NULL, "ANSAKT_ANS_DAT" DATE NOT NULL, "ANSAKT_A_KZ" nvarchar(1) NOT NULL, "ANSAKT_G_KZ" nvarchar(1) NOT NULL, "ANSAKT_CODE" nvarchar(20) NOT NULL, "ANSAKT_ZAE_1" SMALLINT, "ANSAKT_ZAE_2" SMALLINT, "ANSAKT_ZAE_3" SMALLINT, "ANSAKT_ZAE_4" SMALLINT, "ANSAKT_E_STAMP" TIMESTAMP, "ANSAKT_L_STAMP" TIMESTAMP, "ANSAKT_RC" SMALLINT NOT NULL, "ANSAKT_WERTE_1" nvarchar(100) NOT NULL, "ANSAKT_WERTE_2" nvarchar(100) NOT NULL, "ANSAKT_ERIN_REL" nvarchar(1) NOT NULL ) (provider_syntax_manager.c:1815)
    Show Less
  • forum

    New to Qlik Analytics

    'Add new' Button missing, alternative ways to load data?

    I am relatively new to this software, and I usually replace my old data with new ones at the homepage. But my 'add new' button is gone (which is the o... Show More

    I am relatively new to this software, and I usually replace my old data with new ones at the homepage. But my 'add new' button is gone (which is the one i usually upload data before i go into data load editor) and i dont know how it went missing. can anyone who knows about this help me out?

    Show Less
  • forum

    Qlik Replicate

    DML Output in Qlik Replicate

    Is it possible to generate DML statements instead of replicating to a destination ?  
  • forum

    Qlik Cloud Data Integration

    Dynamodb Error connecting to the Sense service

    Hi, My connection to Dynamodb was working a couple of days ago. When I try to connect now, I am getting an error message saying "Error connecting to t... Show More

    Hi,

    My connection to Dynamodb was working a couple of days ago. When I try to connect now, I am getting an error message saying "Error connecting to the Sense service". How do I fix this please?

    Diinkant_0-1726447690938.png

     

    Thanks

    Show Less
  • forum

    App Development

    Sense Script Load Analyzer - Connection monitor_apps_REST_app not found

    Hi People, I have installed the app Sense-Script-Load-Analyzer.qvf, and changed the app owner - as requested. When loading, I get the error mesage: C... Show More

    Hi People,

    I have installed the app Sense-Script-Load-Analyzer.qvf,

    and changed the app owner - as requested.

    dana_0-1726396000914.png

    When loading, I get the error mesage:

    Connection monitor_apps_REST_app not found.

    Any idea how I an resolve this?

    Are there any alternatives for this tool?

    Thanks!

     

     

    Show Less
  • forum

    QlikView App Dev

    Set expression with If Statement in a expression

    Hello all, I would like to exclude Region filter from my expression but the below listed expression is not working. I have If condition for an aggrega... Show More

    Hello all,

    I would like to exclude Region filter from my expression but the below listed expression is not working. I have If condition for an aggregated dimension and trying to exclude Region filter. Please suggest.

    = Count({<Region= >} Aggr (If ( Status = 'InProcess', Status <> 'Complete'), Commodities, Commodities))

     

    Thanks.

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