Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 217,171 members
  • 5,299 online
  • 1,994,776 posts
  • 149,485 Solutions

Welcome to Qlik Community

Recent Discussions

  • 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

    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

    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
  • forum

    App Development

    Issues with Qlik Variable Input object.

    Hello, We have been successfully using the old Variable object that I believe we obtained from Qlik Branch/Garden/Sandbox quite some time ago. We rece... Show More

    Hello,

    We have been successfully using the old Variable object that I believe we obtained from Qlik Branch/Garden/Sandbox quite some time ago. We recently decided to replace instances of that object with the Variable Input object found in the Qlik Dashboard Bundle on the assumption that this one is "officially supported" by Qlik and that would be safer to use in the long run. 

    However, we have discovered that in "button" mode, some of our button labels are being truncated where they weren't with the old variable object. Also, in "input box" mode, the right side of the input box extends beyond the edge of the object; again, this didn't happen with the old variable object. 

    Is anyone else experiencing these issues? 

    Show Less
  • forum

    Qlik Cloud Data Integration

    Qlik Cloud Tasks Queued

    Hello, I'm new to Qlik Cloud Integration.  Creating the Onboard from Onprem to target snowflake. While running the task, it is keep on going to Queued... Show More

    Hello,

    I'm new to Qlik Cloud Integration. 

    Creating the Onboard from Onprem to target snowflake.

    While running the task, it is keep on going to Queued and not completing with data load to target system.

    Only metadata is getting created in snowflake.

    I dont have windows configuration access from my side to check the memory or CPU. If anything to verify in Qlik cloud or any other workaround .Please suggest.

     

    Show Less
  • forum

    Connectivity & Data Prep

    Qlik Sense connectivity via Office 365 SharePoint

    Hi, I'm trying to connect Office 365 Sharepoint in Qlik Sense. Below are the steps performed.  1. Creating a new data connection.  2. Choosing the Off... Show More

    Hi, I'm trying to connect Office 365 Sharepoint in Qlik Sense. Below are the steps performed. 

    1. Creating a new data connection. 

    2. Choosing the Office 365 SharePoint connector, and mention the base URL and choose the "select Account" prompt. 

    3. Then its asked for authenticate, the code was generated. and copied that code. Pasted in the respective tab place. 

    After that I'm facing the below error. 

    " Error Verifying: A connection attempt failed because the connected party did not properly respond after a period of time or established connection failed because connected host failed to respond 40.126.53.18:443"

    Note: The IP getting changed whenever I tried. 

    Please suggest. 

     

    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!