Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 217,173 members
  • 6,155 online
  • 1,994,783 posts
  • 149,486 Solutions

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Replicate

    Job failing with error unable to rename repcmd.log

    We are triggering replicate by using scheduling tool and periodically checking the status if replicate completed or not. Although the replicate load i... Show More

    We are triggering replicate by using scheduling tool and periodically checking the status if replicate completed or not. Although the replicate load is going success the job is failing with the error Failed to rename file repcmd.log to repcmd__240417043324.log .

     

    Show Less
  • forum

    Qlik Compose for Data Warehouses

    __ct tables not showing up in Qlik Compose

    I'm setting up a new DW with Full load and CDC tasks. When I try to add a new mapping for the CDC task the __ct tables are not showing up in the list ... Show More

    I'm setting up a new DW with Full load and CDC tasks. When I try to add a new mapping for the CDC task the __ct tables are not showing up in the list of tables for the corresponding schema. __ct tables are present in the landing database (SQL Server 2019) and Replicate is processing and storing the changes. Already tried recreating the Project, but no luck. 

    Compose 2023.11.0.159

     

    Show Less
  • forum

    Insight Advisor

    Why Qlik Insight Advisor is not more popular?

    Hi all! With Bard and ChatGPT, the "NL generated visualization and insights" has become a really hot topic these days, but Qlik has had this functiona... Show More

    Hi all!

    With Bard and ChatGPT, the "NL generated visualization and insights" has become a really hot topic these days, but Qlik has had this functionality since 2019 with the Insight Advisor.

    I've asked a lot of consultants and Qlik experts, but I couldn't find a single company that was using this resource in their day-to-day operations to solve problems.

    I've been conducting some tests with this tool, and everything has been working fine so far. This led me to ask myself, and now I'm asking you guys, why is almost no company using this? Is it a "red flag" regarding the Insight Advisor?

    I know there are many commercial presentations highlighting how the tool can help companies, but is anyone really using it? Do you guys have any use cases?

    Please let me know your thoughts and experiences. Thanks in advance!

    Show Less
  • forum

    Insight Advisor

    Are there any recent versions of the document titled "Natural Language Query Fea...

    Greetings! I am looking for the most recent version of the document titled "Natural Language Query Features", December 2019.  Please see attachment of... Show More

    Greetings!

    I am looking for the most recent version of the document titled "Natural Language Query Features", December 2019.  Please see attachment of the doc I am referring to.

    Cheers,

    ++José

    Show Less
  • forum

    Insight Advisor

    How to indicate to Insight Advisor that a NL term requieres the use of a search ...

    Greetings! I need to be able to specify to Insight Advisor that when a user is asking for information involving the contents of a field, the expressio... Show More

    Greetings!

    I need to be able to specify to Insight Advisor that when a user is asking for information involving the contents of a field, the expression generated has to use a set analysis-type search in the value of the field, instead of looking for discrete values. 

    For instance, lets say that I have a master measure called [GrossSales] and I need to let users ask for gross sales of "jewelry", but "jewelry" is not a discrete value of a field, rather it is a sequence of characters that appears in several values of a field, such as "BE-02 Men's Jewelry PBA" or "BE-03 Women's Jewelry PNA".

    What I need is to generate a expression similar to {$<ArticleGroup={"*jewelry*"}>}[GrossSales].

    Can this be done in Insight Advisor?

    Please advise.

    ++José

    Show Less
  • forum

    App Development

    Canonical Dates over multiple associated tables without a common key

    Hello everyone, i'm having issues trying to create a canonical date in qlik sense when associating tables and was wondering if anyone would be able to... Show More

    Hello everyone, i'm having issues trying to create a canonical date in qlik sense when associating tables and was wondering if anyone would be able to help out. In basic terms i have 2 tables: "orders" and "sales rep visits", which are associated to the "customer data" table by customer number, (very simplified) script below:

    [Customers]:
    LOAD
    [Customer Number],
    [Customer Name]
     FROM [Customers.qvx]
    (qvx);
     
    [Orders]:
    LOAD
    [Order Customer Number] as [Customer Number],
    [Item],
    [Quantity],
    [Order Date],
     FROM [Orders.qvx]
    (qvx);
     
    [Visits]:
    LOAD
    [Visit Customer Number] as [Customer Number],
    [Visit ID],
    [Visit Date]
     FROM [Visits.qvx]
    (qvx);
     
    Given the order data and visit data are completely separate datasets with customer number being the only common field between them, i don't think the usual way i do canonical dates with a common key in each table will work, and they need to be associated as opposed to joined due to the '1 to many' relationships that are formed from combining order and visit data. Would anyone know how i could create a canonical date between the 2 date fields (order date and meeting date) even without a common key linking them?
     
    Any help would be appreciated! Thanks!
     
    Tables below for added context:
     
    Customer Table 
    Customer Number Customer Name
    1 Cust1
    2 Cust2
    3 Cust3
    4 Cust4
    5 Cust5
     
    Order Table
    Order Customer Number Item Quantity Order Date
    3 Apple 4 2024-02-16
    4 Pear 8 2024-02-18
    4 Grape 10 2024-04-01
    5 Strawberry 1 2024-03-19
    2 Orange 3 2024-01-26
    1 Apple 5 2024-01-02
    1 Orange 5 2024-03-23
    1 Apple 2 2024-04-17
     
    Visit Table
    Visit Customer Number Visit ID Visit Date
    3 abc 2024-01-21
    1 def 2024-01-26
    2 ghi 2024-02-02
    4 jkl 2024-02-28
    2 mno 2024-03-13
    3 pqr 2024-03-17
     
    Show Less
  • forum

    New to Qlik Analytics

    Where are stored the bookmarks?

    Hello everybody.I am looking for the Postgres table where the contents of the bookmars are recorded. I found the table (AppObjects) that contains the ... Show More

    Hello everybody.
    I am looking for the Postgres table where the contents of the bookmars are recorded. I found the table (AppObjects) that contains the information, but I can't find the table that contains what is the set of filters and selections of the bookmark itself.

    For example, in a bookmark I have this content:

    {<TipoVeicolo = {'Off-road vehicle', 'Cars'}, Type = {' Auto '}, [= If (Source <>' Rental ', Source)] = {' Circulating '}>}

    Where can I find this content in the DB? Or where can I edit and / or export it?

    Show Less
  • forum

    Deployment & Management

    Qlik Nprinting, Qlik alerting and Geo Analytics on same server

    Hi, I was checking if we could install NPrinting, Alerting and Geo Analytics on the same server. couldnt find any articles related to it. I know that ... Show More

    Hi, 

    I was checking if we could install NPrinting, Alerting and Geo Analytics on the same server. couldnt find any articles related to it. I know that Qlik doesnt support QS and NP on a same server but not sure of NP and Qlik Alerting on the same server. 

    Thanks in Advance

    Qlik NPrinting Qlik Alerting Qlik GeoAnalytics 

    Show Less
  • forum

    App Development

    Stacked Bar Chart Question

    In Qliksense how to create a stack bar chart with 2 dimensions and 2 measures. Thanks for help!
  • forum

    QlikView App Dev

    Stacked Bar chart with 2 expressions and 2 dimensions

    Hi, i want to create a stacked bar chart with 2 expressions (ACT vs BDG) and two dimensions, first one in x axes (BU) and the second one stacked (AREA... Show More

    Hi, i want to create a stacked bar chart with 2 expressions (ACT vs BDG) and two dimensions, first one in x axes (BU) and the second one stacked (AREA ICT). I would these two charts in a single one with ACT and BDG side by side:

    Esempio.JPG

    See qvw attached

    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!