Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 214,359 members
  • 6,326 online
  • 1,989,635 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

    Generate .meta and .shared

    Hi every one , i developped a qlikview file .qvw in the server  and i want to share  to be visible for users , it  how i can do it , Thanks    Show More

    Hi every one ,

    i developped a qlikview file .qvw in the server  and i want to share  to be visible for users , it  how i can do it ,

    Thanks 

     

    Show Less
  • forum

    New to Qlik Analytics

    Aggregation in Edit Script different then GUI

    Hi Community, I have given below data set:   Date Periods Franchise Country Orders_Numbers 01.01.2022 1 Burger USA 101 01.01.2022 2 Burger Cana... Show More

    Hi Community,

    I have given below data set:

     

    Date Periods Franchise Country Orders_Numbers
    01.01.2022 1 Burger USA 101
    01.01.2022 2 Burger Canada 101
    01.01.2022 3 Burger Australia 101
    01.01.2022 4 Burger France 102
    01.01.2022 5 Burger Spain 102
    01.01.2022 6 Burger Italy 102

     

    If I write Expression in the GUI: Count(DISTINCT Orders_Numbers) then I'll get 1 for the Orders_Numbers = 101 whenver I'll select / deselect any dimension on the GUI. If I'll clear all the dimensions then I'll get 2. One for each Orders_Numbers due to Count(DISTINCT Order_Numbers).

    I want to achieve the same results using Edit Script. How to do it ? I don't want to remove any dimension Filter from the GUI.

    I tried this solutions to achieve the same results but the problem is I got 3 for the Orders_Numbers = 101. Becaue the %Key has a unique Periods in the %Key that makes it unique while I count on the GUI then it returns me the 3 not one due to the %Key. If I write DISTINCT in the Expression then I'll always get 1 for all the data set.

    Do I need to change the expression after the below load edit script or what is the right way to do it ?

     

    NoConcatenate
    Fact:
    LOAD 
    Date & Periods & Franchise & Country as %Key
    Date,
    Periods,
    Franchise,
    Country,
    Orders_Numbers
    FROM
    [Fact_Table.qvd] (qvd);
     
    NoConcatenate
    Fact_Aggregation:
    LOAD %Key,
         Count(DISTINCT Orders_Numbers) as Orders_Numbers_DISTINCT_Count
    Resident Fact
    Group By
    %Key
    ;
     
    Expression: Sum(Orders_Numbers_DISTINCT_Count)
    Show Less
  • forum

    Move to SaaS

    Saas readiness app without cloud tenant

    We have a client considering a move to saas, so I downloaded the qlik sense migration app. Unfortunatly you need a cloud tenant to to the check. Older... Show More

    We have a client considering a move to saas, so I downloaded the qlik sense migration app. Unfortunatly you need a cloud tenant to to the check. Older versions are without this connection to cloud.
    Does anyone have an older version of the cloud Readiness app? One without the connection to cloud?

    Kind regards,

    Isabelle

     

     

    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

    Qlik Compose for Data Warehouses

    converting data type from string to data and time

    Hello everyone, in qlik sense I have a timestamp in a string format and I need to convert it into a date and time with e specific format. the idea is ... Show More

    Hello everyone,

    in qlik sense

    I have a timestamp in a string format and I need to convert it into a date and time with e specific format.

    the idea is to be able to create a calendar or extracts month.week...etc from that field, which is not possible when it's a string

     

    Show Less
  • forum

    New to Qlik Analytics

    Trying to add values to Null

    Hi,  I have many cases in my data where the question asked essentially is:  if value () doesnt appear // does appear in this table then 'Yes' else 'No... Show More

    Hi, 

    I have many cases in my data where the question asked essentially is: 

    if value () doesnt appear // does appear in this table then 'Yes' else 'No'

    this simple formula is proving very challenging to do without creating synthetic keys. 

    Is there an easy one line formula you are able to slot into the actual table in the load editor that would solve this. For example:

    Load

    *,

    If......'yes','no

    from File

     

    Please help 

    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

    Darshan Hiranandani : How do I test my app before launching it to the public?

    Hii, I'm Darshan Hiranandani, How do you suggest testing an app before launching it to the public? I'm interested in hearing your insights and recomme... Show More

    Hii, I'm Darshan Hiranandani, How do you suggest testing an app before launching it to the public? I'm interested in hearing your insights and recommendations.

    Show Less
  • forum

    New to Qlik Analytics

    How to create drop down menu for filter pane

    Hi all, I'm very new to Qlik Sense and still didn't get how to use this software. I'd like to ask a question, which would be a very basic question for... Show More
    Hi all, I'm very new to Qlik Sense and still didn't get how to use this software. I'd like to ask a question, which would be a very basic question for you the experts: How to make a filter pane become a drop-down-single-selection filter pane? The current visualization and the expected result are attached. Thanks. Show Less
  • forum

    New to Qlik Analytics

    Top N

    I have been following the Top N the example on YouTube, but I guess I lost.   While the example only looks at Brand and Sales In my example. I group F... Show More

    I have been following the Top N the example on YouTube, but I guess I lost.

     

    While the example only looks at Brand and Sales

    In my example. I group Function, Name on Sales

    When I do the of

     

    Rank(Sum(Sales), Function, Name)<=10

    It tested for -1 and 0. -1 means the Sales falls within the Top 10

    However, when I try to bring the actual result so I can use variable input, it does not work.

    This is what I am using to try to filter the column for only the Top 10

    Sum(

    {<

    Function, Name={“= Rank(Sum(Sales), Function, Name)<=10

    ”}

    >}

    Sales)

     

    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!