Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,309 members
  • 5,271 online
  • 1,991,632 posts
  • 149,201 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

    App Development

    Matching in Script, based on count()

    Hi everyone, i have a small logic problem matching 2 fields based on their count amount. i have managed to get the required result, using the set anal... Show More

    Hi everyone,

    i have a small logic problem matching 2 fields based on their count amount. i have managed to get the required result, using the set analysis, but this is not working as expected when i want to filter, based on this result field.

    So, consider having the following Table:

    CreditorNr | Type | BankNr

    010001     | 200   | 12345200

    010001     | 200   | 12345200

    010001     | 200   | 12345200

    010001     | 200   | 12345100

    010001     | 100   | 12345100

    Using the following formula, i obtained the following MatchField:

    =aggr(If(
    Count(Distinct Type ) = 1 and
    Count(Distinct BankNr) = 1, 'Partner bank is clear', 'Partner bank is not clear'), CreditorNr , BankNr)

    i get following results, that are also correct:

    CreditorNr | Type | BankNr       | MatchField

    010001     | 200   | 12345200   | Partner bank is clear

    010001     | 200   | 12345200   | Partner bank is clear

    010001     | 200   | 12345200   | Partner bank is clear

    010001     | 200   | 12345100   | Partner bank is not clear

    010001     | 100   | 12345100   | Partner bank is not clear

     

    Anyway, when trying to implement this in the Script, i dont get the correct result. In the Script i use the following code:

    TEMP:
    NoConcatenate
    Load CreditorNr,
    If(Count(Distinct Type) = 1 and
    Count(Distinct BankNr) = 1, 'Partner bank is clear', 'Partner bank is not clear') as ScriptMatch
    Resident BankTab
    Group by CreditorNr, BankNr;

    And i get the following result:

    CreditorNr | Type | BankNr       | MatchField                        | ScriptMatch

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is clear

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is not clear

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is clear

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is not clear

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is clear

    010001     | 200   | 12345200   | Partner bank is clear         | Partner bank is not clear

    010001     | 200   | 12345100   | Partner bank is not clear   | Partner bank is clear

    010001     | 200   | 12345100   | Partner bank is not clear   | Partner bank is not clear

    010001     | 100   | 12345100   | Partner bank is not clear   | Partner bank is clear

    010001     | 100   | 12345100   | Partner bank is not clear   | Partner bank is not clear

    So it basically goes through every BankNr and duplicates the data, once bank is clear, and once bank is not clear... 

    Can anyone please give me a hint on what im i doing wrong in the script?


    Thank you for the support. 🙂

    Show Less
  • forum

    App Development

    Automatic Storytelling in Qlik Sense

    Hello!I am trying to create some reports in Qlik Sense using the Stories functionality. Is there any way that I am able to automatically update the re... Show More

    Hello!

    I am trying to create some reports in Qlik Sense using the Stories functionality.

    Is there any way that I am able to automatically update the reports?

    I mean, I create some screenshots and stories in my dashboard, and I would like to have a report with the same tables and graphs each 2 weeks. Is it possible to get the information updated, or should I create the snapshots every time I want to see them?

    Thank you in advance!

    Show Less
  • forum

    New to Qlik Analytics

    Comment faire un slider qui prend en compte des tranches (plages) de données ?

    Bonjour, Comment faire un slider qui prend en compte des tranches (plages) de données comme sur QlikView ? Y a-t-il une extension autre que celle du ... Show More

    Bonjour,

    Comment faire un slider qui prend en compte des tranches (plages) de données comme sur QlikView ?

    Wal_Riachi_0-1711627489018.png

    Y a-t-il une extension autre que celle du bundle ? Car celle du bundle permet de sélectionner qu'une seule valeur.

    Merci d'avance,

    Waïl

     

    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

    New to Qlik Analytics

    Previous Year YTD AND QTD based on Current date

    Hi all, I need your assistance with the calculation of Previous Year YTD and QTD. Based on the current date, the same date should be used for both the... Show More

    Hi all,

    I need your assistance with the calculation of Previous Year YTD and QTD. Based on the current date, the same date should be used for both the previous YTD and QTD calculations. Below is my logic, but I'm unable to crack it.

    previous year YTD:
    Sum({<
    [Fiscal Year] = {"$(vPrevFY)"}, // eg..2023  
    [Date]={"<= $(=Date(Today() - 1))"}  // date should be based on max date of current year if max date of current year is 03/25/2024 then I want to calculate previous year YTD till   03/25/2023 instead of full year
    >} Sales)

    previous year QTD:
    Sum({<
    [Fiscal Year] = {"$(vPrevFY)"}, // eg..2023
    [Fiscal Quarter Num] = {"$(vPrevYearsameFQtrNum)"}, //eg...2023 Q2 however this will in number format
    [Date]={"<= $(=Date(Today() - 1))"}  // eg,, date should be based on max date of current year if max date of current year is 03/25/2024 then I want to calculate previous year QTD  till   03/25/2023 instead of full Quarter
    >} Sales)
     

    Your assistance would be greatly appreciated....

     

     

    Show Less
  • forum

    QlikView App Dev

    Force 0 on Continuous line chart when expression is Avg( )

    Hi all, I have a line chart over a continuous x-axis that I want to drop to zero when no data exists for that time value.If my query is a SUM, then th... Show More

    Hi all,

    I have a line chart over a continuous x-axis that I want to drop to zero when no data exists for that time value.

    If my query is a SUM, then this is fine by using  + SUM({1}0) 

    My problem is that for this chart I am using an AVG function.

    I've tried +AVG({1}0) but this didn't work. 

    Has anyone found a solution to this problem before?

     

    Show Less
  • forum

    Qlik Replicate

    Connection Dataproc

    Bonjour,  Je n'arrive pas a me connecté au cluster Dataproc depuis Qlik replicate.  Erreur veut dire que l'adresse host et le numéro du port  pour se... Show More

    Bonjour, 

    Je n'arrive pas a me connecté au cluster Dataproc depuis Qlik replicate. 

    ELHARRAS_0-1711467658369.png

    Erreur veut dire que l'adresse host et le numéro du port  pour se connecter à Hive qui bloque par contre la config pour le cloud Storage est OK . 

    Cordialement.

    Cordialement. 

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

    Qlik NPrinting

    Incorrect Kpi Value In Nprinting

    Hi, I have created one KPi where it has some value and its changing based on that selections applied. Now in qlik sense if we apply the cycle for the ... Show More

    Hi,

    I have created one KPi where it has some value and its changing based on that selections applied.

    Now in qlik sense if we apply the cycle for the same filed selections then the value is showing wrong or showing value and so on.

    For example if value is showing as 2 in Qlik sense kpi, then the same kpi is showing as 2.13333333333333 in Nprinting pixel perfect report generated.

    any suggestions would be appreciated. 

     

     

    Raju_6952_1-1711623882494.png

     

     

     

    Show Less
  • forum

    Design and Development

    Issue upserting with parent record tSalesforceOutputBulkExec

    Hello Everyone, I have a requirement to upsert a list of contacts with an external id (LP_ExternalContactId__c) and also need to relate to the account... Show More

    Hello Everyone,

    I have a requirement to upsert a list of contacts with an external id (LP_ExternalContactId__c) and also need to relate to the account with another external id (LP_ExternalClientId__c). I am using tSalesforceOutputBulkExec (Bulk API V1) for this as I have to do a retry mechanism on failure. So the first try is in Parallel concurrency mode with a bigger batch size and the retry in serial mode with a smaller batch size. Now that the reject file populated is having the parent external id value as blank. For this reason, my retry job loads all the contacts without the account ids for the ones that are failing where account is not present. It populates the parent external id value in the reject file if I enable Bulk API V2, but I cannot use V2 as it doesn't allow us to select the concurrency mode and batch size. Below are some of the screenshots. Any help would be appreciated.

    nidhin_san_0-1711624764417.png

    nidhin_san_4-1711624907882.png

     

    nidhin_san_5-1711624928880.png

     

    Its a very common scenario, but I have spend more than a day with it finding the root cause.

    Version used

    nidhin_san_0-1711625388092.png

     

    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!