Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,355 members
  • 4,833 online
  • 1,991,712 posts
  • 149,208 Solutions
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    IF Statements Help

    I'm currently working on the data load using IF statements below but keep getting an error for line 3 & 4. Can someone help point out what I'm doing w... Show More

    I'm currently working on the data load using IF statements below but keep getting an error for line 3 & 4. Can someone help point out what I'm doing wrong? I've included the sample data attached for reference of what I want as an outcome. Thank you in advance.

    1: date(CREATED_DATE, 'MM/DD/YYYY') as [Date Opened],

    2: STATUS_C as [Status],

    3: if([STATUS_C]= 'Closed', 'Closed','Open') as [Status Flag],

    4: If ([STATUS_C] ='Open',today()-Created Date as [Days Aged from Open Date],

    5: If ([STATUS_C] ='Open',If( [Days Aged] >= 0 and [Days Aged] < 90, replace( class([Days Aged],30),'<= x <','-') & ' Days', If( [Days Aged] >= 90, '90 Days+'))) as [Open Timeframe],

    kimdiep503_0-1711473433831.png

     

    Show Less
  • forum

    New to Qlik Analytics

    Combining if into set analysis

    Hi all, below is a snapshot of my data which starts in Jan 1st 2023.  I wish find total using set analysis with the following criteria: 1. If(Actual >... Show More

    Hi all, below is a snapshot of my data which starts in Jan 1st 2023.  I wish find total using set analysis with the following criteria:

    1. If(Actual > Planned, Actual, Planned) and

    2. Between Monday and Friday.  Therefore, the correct total planned would be 11.

    I don't wish to create a new variable or using the load editor.

     

    Jobid Date Day Planned Widgets Actual Widgets if Actual > Planned,Actual,Planned
    1 18-Mar-24 Mon 0 1 1
    2 19-Mar-24 Tue 2 2 2
    3 20-Mar-24 Wed 2 1 2
    4 21-Mar-24 Thu 1 1 1
    5 21-Mar-24 Thu 0 1 1
    6 22-Mar-24 Fri 2 2 2
    7 22-Mar-24 Fri 2 2 2
    8 23-Mar-24 Sat 2 2 2
    9 24-Mar-24 Sun 2 2 2
          13 14 15
               
        Mon to Fri 9 10 11

     

     

    Show Less
  • forum

    Japan

    QlikSenseでテーブル形式で出した値を行ごとにコピー&ペーストしたいです

    QlikSenseのシート上にテーブルを表示しましたが、QlikSenseのシート上で書き込みや編集ができないため、テーブルの行ごとにエクセルにコピペして編集したいです。1セルごとにコピペが可能というのは知っていますが、行ごとや複数セルを選択して一括でコピペできるのでしょうか?
  • forum

    App Development

    How to use a value in the resultant row to calculate the value in the next row i...

    Hello, I am trying to create a table in Qlik Sense which is similar to the one below. But I am unable to do it because I cannot pick previous value fr... Show More

    Hello,

    I am trying to create a table in Qlik Sense which is similar to the one below. But I am unable to do it because I cannot pick previous value from the resultant row and use it to calulate the next value in the same column.

    Table:

    Apoorva_sd_1-1711592844033.png

     

     

    In the above table, Availability is what I am trying to calculate. Formula for that would be "Column A-Column B" for priority 1 which will be 30 hours here for project 1. Then for priority 2, Result will be 30-3=27 i.e., Total Reult hours minus the hours required for 1st priority project. Then for the 3rd priority it will be 27-1=26 and so on. Question is how to use the value from resultant (Result) column to calculate the value for next row in the same column. Is there a function for this? 

    Thank you,

    Apoorva.

                 

     

    Show Less
  • forum

    New to Qlik Analytics

    Link table for accounting data in OLE DB data and budget data from Excel File

    Hi, I have a problem where I need to get Transaction data from a OLE DB data source and then add en Excel file with manually entered Budget data for f... Show More

    Hi,

    I have a problem where I need to get Transaction data from a OLE DB data source and then add en Excel file with manually entered Budget data for four different companies, the load data look like this compressed with the relevant fields for two of the companies as below.

    I add the company name as Client field for every company and the joined data for Transactions table is working as supposed.

    My problem is that the budget data is added on the last day of the month because it's mainly relevant to look at this aggregated per month. But since there are multiple transactions in the Transaction data the last day of the month every month the Budget data get multiplied for every occurrence of that date.

    What I've found is that I should use a Link table to solve this issue but it seems that my skills is not enough to get the script right.

    I would like to group interval of accounts for example revenue, material cost, gross profit etc. for set analysis and add a master calendar (or similar) to do analysis on different time periods. Is it possible to have a Link table for Client, account and date fields and then add grouping and master calendar connected in the Link table or do you have to do this in the Load for the original data sources?

    LIB CONNECT TO 'Briljantdata - MGA (ad_ext_kons)';
     
    Transactions:
     
    LOAD 
     
    'MGA' as Client,
        bel, // (amount field)
        kto, // (Account field)
        trdat; // (Date field)
    SQL SELECT
        bel,
        kto,
        trdat
    FROM rtr;
     
     
    LIB CONNECT TO 'Briljantdata KJ (ad_ext_kons)';
     
    join(Transactions)
    LOAD
    'KJ' as Client,
        bel, // (amount field)
        kto, // (Account field)
        trdat; // (Date field)
    SQL SELECT
        bel,
        kto,
        trdat
    FROM rtr;
     
    LOAD
    'MGA' as Client,
        kto, // (Account field)
        trdat, // (Date field)
        Budget_belopp // (Amount field)
    FROM [lib://AttachedFiles/Qlik sense Budget MGA 22-23 & 23-24.xlsx]
    (ooxml, embedded labels, table is Budgetdata_MGA);
     
    LOAD
    'KJ' as Client,
        kto, // (Account field)
        trdat, // (Date field)
        Budget_belopp // (Amount field)
    FROM [lib://AttachedFiles/Qlik sense Budget KJ 22-23 & 23-24.xlsx]
    (ooxml, embedded labels, table is Budgetdata_KJ);
     
    Help is much appreciated!
    Show Less
  • forum

    Qlik Application Automation

    "Do lookup" not working on Add a Chart to Report block

    hi, I am using Add a Chart to Report block and when I try to find the object using "do lookup". It doesnt find my object. The object is in a published... Show More

    hi,

    I am using Add a Chart to Report block and when I try to find the object using "do lookup". It doesnt find my object.

    The object is in a published sheet and I also got the object id using /options/developer mode.

    Any clue about that?

    Thanks in advance

    suggestion: maybe this block should first select the sheet and then do a lookup on the elements inside the selected sheet. Because there are lots os elements in the app, so the lookup takes too long

    Show Less
  • forum

    Catalog and Lineage

    Anyone used Qlik sense?

    My new role requires using Qlik sense, does anyone have any experience with it? I had used PowerBI and Tableau before, would that help?
  • forum

    App Development

    Sumar el total de una Medida

    Hola comunidad! Quisiera saber si esto es posible....En Qlik Sense Tengo una medida llamada HORAS ADMINISTRATIVAS la cual me funciona perfectamente en... Show More

    Hola comunidad!

    Quisiera saber si esto es posible....En Qlik Sense

    Tengo una medida llamada HORAS ADMINISTRATIVAS la cual me funciona perfectamente en una tabla.

    Pero resulta que quiero sumar todas las horas administrativas que se muestran en esa tabla y mostrarlo en otra tabla diferente.

    Intenté crear una nueva medida y en la expresión coloqué algo como SUM([HORAS ADMINISTRATIVAS]), pero recibo un mensaje de "Error en la expresión SUM([HORAS ADMINISTRATIVAS])"

    Fuí a la medida original y lo puse como tipo Número de formato simple "1,000".

    Pero sigo sin tener éxito.

    Agradeceré infinitamente su ayuda!

     

    Show Less
  • forum

    App Development

    Como obtener días habiles contando sabados y/o domingos

    Para un tema de calculo de presupuestos de ventas necesitamos poder contar los días de mes en que abren las tiendas (hay ventas) y descontar algunos f... Show More

    Para un tema de calculo de presupuestos de ventas necesitamos poder contar los días de mes en que abren las tiendas (hay ventas) y descontar algunos festivos. Estos pueden ser incluso sábados o domingos, dependiendo de la tienda. Esta función es (casi) ideal:

    networkdays (start_date, end_date [, holiday])

    Sólo que cuenta los días de lunes a viernes. Lo ideal fuera que existiera esta misma función contando TODOS los días del mes y a través de la opción de [holiday] pudiéramos descontar los sábados, o domingos, o festivos no laborados. Saben si existe o si hay otra opción para hacerlo?

    Mil gracias de antemano.

    Show Less
  • forum

    Qlik Cloud Data Integration

    Can't install Qlik Sense Entensions on Qlik Cloud

    The extensions used in qlik sense on premise can't install on Qlik Cloud. It shows a message like "Invalid File". The extension is this:   Can anyone... Show More

    The extensions used in qlik sense on premise can't install on Qlik Cloud. It shows a message like "Invalid File". The extension is this:

    ironwill_1-1711571885079.png

     

    Can anyone help me please?

    Regards,

    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!