Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 221,856 members
  • 3,846 online
  • 2,002,237 posts
  • 150,144 Solutions

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    QVD Files

    If i have created a qvd from an excel sheet then if i make changes in excel file will changes be reflected in qlick sense charts or not
  • forum

    New to Qlik Analytics

    Do reloads triggered by APIs outside Qlik fall under the limit of 50 reloads per...

    In the qlik business documentation its written there is a Maximum number of scheduled reloads per app per day of 50. my question is:  I'm on the trial... Show More

    In the qlik business documentation its written there is a Maximum number of scheduled reloads per app per day of 50. 
    my question is:  I'm on the trial now and currently reload my app every 10 seconds via a scheduled POST request in Newman. its working perfectly, can i assume if i buy the license it will continue working? im confused by the 50 reloads limit per day written on the website.

    Show Less
  • forum

    App Development

    imagenes en Text Object

    Tengo un problema con "Text Object" de QlikView, se ingresa la ruta de una imagen, la imagen esta en un servidor externo, simplemente la imagen no apa... Show More

    Tengo un problema con "Text Object" de QlikView, se ingresa la ruta de una imagen, la imagen esta en un servidor externo, simplemente la imagen no aparece, la ruta se ingresa  de la siguiente manera: ='http://dominio/Carpeta/'&%imagen&'.jpg.

    Para verificar  en acciones (open url) se ha dejalo la misma ruta y si se logra visualizar la imagen ya sea en una ventana nueva o en la misma pero no dentro del "Text Object".

    Si alguien ha tenido este problema que me pudiera orientar.

    gracias

    Show Less
  • forum

    App Development

    Check Dimension Totals Before Loading

    Hi,  I'm working on a load script for a new app and want to validate that I don't have duplicate Item numbers before loading. If there are duplicates,... Show More

    Hi, 

    I'm working on a load script for a new app and want to validate that I don't have duplicate Item numbers before loading. If there are duplicates, I want to stop loading.  My code is not working, but I'm not sure why. If I look at the variables in a sheet, there is a value, but not when I try to print them using Trace, even when it's outside of the IF statement. . 

    Values:

    LOAD

       ItemNumber

       Date,

        Price

    FROM [*QVD File*]

    WHERE

    year(Date) >= year(AddYears(Today(),-1));

     

     

    Right keep(Values)

     

    LOAD

        NAME as ItemNumber,

        Target

    Description

    Color

    Size

    Status

    FROM [*Excel File*]

    Let vDistinctNumberCount = Count(distinct TAGNAME);
    Let vNumberCount = Count(TAGNAME);

     

    If $(vNumberCount) <> $(vDistinctNumberCount) then

        TRACE "*******Error Total ItemNumber count > Distinct ItemNumber count";

    End If;

    Show Less
  • forum

    Qlik Enterprise Manager

    SAP namespace /QTQVC/ does not exist

    Hi, QLik support,Best regards, I am SAP Basis Netweaver consultant, we are currently in a SAP project and we need to modify the Text Lang flag field o... Show More

    Hi, QLik support,

    Best regards, I am SAP Basis Netweaver consultant, we are currently in a SAP project and we need to modify the Text Lang flag field of the SPRAS data element in the / QTQVC / LANGUAGES structure, but the error indicated is "Namespace / QTQVC / does not exist".

    Please indicate the way to solve the problem or create the namespace, we only find information about the applied transport order QT2K900068 but still it does not allow to modify the structure.

    Your help please,I attach images.

     

    Show Less
  • forum

    Qlik Replicate

    Incident Access Denied to Source from Qlik

    Dear Support,   We get issue access denied because any hit user pass to source that cause task stop. For detail, please check the log   Thanks Sapta Show More

    Dear Support,

     

    We get issue access denied because any hit user pass to source that cause task stop.

    For detail, please check the log

     

    Thanks

    Sapta

    Show Less
  • forum

    New to Qlik Analytics

    Trial Unlock File expires May13 2024

    G'day, It is normal for the new Trial Unlock file for Qlik Sense Desktop to come out before or after it expires? Needing to refresh my memory on dashb... Show More

    G'day,

    It is normal for the new Trial Unlock file for Qlik Sense Desktop to come out before or after it expires? Needing to refresh my memory on dashboard creation for the upcoming Qlik Connect conference in Orlando so I can get certified. Thank you!

    Show Less
  • forum

    Qlik Replicate

    Oracle to ADLS Full load is failing with ]E: Failed to convert file from csv to...

    Hello, We have a Full load + Store changes task which loads data from Oracle to ADLS(parquet snappy format). But it is failing for one table during Fu... Show More

    Hello,

    We have a Full load + Store changes task which loads data from Oracle to ADLS(parquet snappy format). But it is failing for one table during Full load with the error:

    00018089: 2024-06-05T05:47:20 [TARGET_LOAD ]E: Failed to convert file from csv to parquet [1024902] (file_utils.c:899)
    00018089: 2024-06-05T05:47:20 [TARGET_LOAD ]E: Failed to convert file '/data/replicate/qlik/tasks/task_name/data_files/MY_TABLE_NAME/LOAD0000000E.tmpcsv'. [1024902] (file_imp.c:2538)
    00018088: 2024-06-05T05:47:20 [SOURCE_UNLOAD ]I: Unload finished for table 'FS'.'MY_TABLE_NAME' (Id = 6). 16436666 rows sent. (streamcomponent.c:3784)
    00018033: 2024-06-05T05:47:20 [TASK_MANAGER ]W: Table 'FS'.'MY_TABLE_NAME' (subtask 1 thread 1) is suspended. (replicationtask.c:3147)
     
    Any suggestions to resolve that? 
    Show Less
  • forum

    QlikView App Dev

    Start and end of for-loop: Zero-indexed?

    Hi,I'm developing a load script that needs to loop through a table and call a function within the loop. I'm having some trouble with the start and end... Show More

    Hi,

    I'm developing a load script that needs to loop through a table and call a function within the loop. I'm having some trouble with the start and end of the loop.

    Can someone confirm if Qlik-scripts are zero indexed or not?

    An example:

    LOAD * INLINE [
    F1
        A
        B
        C
        D
        E
        F
    ]
    ;
    LET NumRows = NoOfRows('TEST');
    TRACE $(NumRows);
    FOR i=1 to $(NumRows)
         
    LET lols = Peek('F1',$(i),'TEST');
         TRACE $(lols);
    NEXT

    I was under the impression that Qlik started lists with 1 and not 0. But that might be wrong? But most examples With usage of the for-loop seems to start with i=1, but that will miss the first element in the table? Am I missing something obvious here?

    Thanks for your input!

    Show Less
  • forum

    Design and Development

    Separating string content in a single column into multiple columns, dynamically

    Hello everyone.How do I extract a string content from a column into multiple columns?I have this:   And I want to turn it into this: Mind you, the o... Show More

    Hello everyone.

    How do I extract a string content from a column into multiple columns?

    I have this:

    RMotta2408_0-1717768397438.png

     

    And I want to turn it into this:

    RMotta2408_1-1717768477428.png


    Mind you, the original column "TEAMS" may have a different number of values. So the Job has to be dynamic to create as many columns as the values in the original "TEAMS" column.
    The "-" character is the values separator.

     

    I just can't seem to get over this hurdle.
    Can anyone please help me?

    Thank you so much,

    Rui

     

    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!