Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 225,003 members
  • 4,064 online
  • 2,006,733 posts
  • 150,544 Solutions
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    How to affect visualisaiton with Filters

    Hi, I have two different tables from where i get data: Table 1 - has Location (ex. London, Paris etc) and Name of individuals Table 2 - has Site (ex. ... Show More

    Hi, I have two different tables from where i get data:

    Table 1 - has Location (ex. London, Paris etc) and Name of individuals

    Table 2 - has Site (ex. London, Paris etc) and Views

    I want to keep Location and Site as separate parameters. I have created a simple visualisation table using the 4 attributes as above - Location - Name - Site - Sum of views 

    I have also created a filter on Site, however when i select a particular site, i want the above table to update using the value in the Location column as opposed to Site column. How do i achieve this ?

    Thanks for any insights,

    Show Less
  • forum

    Administering and Monitoring

    Schedule talend jobs in azure data factory ADF

    Hello  I have differents talend job that are being triggered and scheduled using TMC.   I need to scheduled them in azure data factory, do you have an... Show More

    Hello 

    I have differents talend job that are being triggered and scheduled using TMC.

     

    I need to scheduled them in azure data factory, do you have any idea on how to do so ?

    Regards 

    Show Less
  • forum

    App Development

    Creating a KPI

    Hello!Could you help me to calculate the value for KPI widget: I have 3 sections and for each, I have a total kpi in tons stored per date.  I want to ... Show More

    Hello!

    Could you help me to calculate the value for KPI widget:

    I have 3 sections and for each, I have a total kpi in tons stored per date.

     
    I want to have one KPI widget, which will show:

    - the total weight

    - for a selected Section

    - and only for a Current year

    - even if there are filters applied for a particular month/date. 

    mariam_vd_0-1720712795588.png

    Do you have an idea of how to achieve it?

    Show Less
  • forum

    QlikView App Dev

    Load row by row in a loop while modifying a variable

    Hi,I need to do an elavorated load with a loop to generate data based on variables that need to be updated in each iteration.i have a table with ids a... Show More

    Hi,
    I need to do an elavorated load with a loop to generate data based on variables that need to be updated in each iteration.
    i have a table with ids and Amounts
    Table A:

    Sup_ID Tota_Amount
    id1 $$$
    id2 $$$
    id3 $$$

    that represents a supplier id and a total amount of debt to that supplier.

    Then i have a second table with receipts:
    Table B:

    Date Sup_ID Rec_Amount
    XX/XX/XXXX id1 $$
    XX/XX/XXXX id2 $$
    XX/XX/XXXX id2 $$


    but this table doesn't know how much of the total debt corresponds to each receipt, so the idea is to make an algoritm that asumming the receipts are ordered by date, from newest to oldest, put flags on the receipts marking them as debts or paids, making the older ones paid if there is no enough debt, or in other words, that older debt is paid.

    the algortim itself is something like:

    for each supplier:

    for each receipt (pre-ordered):

    if (Total_Amount >0)

    if(Rec_Amount <= Total_Amount)

    Total_Amount= Total Amount - Rec_Amount
    flag= 'debt'
    //Now i know that this receipt is not paid yet, and substract it from the Total_amount

    else

    Rec_Amount= Total_Amount
    Total_Amount=0
    flag= 'debt'
    //This one is partially paid, that can happen, one receipt can have multiple payments. So the debt is the remaining Total_Amount after all the newer ones are marked as 100% debt.

    So. I tryed to make a load script with this idea:

    FOR i=1 to NoOfRows('Table_A')
    let Id_Supp= Peek('Sup_ID','$(i)','Table_A');
    let Debt_Supp= Peek('Total_Amount','$(i)','Table_A');
    DO WHILE Debt_Supp> 0
    load ... Resident Table_B where Sup_ID = '$(Id_Supp)' Order by Date
    loop
    next i

    And here is the problem, i can't load rows one by one from Table_B and modify Debt_Supp at the same time.

     
    Show Less
  • forum

    GeoAnalytics

    alguien ha trabajado geohash?

    ¿Alguien ha trabajado geohash?
  • forum

    Integration, Extension & APIs

    Error when Installing Data Gateway

    I am installing QLIK Data Gateway on a Windows 2019 Server. However, getting the following error:-  I have a attached the logs generated from perform... Show More

    I am installing QLIK Data Gateway on a Windows 2019 Server. However, getting the following error:- 

    qlikDataGatewayErrorInstall.png

    I have a attached the logs generated from performing installation.

    Show Less
  • forum

    App Development

    what is the first video training you would give BI developers?

    Many of the Qlik videos use features we don't currently use; I am looking for a "BI developer-oriented" introduction that would focus on the load scri... Show More

    Many of the Qlik videos use features we don't currently use; I am looking for a "BI developer-oriented" introduction that would focus on the load script and NOT encourage users to use the data manager or upload attachments. Users are proficient in SQL and need to learn how to use the Qlik load script to execute their stored procedures or queries they have written and bring those into a data model. Some of the main "adjustments" they will need to comprehend are:

    1) the associative model and considerations like the need to rename columns to avoid synthetic keys and how to create concatenated keys, and a context for using the data model viewer to understand what is being loaded.

    2) the idea of a master calendar and how this can make reporting easier

    3) judicious use of preceding load, what Qlik joins are vs SQL, ApplyMap(), and what concatenate means for Qlik vs say union all in SQL

    4) the concept of dimensions, measures, and fields for visualization/charts

    The main thing I want to avoid is the generic overview videos that encourage users to do "low code" work that creates a lot of backend refactoring work for the team. Developers will need to get the basics of qlik and quickly  move on to concepts like set analysis so they can create expressions on charts, but that is a huge leap. Definintely don't need any AI or Insights, etc. Basically, I am looking to replicate the course I took a decade ago for QlikView Advanced Developer training but for QlikSense and deliver it to a team of Tableau developers so they can learn Qlik development quickly.

    Nothing against the cool new capabilities of QlikSense, but these BI developers need to learn what's under the hood first so they can build and modify applications being used by end users and migrate a lot of Tableau dashboards that need to be repurposed for Qlik.

    Show Less
  • forum

    Deployment & Management

    what role is required to publish from my sheets to community

    what role does a user need in order to be able to publish from my sheets they have created in an app so the sheet can be accessed by others? I don't w... Show More

    what role does a user need in order to be able to publish from my sheets they have created in an app so the sheet can be accessed by others? I don't want to give them ability to publish apps or modify any base sheets, but as a user with no elevated role, I do not have publish in the right click menu.

    Show Less
  • forum

    App Development

    Create a Three-Level Hierarchy based on Two Columns

    Hi everyone, I am trying to create a Qlik hierarchy based on two columns I have in an Excel file. One column, which is level 1, has the name of all th... Show More

    Hi everyone,

    I am trying to create a Qlik hierarchy based on two columns I have in an Excel file. One column, which is level 1, has the name of all the chief executives in the company and the second one, level 2, has all the people who report to those chiefs. However, there is also a third level in which a person that appears in column two can also appear in column one under the role of chief and have people who report to that person. As an example, I have attached a hierarchy diagram for further clarification of the use case.

    rolmontero_0-1720802827500.png

    Could anyone help me or shed some light of how to solve this?

     

    Thanks a lot!

    Show Less
  • forum

    New to Qlik Analytics

    Upgrade from Nov 2020 release to May 2024 release

    We have Qlik Sense Enterprise on Windows, all installed on one Windows 2012R2 server. We would like to upgrade to the latest release May 2024. The May... Show More

    We have Qlik Sense Enterprise on Windows, all installed on one Windows 2012R2 server. We would like to upgrade to the latest release May 2024.

    The May 2024 release requires Windows 2016 and later.

    In this case, what would be the best upgrade path or steps?

    Thanks for the help!

    Show Less
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

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!