Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 214,348 members
  • 6,031 online
  • 1,989,605 posts
  • 149,030 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

    Calculated Field to convert Date

    The screenshot below refers, l want to create a Calculated Field to convert the column EFFDATE into a proper date format. Current format is 04/03/2024... Show More

    The screenshot below refers, l want to create a Calculated Field to convert the column EFFDATE into a proper date format. Current format is 04/03/2024 07;06:22 which is a string and not proper date format for trend analysis.

    RobinTMavhu_1-1710841128378.png

     

    Show Less
  • forum

    New to Qlik Analytics

    How to filter a Dimension field in a Filter Pane

    In a table I set a Filter Pane and a Table with columns.Rather than select manually the items from the Filter Pane, I would like to filter the items t... Show More

    In a table I set a Filter Pane and a Table with columns.
    Rather than select manually the items from the Filter Pane, I would like to filter the items through an expression similar to this:
    =only({<[Material Number (Product)]={
    'xyz'
    }>}
    [Material Number (Product)]). 

    Probably the expression is not adeguate to the Filter Pane.
    Is there any way to filter it by a predefined list? 

    Thanks

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

    QlikView Administration

    Move QMS to another server

    I've tried to move QMS on another machine as described here. How to move the QlikView Management Service to a n... - Qlik Community - 1714113 Now new ... Show More

    I've tried to move QMS on another machine as described here.

    How to move the QlikView Management Service to a n... - Qlik Community - 1714113

    Now new QMS is able to manage all services on old machine except QVS.

    status = running
    DSC@old_server
    LicenseService@old_server
    QDS@old_server
    QVWS@old_server
    QMS@new_server 

    status = disconnected
    QVS@old_server 

    I've check port 4747 in both directions - telnet makes contact. I was able to create a task with the new QMS and distribute on QVS@old_server.  However, when I've added another QVS as QVS@new_server and created a task to distribute there, then distribution failed as QVS@new_server was not available.

    Somehow connections QMS@new_server -> QDS@old_server -> QVS@new_server do not work.
    Can you help with this?

    Show Less
  • forum

    Qlik Compose for Data Lakes

    Duplicate Data: CloudPostgreSQL --> Datastream --> BigQuery

    I have a basic pipeline setup where I use Python to scrape data from the web, push to a SQL server, use Google Datastream to replicate it in Big query... Show More

    I have a basic pipeline setup where I use Python to scrape data from the web, push to a SQL server, use Google Datastream to replicate it in Big query, so I can efficiently consume it in other apps.

    My issue that is that I am accumulating duplicates in my Big query tables. I actually know whats causing this, but don't have a good solution. When I update my SQL Tables, I truncate them, and append a new set of data to updata to the table. I have to do this because Datastream cant interface with SQL views.

    Big query isn't mirroring the SQL Tables. Data stream is taking my appended data, and simply adding it to my Bigquery Tables, instead of mirroring my SQL tables 1:1

    How can I get Big query to reflect these tables Exactly??

    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

    QlikView App Dev

    Unable to Fire Macros

    I wrote the below Macro code using VBScript  I know the code is correct. Anytime I press the button attached to macro on my system instead of the scri... Show More

    I wrote the below Macro code using VBScript  I know the code is correct. Anytime I press the button attached to macro on my system instead of the script to fire it was reopening the macro editor. please, what can I do apart from changing module security to system access in which I did but it is not running. 

    Sub HideTabRow
    Set DocProp = ActiveDocument.GetProperties
    DocProp.ShowTabRow=False
    ActiveDocument.SetProperties DocuProp
    End Sub

    Sub ShowTabRow
    Set DocProp = ActiveDocument.GetProperties
    DocProp.ShowTabRow=True
    ActiveDocument.SetProperties DocuProp
    End Sub

     

    Show Less
  • forum

    App Development

    How to Find Repeated case based on certain condition

    Hi, I have a scenario where I want to tagged a policy with a remark "Case_Repeated" if same policy was logged after previous call resolved <= 56 days.... Show More

    Hi,

    I have a scenario where I want to tagged a policy with a remark "Case_Repeated" if same policy was logged after previous call resolved <= 56 days. e.g. is given below.

    Policy_No Call Logged date Call Resolved date Token_no Repeted_Remark
    123457 12-Mar-23 17-Mar-23 A_123  
    456789 17-Apr-23 20-Apr-23 B_124  
    123457 12-May-23 17-May-23 A_126 Case_Repeated
    456789 19-Jun-23 12-Jul-23 B_123  
    123457 21-Jun-23 25-Jun-23 A_129 Case_Repeated
    456789 26-Aug-23 31-Aug-23 B_127 Case_Repeated
    123457 12-Dec-23 01-Feb-24 C_124  
    234567 09-Feb-24 15-Feb-24 d_123  

     

    Thanks in advance

    @marcus_sommer 

    @swuehl 

    @Anil_Babu_Samineni 

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