Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 214,334 members
  • 6,716 online
  • 1,989,567 posts
  • 149,024 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

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

    Displaying the Planning event Values in Column level

    Hi, I have Pivot table with full of dimensions and i have one particular field which is Planing Event which i need to show the values as a column leve... Show More

    Hi, I have Pivot table with full of dimensions and i have one particular field which is Planing Event which i need to show the values as a column level in that for Particular Planning event names i wanted to to display only Cascaded Entry Date.

    Show Less
  • forum

    App Development

    Create fiscal year calendar in Qliksense

    Hello , I want to create a fiscal year master calendar and I have used the below script :- //-- Fiscal year Mastr Calendar---// QuartersMap:MAPPING LO... Show More

    Hello ,

    I want to create a fiscal year master calendar and I have used the below script :-

    //-- Fiscal year Mastr Calendar---//

    QuartersMap:
    MAPPING LOAD
    rowno() as Month,
    'Q' & Ceil (rowno()/3) as Quarter
    AUTOGENERATE (12);
    Temp:
    Load
    min(EMLC_OK_DATE) as minDate,
    max(EMLC_OK_DATE) as maxDate
    Resident ZZ_FF_BUILD_DETAIL_DAILY;
    Let varMinDate = Num(Peek('minDate', 0, 'Temp'));
    Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));
    DROP Table Temp;
    TempCalendar:
    LOAD
    $(varMinDate) + Iterno()-1 As Num,
    Date($(varMinDate) + IterNo() - 1) as TempDate
    AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);
    MasterCalendar:
    Load
    TempDate AS EMLC_OK_DATE,
    week(TempDate) As RFS_Fiscal_Week,
    Year(TempDate) As RFS_Fiscal_Year,
    Month(TempDate) As RFS_Foscal_Month,
    Day(TempDate) As Day,
    // YeartoDate(TempDate)*-1 as CurYTDFlag,
    //YeartoDate(TempDate,-1)*-1 as LastYTDFlag,
    inyear(TempDate, Monthstart($(varMaxDate)),-1) as RC12,
    date(monthstart(TempDate), 'MMM-YYYY') as RFS_Fiscal_MonthYear,
    ApplyMap('QuartersMap', month(TempDate), Null()) as RFS_Fiscal_Quarter,
    Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as RFS_Fiscal_WeekYear,
    QuarterName(AddMonths(TempDate,3)) as RFS_Fiscal_QuarterName,
    WeekDay(TempDate) as RFS_Fiscal_WeekDay
    Resident TempCalendar
    Order By TempDate ASC;
    Drop Table TempCalendar;

    exit script;

    //==============================//

    But I am not getting the proper output. Please see below :-

    Aspiring_Developer_0-1710776674163.png

    Not sure, what mistake I made in the above script. Can anyone please help me ?

    Thanks in advance

    @sunny_talwar 

    Show Less
  • forum

    New to Qlik Analytics

    Change mesures name in a pivot table

    Hello , I have a pivot table with: Dimension: Matricule , Nom Column: Type( Frais or Gain) Mesures : GH,GM,SIP i want to change  the name of the mesu... Show More

    Hello ,

    I have a pivot table with:

    Dimension: Matricule , Nom

    Column: Type( Frais or Gain)

    Mesures : GH,GM,SIP

    RanMH_0-1710771378490.png

    i want to change  the name of the mesures based on the value of the column "Type"

    Exemple If Type='Gain' and mesure = GH then the mesure name will be "Gain GH"

    RanMH_1-1710771462274.png

    I used this formula as a name of the mesure : if(wildmatch(Type,'Gain'),'Gain GH', 'Frais GH') but it's not working it gives the same value everywhere 

    Is there a way to do this ?

    Thank you in advance.

     

     

     

    Show Less
  • forum

    Deployment & Management

    Create new Qlik Sense Users by consuming API endpoint

    Hi thereI was wondering whether it is possible to populate Qlik Sense Users by reading a REST API endpoint? We have an application in which we have us... Show More

    Hi there

    I was wondering whether it is possible to populate Qlik Sense Users by reading a REST API endpoint? We have an application in which we have users, but we would like to give some of the users access to Qlik Sense. We can expose the user details (ID, Name and Attributes) using a REST API endpoint, but I am not sure if we will be able to create those users in Qlik Sense? The plan is to use the application together with a certificate to get tickets for these users, but I assume that we need to have the users available in Qlik Sense first (we want to use certain rules based on attributes).

    The alternative we are considering is to have a Qlik Sense App consume that REST API and then writing the details to an Excel file which is the source of a Qlik Sense UD connector, but we would like to cut out the QS app and Excel file if possible (seems like we are creating unnecessary steps in the process).

    Please let me know if anyone has done something like this or if you have any suggestions.

    Regards,

    Mauritz

    Update: My Excel plan won't work as I cannot write/store data into an Excel file. Now I REALLY need suggestions 😉

    @Levi_Turner @Gysbert_Wassenaar @rwunderlich 

    Show Less
  • forum

    App Development

    Qliksense ODAG - analyzer users

    Hello,I would like to know if there are any restrictions for user with an analyzer license to use an ODAG applications. If it is so, can you please al... Show More

    Hello,
    I would like to know if there are any restrictions for user with an analyzer license to use an ODAG applications. If it is so, can you please also explain which are these limits?
    Thank you in advance
    Sara 

    Show Less
  • forum

    Design and Development

    How to import 3rd party library when jar file cannot be downloaded

    Hello, I'd like to use Aspose.total or Aspose.words in a talend job.  Previously when we needed some third party jars (AWS secrets manager related), w... Show More

    Hello, I'd like to use Aspose.total or Aspose.words in a talend job.  Previously when we needed some third party jars (AWS secrets manager related), we downloaded the jars manually from mvnrepository.  

    However, in this case I don't see any jar files on the Aspose website or on mvnrepository.  I only see the xml for the pom.xml. See below. 

    <dependency> <groupId>com.aspose</groupId> <artifactId>aspose-words</artifactId> <version>24.2</version> </dependency>

    Do I need to manually insert that xml into the talend pom.xml?   The tLibraryLoad component seems to assume that you have access to the physical jar file, which I don't have.  

    I'm a decent talend developer, but I don't have much experience with third party libraries. 

    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!