Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,313 members
  • 5,737 online
  • 1,991,639 posts
  • 149,201 Solutions
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Replicate

    Replicate data from last 24 months

    Hello, My Source connection is an Oracle database. I have audit tables in my Replicate task "Full Load + Apply Changes" the tables are huge and by nat... Show More

    Hello,

    My Source connection is an Oracle database. I have audit tables in my Replicate task "Full Load + Apply Changes"

    the tables are huge and by nature there is heavy DML operations. 

    My target is Snowflake "Extra Small Size", I see significant amount of latency when i tried replicating audit tables. 

    Is there a way I can limit the date range to be at most 24 months of history data in the replicate task ?

     

    Thank you.

    Show Less
  • forum

    Qlik Enterprise Manager

    Reload QEM task using Python API with filters

    Hi,   I am trying to reload a Qlik Replicate task using QEM Python API.  I am using reload_table method to achieve my goal. However, I do not see any ... Show More

    Hi,

     

    I am trying to reload a Qlik Replicate task using QEM Python API. 

    I am using reload_table method to achieve my goal.

    However, I do not see any option to define filters using the above method. 

    I have tried the below:

    reload_table(server, table, filters:{col1:value1,value2})

    but that doesn't work.

    Is there any way to achieve my said requirement using the above method or is there any other method which I can use to reload the task with table filters. 

    Kindly assist. 

    Show Less
  • forum

    App Development

    Why is the include variable executed?

    Dear All The include variable is located behind the exit clause.This script is not interrupted in the exit clause.Why is the include variable executed... Show More

    Dear All

    The include variable is located behind the exit clause.

    This script is not interrupted in the exit clause.

    Why is the include variable executed?

     

    *********** Script  new *****

    vServername = ComputerName() ;
    trace $(vServername);
    if '$(vServername)' = 'QlikDev' then 
    trace '------1';
    else
    trace '------2';
    end if
     
    exit script;
     
    vTargetPath_qvs = 'lib://File_Folder ;
    $(Must_Include=[$(vTargetPath_qvs)/AUTH/Authorization.qvs]);
     
    exit script;

     

    *************** Script end

     

    Qlik Sense Version : Nov 2023 patch 7

     

    Best Regard

    Hanna.choi

    Show Less
  • forum

    Integration, Extension & APIs

    azure_sql  EXCEPTION IN Server.Run(): Invalid connector configuration file

    Hi, Could use some help targeting a solution for an odbc azure error when running jobs in the QMC. The full error is: C:\ProgramData\Qlik\Custom Data\... Show More

    Hi, Could use some help targeting a solution for an odbc azure error when running jobs in the QMC.

    The full error is:

    C:\ProgramData\Qlik\Custom Data\QvOdbcConnectorPackage\Log

    azure_sql  EXCEPTION IN Server.Run(): Invalid connector configuration file - can not find azure_sql-reading-strategy key

    This occurred after a QS upgrade from a 2022 version to November 2023 Patch 3.

    2 servers were upgraded with only one having the issue with jobs running in the QMC.

    In that troubled server, the Azure connections in Qlik Sense will alloy selection of data (connection is apparently fine) but changes to the connection can not be made.

     

    Show Less
  • forum

    Move to SaaS

    qlik qrs export command giving error when --exportScope all flag is added

    Hi,   We are migrating from Qlik Sense Windows to Cloud. When running the migration scipt for migrating apps, it gives error. Tried each line in qlik ... Show More

    Hi,

     

    We are migrating from Qlik Sense Windows to Cloud.

    When running the migration scipt for migrating apps, it gives error. Tried each line in qlik cli. The line that fails is

             qlik qrs app export create $appid --skipdata $SS --exportScope all --output-file $exportAppFile

             Error: 400 - Bad Request (empty response)

    But when i run the command without the --exportScope all option in qlik-cli it works.

            qlik qrs app export create $appid --skipdata $SS  --output-file $exportAppFile

     

    Are there any permissions or setup that i am missing?

     

    Thanks,

    Anuradha

     

     

     

     

     

    Show Less
  • forum

    New to Qlik Analytics

    Graphique combiné composé de graphiques en aires et en lignes (Qlik Sense)

    Bonjour On me demande de créer un graphique combiné avec des aires et des lignes. Dans Qlik Sense je n'ai trouvé que la composition barres et lignes. ... Show More

    Bonjour

    On me demande de créer un graphique combiné avec des aires et des lignes.

    Dans Qlik Sense je n'ai trouvé que la composition barres et lignes.

    D'avance merci de votre aide

    garph_combiné.JPG

    Show Less
  • forum

    App Development

    Automatic Storytelling in Qlik Sense

    Hello!I am trying to create some reports in Qlik Sense using the Stories functionality. Is there any way that I am able to automatically update the re... Show More

    Hello!

    I am trying to create some reports in Qlik Sense using the Stories functionality.

    Is there any way that I am able to automatically update the reports?

    I mean, I create some screenshots and stories in my dashboard, and I would like to have a report with the same tables and graphs each 2 weeks. Is it possible to get the information updated, or should I create the snapshots every time I want to see them?

    Thank you in advance!

    Show Less
  • forum

    App Development

    Matching in Script, based on count()

    Hi everyone, i have a small logic problem matching 2 fields based on their count amount. i have managed to get the required result, using the set anal... Show More

    Hi everyone,

    i have a small logic problem matching 2 fields based on their count amount. i have managed to get the required result, using the set analysis, but this is not working as expected when i want to filter, based on this result field.

    So, consider having the following Table:

    CreditorNr | Type | BankNr

    010001     | 200   | 12345200

    010001     | 200   | 12345200

    010001     | 200   | 12345200

    010001     | 200   | 12345100

    010001     | 100   | 12345100

    Using the following formula, i obtained the following MatchField:

    =aggr(If(
    Count(Distinct Type ) = 1 and
    Count(Distinct BankNr) = 1, 'Partner bank is clear', 'Partner bank is not clear'), CreditorNr , BankNr)

    i get following results, that are also correct:

    CreditorNr | Type | BankNr       | MatchField

    010001     | 200   | 12345200   | Partner bank is clear

    010001     | 200   | 12345200   | Partner bank is clear

    010001     | 200   | 12345200   | Partner bank is clear

    010001     | 200   | 12345100   | Partner bank is not clear

    010001     | 100   | 12345100   | Partner bank is not clear

     

    Anyway, when trying to implement this in the Script, i dont get the correct result. In the Script i use the following code:

    TEMP:
    NoConcatenate
    Load CreditorNr,
    If(Count(Distinct Type) = 1 and
    Count(Distinct BankNr) = 1, 'Partner bank is clear', 'Partner bank is not clear') as ScriptMatch
    Resident BankTab
    Group by CreditorNr, BankNr;

    And i get the following result:

    CreditorNr | Type | BankNr       | MatchField                        | ScriptMatch

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is clear

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is not clear

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is clear

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is not clear

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is clear

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is not clear

    010001     | 200   | 12345100   | Partner bank is not clear   | Partner bank is clear

    010001     | 200   | 12345100   | Partner bank is not clear   | Partner bank is not clear

    010001     | 100   | 12345100   | Partner bank is not clear   | Partner bank is clear

    010001     | 100   | 12345100   | Partner bank is not clear   | Partner bank is not clear

    So it basically goes through every BankNr and duplicates the data, once bank is clear, and once bank is not clear... 

    Can anyone please give me a hint on what im i doing wrong in the script?


    Thank you for the support. 🙂

    Show Less
  • forum

    New to Qlik Analytics

    Comment faire un slider qui prend en compte des tranches (plages) de données ?

    Bonjour, Comment faire un slider qui prend en compte des tranches (plages) de données comme sur QlikView ? Y a-t-il une extension autre que celle du ... Show More

    Bonjour,

    Comment faire un slider qui prend en compte des tranches (plages) de données comme sur QlikView ?

    Wal_Riachi_0-1711627489018.png

    Y a-t-il une extension autre que celle du bundle ? Car celle du bundle permet de sélectionner qu'une seule valeur.

    Merci d'avance,

    Waïl

     

    Show Less
  • forum

    New to Qlik Analytics

    Link table for accounting data in OLE DB data and budget data from Excel File

    Hi, I have a problem where I need to get Transaction data from a OLE DB data source and then add en Excel file with manually entered Budget data for f... Show More

    Hi,

    I have a problem where I need to get Transaction data from a OLE DB data source and then add en Excel file with manually entered Budget data for four different companies, the load data look like this compressed with the relevant fields for two of the companies as below.

    I add the company name as Client field for every company and the joined data for Transactions table is working as supposed.

    My problem is that the budget data is added on the last day of the month because it's mainly relevant to look at this aggregated per month. But since there are multiple transactions in the Transaction data the last day of the month every month the Budget data get multiplied for every occurrence of that date.

    What I've found is that I should use a Link table to solve this issue but it seems that my skills is not enough to get the script right.

    I would like to group interval of accounts for example revenue, material cost, gross profit etc. for set analysis and add a master calendar (or similar) to do analysis on different time periods. Is it possible to have a Link table for Client, account and date fields and then add grouping and master calendar connected in the Link table or do you have to do this in the Load for the original data sources?

    LIB CONNECT TO 'Briljantdata - MGA (ad_ext_kons)';
     
    Transactions:
     
    LOAD 
     
    'MGA' as Client,
        bel, // (amount field)
        kto, // (Account field)
        trdat; // (Date field)
    SQL SELECT
        bel,
        kto,
        trdat
    FROM rtr;
     
     
    LIB CONNECT TO 'Briljantdata KJ (ad_ext_kons)';
     
    join(Transactions)
    LOAD
    'KJ' as Client,
        bel, // (amount field)
        kto, // (Account field)
        trdat; // (Date field)
    SQL SELECT
        bel,
        kto,
        trdat
    FROM rtr;
     
    LOAD
    'MGA' as Client,
        kto, // (Account field)
        trdat, // (Date field)
        Budget_belopp // (Amount field)
    FROM [lib://AttachedFiles/Qlik sense Budget MGA 22-23 & 23-24.xlsx]
    (ooxml, embedded labels, table is Budgetdata_MGA);
     
    LOAD
    'KJ' as Client,
        kto, // (Account field)
        trdat, // (Date field)
        Budget_belopp // (Amount field)
    FROM [lib://AttachedFiles/Qlik sense Budget KJ 22-23 & 23-24.xlsx]
    (ooxml, embedded labels, table is Budgetdata_KJ);
     
    Help is much appreciated!
    Show Less
Leaderboard

Customer Story

Qlik Data Integration & Qlik Replicate story

Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.

Customer Story

Building a Collaborative Analytics Space

Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.

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!