Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 219,961 members
  • 3,070 online
  • 1,999,181 posts
  • 149,891 Solutions
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    Straight Table grouping data

    I Need a Straight table to display like this. Product_Name Yr_2023 Yr_2024     sticks 500 700 <--- sales bats 200 150       I have the data ... Show More

    I Need a Straight table to display like this.

    Product_Name Yr_2023 Yr_2024    
    sticks 500 700 <--- sales
    bats 200 150    

     

    I have the data in Excel and loaded in successfully.  I just need to get total sales for 2023 Vs total sales for 2024.  How do I group the data in a Straight table to show this?  Any help would be great.

    Show Less
  • forum

    App Development

    Empty row for wrong key (?!)

    Hello everyone, I have an issue with my App in QlikSense. Basically I have a table where I want to display two values: sold and target. But I guess I ... Show More

    Hello everyone,

    I have an issue with my App in QlikSense. Basically I have a table where I want to display two values: sold and target. But I guess I had a wrong connection with my tables, so that's the result:

    Immagine 2024-05-18 144553.png

    It's 3 days I'm trying to solve this problem 😥
    Could anyone help me?
    I have attached my DataLoad script to have a look.

    Thank you all! 🙏

    Show Less
  • forum

    New to Qlik Analytics

    KPI Label Change

    Sum({$<[Sale History 2022.Customer]={"Publix"}>}[2022 Qty Sold])   Can someone please tell me, how to make KPI label change based on what is in the fo... Show More

    Sum({$<[Sale History 2022.Customer]={"Publix"}>}[2022 Qty Sold])

    Ross1991_0-1716062035616.png  Can someone please tell me, how to make KPI label change based on what is in the formula?  If formula above says, "Petco", I need to see KPI with 10,000 and Label says "PETCO". Is this possible?  Thank you.

     

    Show Less
  • forum

    New to Qlik Analytics

    QlikSense Installation issues - Unable to see window in full screen post upgrade

    Dear Team, I just tried to upgrade my QlikSense Desktop version to Feb 2024 release. Post upgrading the software the screen looks as mentioned in belo... Show More

    Dear Team, I just tried to upgrade my QlikSense Desktop version to Feb 2024 release. Post upgrading the software the screen looks as mentioned in below image. please suggest.

     

    kaushi2020_0-1707990650309.png

     

    Any suggestions Please ? 

    thanks in advance. 

     

    Show Less
  • forum

    New to Qlik Analytics

    How to change loaded data based on selected filter value

    HiI have a qlik application and i need to shpw data based on two filter values 1. full year data 2. end of month data.For full year (default selection... Show More

    Hi
    I have a qlik application and i need to shpw data based on two filter values 1. full year data 2. end of month data.
    For full year (default selection), the data should be loaded till today however for second selection i.e end of month, the data should be loaded only till previous month.

    The logic for the date is present here: 

     

    LET minYEAR = 2020;
    LET maxYEAR = YEAR(Today());
    TmpAnosMC:
    LOAD ($(minYEAR) + RowNo()) - 1 AS #_ANO_MC
    AutoGenerate (1)
    WHILE $(minYEAR) + RowNo() <= $(maxYEAR);

    FOR EACH A IN FieldValueList('#_ANO_MC')

    MasterCalendar:
    LOAD ID_PROPOSTA AS ID_PROPOSTA,
    '$(A)' AS #_ANO_FIM,
    '$(A)' & 'YD' AS DAT_VISUAL,
    0 AS #_ORDEM_VISUAL
    RESIDENT FACT_KA_PROPOSTA
    WHERE DAT_FIM_REQUISICAO_FMT >= DATE(DATE#('01/01/' & ('$(A)'),'DD/MM/YYYY'),'DD/MM/YYYY')

    AND DAT_FIM_REQUISICAO_FMT <= DATE(DATE#(Num(DAY(Today()),'00') & '/' & Num(Month(Today()),'00') & '/' & ('$(A)'),'DD/MM/YYYY'),'DD/MM/YYYY');


    For the end of month filter: the field DAT_FIM_REQUISICAO_FMT  where condition should be changed to   DAT_FIM_REQUISICAO_FMT <= Date(MonthEnd(Today(), -1), 'DD/MM/YYYY')
     AND DAT_FIM_REQUISICAO_FMT <= Today();

    if this can be achieved in qlik frontend of backend , kindly help.

    Show Less
  • forum

    Integration, Extension & APIs

    How can I embed multiple sheets of QlikSense on my web page?

    Hi, I need to integrate my QlikSense cloud dashboard with my web application using JWT Authentication. I tried iframe with sing sheet, but I need to e... Show More

    Hi,

    I need to integrate my QlikSense cloud dashboard with my web application using JWT Authentication.

    I tried iframe with sing sheet, but I need to embed multiple sheets.

    Does anyone have implemented this before?

    Thanks.

    Show Less
  • forum

    Administering and Monitoring

    Real-Time Statistics is not shown when connected via Job Server

    Hi,I am creating this topic, to address an issue we are currently experiencing regarding the real-time statistics not being displayed when running job... Show More

    Hi,

    I am creating this topic, to address an issue we are currently experiencing regarding the real-time statistics not being displayed when running jobs from our Studio Client v.8 via the Job server. I have completely un-installed and installed the Talend Remote Engine in the server, still the same thing. But when we are running the job via localhost, we are able to see the statistics. We already played around the settings in Windows > Preferences > Talend > Run/Debug as well as the Stats & Logs under the Job tab, still no avail. The range port numbers are even allowed in both Inbound and Outbound Rule of the server. Any idea on this is greatly appreciated.

    Thank you.

    Show Less
  • forum

    Design and Development

    Statistics is not shown while running job from job server

    Hi Everyone,   when i try to run the job from remote server, statistics is not displayed in talend studio. I have checked all the checkpoints like run... Show More

    Hi Everyone,

     

    when i try to run the job from remote server, statistics is not displayed in talend studio. I have checked all the checkpoints like run/debug option, Statistics check box is enabled, can see statistics when i run the job locally. I am using Talend 6.5, windows 10, JRE 1.8. kindly help me out here if any quick solution.

    Show Less
  • forum

    Component Development

    Unable to view talend job stats in Studio when we choose remote engine in Target...

    Hi Team,   When I choose "LocalHost" for Target Exec job shows stats but when i select Job server stats gets disappeared.   Could you please help to r... Show More

    Hi Team,

     

    When I choose "LocalHost" for Target Exec job shows stats but when i select Job server stats gets disappeared.

     

    Could you please help to resolve the issue.

    sanjeevini_0-1716053539380.png

     

    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?
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!