Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,315 members
  • 5,657 online
  • 1,991,640 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 Application Automation

    How to correct umlauts that have been incorrectly encoded

    I've got some data from an external source where the Umlaut characters have been encoded as an A-like character. It's a real chore to identify the inc... Show More

    I've got some data from an external source where the Umlaut characters have been encoded as an A-like character. It's a real chore to identify the incorrect character in the data then find the correct unlaut, let alone doing the Replace. I cannot be sure I'm even identifying the correct match as it's a matter of deduction by working out what it should be. I'm wondering if there's a way to get Qilk to translate these or failing that a way of looking up individual characters online so I can build an table for a map.

    i.e.

    Character      Replacement

    Ãœ Ü
    Ö Ö
    Ń Ń
    ß ß
    Ó Ó
    ÄŒ Č
    É É
    Ň Ň
    Ř Ř
    Äš Ě
    Åž Ș
    Ž Ž
    Ź Ź
    Show Less
  • forum

    Installing and Upgrading

    Connexion à une base de données HFSQL

        Bonjour, Je rencontre actuellement un problème de connexion à une base de données hfsql Type de base de données : JDBC généralURL : jdbc :... Show More
     
     

    Bonjour,

    Je rencontre actuellement un problème de connexion à une base de données hfsql

    Type de base de données : JDBC général
    URL : jdbc : odbc : nom du serveur 
    Jar Pilote : rt (à partir de jre 7 64 bits)
    Nom de la classe : sun.jdbc.odbc.JdbcOdbcDriver
    Lorsque je vérifie la connexion, j'obtiens ce message d'erreur :

    Aucun pilote approprié trouvé pour jdbc

    J'ai besoin d'aide à ce sujet. Merci d'avance .

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