Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 214,339 members
  • 6,437 online
  • 1,989,580 posts
  • 149,026 Solutions
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    Graph with 2 dimensions

    Hello,I want to do the graph below in QlikSense : We have 2 dimensions : Year and Product, with the same measure.How can I do that?  
  • forum

    App Development

    Chatting with ChatGPT about Qliksese

    Hi, I have asked ChatGTP to write some code that will show me the third business day of the week. I have been amazed at how fast and accurate it has b... Show More

    Hi, I have asked ChatGTP to write some code that will show me the third business day of the week. I have been amazed at how fast and accurate it has been.

    Do you think it can be optimized? (al code in text format bellow)

    MigueldelCampo_0-1671280261962.png

     

     

    // Set up a calendar table to use for date calculations
    Calendar:
    LOAD
    date(YearStart(year, month, 1) + rowNo() - 1) as date,
    week(YearStart(year, month, 1) + rowNo() - 1) as week,
    year(YearStart(year, month, 1) + rowNo() - 1) as year,
    month(YearStart(year, month, 1) + rowNo() - 1) as month,
    day(YearStart(year, month, 1) + rowNo() - 1) as day
    FROM
    [lib://calendar/calendar.qvd] (qvd);

    // Set up a table to store the 3rd business day for each week
    ThirdBusinessDay:
    LOAD
    min(date) as third_business_day
    RESIDENT
    Calendar
    WHERE
    isweekday(date) = 1 and day >= 3;

    // Group by week to get the 3rd business day for each week
    ThirdBusinessDay:
    LOAD
    third_business_day,
    week,
    year,
    month
    RESIDENT
    ThirdBusinessDay
    GROUP BY
    week,
    year,
    month;

    // Drop the original calendar table
    DROP TABLE Calendar;

    Show Less
  • forum

    New to Qlik Analytics

    show highest value in script

        Hello, i have an issue i need help please.  I have the following data :  date ID Amount  Code Transaction ID Total   742,11     15/... Show More
     
     

    Hello, i have an issue i need help please. 

    I have the following data : 

    date ID Amount  Code Transaction ID
    Total   742,11    
    15/02/2024 224 259,67 2 2024021508312521
    15/02/2024 224 185,35 2 2024021514530321

     

    I want a script that gives me the amount with the highest transaction id. 

    in this exemble, the result should be one lie with the amount 185,35

    Show Less
  • forum

    Integration, Extension & APIs

    Integration of Qlik with chatgpt

    Is there any way of integrating qlik with Chatgpt? If yes ,can someone post the detailed roadmap??
  • forum

    Qlik Cloud Data Integration

    Using condition

    can we able to use multiple condition in a where clause? for ex: we are having several countries. ( ind, aus, eng,pak) i need to filter and show only ... Show More

    can we able to use multiple condition in a where clause?

    for ex: we are having several countries. ( ind, aus, eng,pak)

    i need to filter and show only ind and aus.

    so, how we can write script using where condition. 

    can anyone please share your ideas for my learning.

    Show Less
  • forum

    New to Qlik Analytics

    Task Lists As Failed - But Script Log Seems Successful

    Hello Folks,I looked through my tasks on the QMC and I saw that one failed.  However, when I look at the script log, I see that the script says it fin... Show More

    Hello Folks,

    I looked through my tasks on the QMC and I saw that one failed. 

    2020-09-08 10_15_40-Tasks - QMC.png

     

    However, when I look at the script log, I see that the script says it finished successfully.

     

    2020-09-08 10_16_31-C__Users_jdallas_AppData_Local_Temp_Reload task of TMW_Data_Extractor_Three_v3.l.png

     

    Has anyone else seen such behavior? 

    Show Less
  • forum

    New to Qlik Analytics

    How to concatenate 2 tables in the load editor

    Hi all, I need to concatenate these 2 tables, and they share the name of 2 fields (event_code and weeks_left_to_event), but need them to be connected ... Show More

    Hi all,

    I need to concatenate these 2 tables, and they share the name of 2 fields (event_code and weeks_left_to_event), but need them to be connected only by the event_code. 

    As I have the script now, there aer rows missing form the second table as only appear the rows that share the weeks_left_to_event. How could I do this? Do I need to make a UNION ALL in the pipeline before Qlik or there is a way to do it in the load editor?

    This is the code:

    [marts_event_ticketing]:
    SELECT "event_id",
    "event_name",
    "event_country",
    "event_date",
    capacity,
    "event_code",
    "ticket_id",
    "cashless_paid_credits",
    quantity,
    "ticket_type",
    "sold_date",
    "ticket_date",
    "ticket_category",
    status,
    "event_currency",
    "gbp_rate",
    "eur_rate",
    "base_amount",
    "fee_amount",
    "total_amount",
    email,
    "customer_country",
    city,
    age,
    gender,
    "age_group",
    "year_event",
    "month_event",
    "days_left_to_event",
    "weeks_left_to_event",
    "months_left_to_event",
    babb,
    "previous_event_code",
    "previous_event_name",
    "previous_year_comparison",
    "ticket_sales",
    "previous_event_ticket_sales",
    "event_end_time",
    "event_to_compare",
    "previous_day_sales",
    "marketing_total_spend",
    cpa,
    budget_event_end_time,
    budget_quantity,
    budget_price,
    budget_fee,
    budget_gross_revenue
    FROM "dbt_xavi_marts"."marts_event_ticketing";

    concatenate
    LOAD
    "event_code",
    "budget_event_end_time",
    round("weeks_left_to_event", 1) AS weeks_left_to_event,
    "budget_quantity",
    "budget_price",
    "budget_fee",
    "budget_gross_revenue"
    FROM [lib://DataFiles/Ticketing 2024 (1).xlsx]
    (ooxml, embedded labels, table is [Hoja 3]);

    Show Less
  • forum

    App Development

    no cumulative value in line chart when there are no actual values

    Hello, how do i need to make a linechart with a cumulative total that stops drawing a line when there are no actua values instead of keeping a straigh... Show More

    Hello,

    how do i need to make a linechart with a cumulative total that stops drawing a line when there are no actua values instead of keeping a straight line?

    i can't seem to work this out...

    This is expression i have:

    sum({<[Fiscal Year]={'2023 - 2024'}, [KPI's]={'KPI 1:Retail / Tafelen'} >}[factuur tot net])/1000

     

    Thanx a lot!

     

    grtz,

    Chris

    Show Less
  • forum

    Component Development

    Talend MDM Components

    Talend MDM will reach its end of life this year. However, I am interested in creating an MDM scenario using Talend Studio without relying on the MDM s... Show More

    Talend MDM will reach its end of life this year. However, I am interested in creating an MDM scenario using Talend Studio without relying on the MDM server for data management. Additionally, I am aware that MDM components have been integrated into the Real-Time Platform Studio. Are there any documentation resources available for these components?

    Show Less
  • forum

    App Development

    Delegate to users

    Hi All ! We are facing a strange issue with entitlements for some files.  We have set it to 'All Authenticated Users' but somehow on random days it ge... Show More

    Hi All !

    We are facing a strange issue with entitlements for some files. 

    We have set it to 'All Authenticated Users' but somehow on random days it gets automatically set to 'Named Users' and only one userID shows up there.

    Does anyone have any ideas around this?

     

    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!