Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 232,924 members
  • 4,394 online
  • 2,015,990 posts
  • 151,363 Solutions
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    Color Condition within condition

    Hello,  I am trying to create a KPI card that displays Yes or No if my cost = delivered. I am trying to display it so that if it’s Yes it’s in blue an... Show More

    Hello, 

    I am trying to create a KPI card that displays Yes or No if my cost = delivered. I am trying to display it so that if it’s Yes it’s in blue and if it’s No it’s in Red. However I cannot figure out how to change the color depending on Yes or No. please advise 

    Show Less
  • forum

    App Development

    DecimalSep and ThousandSep: it doesn`t show the right way on sheet

    I need to show numeric values in the Brazilian format:  1.000,00 (decimal separator is a comma and thousand separator a final point). I've set this pa... Show More

    I need to show numeric values in the Brazilian format:  1.000,00 (decimal separator is a comma and thousand separator a final point). 

    I've set this parameters on the load script. In the visualization area, it shows the correct format, as shown in the picture: 

    Paulo_IntelFab_1-1728317779852.png

    But, on the visualization (sheet) it remains using the standard DecimalSep (.) and ThousandSep (,). 
    The date filter used on sheet respects the Brazilian date format that I've set on the load script (DD/mm/YYYY). 

    Paulo_IntelFab_2-1728317960841.png

    Is there anything I missed? I appreciate any help. 

    Show Less
  • forum

    Qlik Enterprise Manager

    Can not instal newest version of qlik sense enterprise on new server

    Hi everyone,  I've tried to instal qlik sense enterprise on two different machines. Both of the machines were immaculated, without any other applicati... Show More

    Hi everyone, 

    I've tried to instal qlik sense enterprise on two different machines.

    Both of the machines were immaculated, without any other application installed.

    The insallation went wrong when it try to insall the repository service.

    what can i do?

    Thanks

    Regards

     

    Show Less
  • forum

    Integration, Extension & APIs

    Ticket authentication doesn't work with iframe

    Hi, I was able to authenticate users using ticket but it doesn't work once I embed it in iframe. Any ideas? Thanks,
  • forum

    App Development

    Structure of Table Object in a Qlik Sheet

    Hello, I have some data in the followig format (only an example):Date, Shift_Nr, Route, Comment, Duration07.10.2024, 1, VP27, hello, 507.10.2024, 2, v... Show More

    Hello,

    I have some data in the followig format (only an example):

    Date, Shift_Nr, Route, Comment, Duration
    07.10.2024, 1, VP27, hello, 5
    07.10.2024, 2, vp17, hi, 4
    07.10.2024, 1, vp76, bye, 1
    07.10.2024, 3, vp37, new, 6
    07.10.2024, 1, vp17, bike, 7
    07.10.2024, 1, vp47, good, 10
    07.10.2024, 2, vp27, bad, 85
    07.10.2024, 3, vp76, sunny, 0
    07.10.2024, 2, vp86, weather, 4

    I have loaded this data via the load script from my database. I want to display this data in a table with a different structure. The first two columns shoul be the same i.e. date and shift_nr. Then I want two columns for each distinct route value as comment and duration (for e.g. vp17_comment, vp17_duration, vp27_comment, vp27_duration, etc). Currently if I create a table, the values of cp17+comment and vp27_comment are not displayed side by side for same date and shift nr, instead they are displayed seperately (see the picture attached). How can I achieve the desired result via the set analysis in the sheet itself without changing the load script?

     

    Regards,

    Tahir

    Show Less
  • forum

    Qlik NPrinting

    nPrinting February 2024 SR3 - Excel report - Pivot tables with "Page" feature

    Pivot tables don't seem to be working properly with the "Page" feature in nPrinting Excel reports. To reproduce it: Create a connection to any Qlik S... Show More

    Pivot tables don't seem to be working properly with the "Page" feature in nPrinting Excel reports.

    To reproduce it:

    1. Create a connection to any Qlik Sense app.
    2. Create an Excel report using that connection.
    3. Add any field as "Page". This will change the name of "Sheet1" to <NAME_OF_FIELD>.
    4. Create a fixed table in the Excel (a table not coming from Qlik, but just some fixed data).
    5. Create a pivot table in the sheet using the fixed table as source.
    6. Preview the report.

    Let's say you are iterating over field MYFIELD and values are MF1, MF2, MF3 and MF4. In this case, nPrinting will clone your sheet 4 times and they will be called MF1, MF2, MF3 and MF4.

    The fixed table will be present in all sheets and the pivot table as well. However, in ALL sheets, the pivot table will point to the fixed table in sheet MF1 (the first one).

    In this case, the expected behavior is for nPrinting to generate 4 sheets (MF1, MF2, MF3 and MF4), each sheet will have a copy of the fixed table and each sheet will have a pivot table using as data source the fixed table from the same sheet.

    I understand in 2017 there was an issue (Jira issue OP-5657), which was fixed, related exactly to the issue of mixing "Page" with pivot tables (see release notes for nPrinting November 2017).

    So, is this supposed to work as I expect it to? Is this an error? Is it a "feature"? (maybe @Andrew_Kruger or @Gianluca_Perin can help?).

    Thanks a lot for your help!

    Show Less
  • forum

    New to Qlik Analytics

    Number of customers bought specific product after new product launch

    Hi All, I have below dataset. I want to display count of customers in KPI chart who purchased product 'B' after 'NewProduct' launch.  1,12/01/2024,New... Show More

    Hi All,

    I have below dataset. I want to display count of customers in KPI chart who purchased product 'B' after 'NewProduct' launch. 

    1,12/01/2024,NewProduct
    1,13/01/2024,A
    2,14/01/2024,B
    2,12/03/2024,NewProduct
    3,13/03/2024,B
    3,14/02/2024,NewProuct
    4,11/03/2024,B
    4,25/02/2024,NewProduct
    5,18/03/2024,B
    5,11/03/2024,NewProduct

    From above sample data, I need output in KPI object as 3 (Customers 3,4 and 5) who purchased product B after NewProduct launch. How can I write the expression to get the required output?

     

    Show Less
  • forum

    App Development

    How could I have three differets field with specific information from Hire and l...

    Hello folks, Hope this message fins you well, and could help me out with this matter. I stuck with app about information of employees from a any compa... Show More

    Hello folks,

    Hope this message fins you well, and could help me out with this matter.

    I stuck with app about information of employees from a any company.

    I would like to have all the info about when has been hired and when has been left.

    1. if start_date = cannonical_date = hired_date, if termination_date = cannocinal_date = left_day, '-'

    2. if Month(start_date) = Month(cannonical_date) then hired_month, if Month( termination_date) = month(cannocinal_date) then hired_month, '-'

    3. if Year(start_date) = Year(cannonical_date) then hired_year, if Year( termination_date) = Year (cannocinal_date) then hired_year, '-'

    Actually the last part of the leftmonth is wrong because it should be '-'

    migueldfr_23_1-1728313771395.png

    this is the script that I have created to retrieve the logic listed.

    // Crear el mapeo para las fechas de entrada (start_date)
    person_id2start_date:
    MAPPING LOAD
        person_id,
        start_date
    RESIDENT hcm_workers;
    
    // Crear el mapeo para las fechas de salida (termination_date)
    person_id2termination_date:
    MAPPING LOAD
        person_id,
        If(IsNull(termination_date), Today(), Date(termination_date)) as termination_date
    RESIDENT hcm_workers;
    
    
    DateBridge:
    LOAD
        person_id & '-' & full_name as Key_person_id_full_name,
        Date(ApplyMap('person_id2start_date', person_id) + IterNo() - 1) as CanonicalDate,
        Year(ApplyMap('person_id2start_date', person_id) + IterNo() - 1) as CanonicalYear,
        Month(ApplyMap('person_id2start_date', person_id) + IterNo() - 1) as CanonicalMonth,
    
        // Día (hiredday o leftday)
        If(
            ApplyMap('person_id2start_date', person_id) + IterNo() - 1 = ApplyMap('person_id2start_date', person_id),
            'hiredday',
            If(
                ApplyMap('person_id2termination_date', person_id) + IterNo() - 1 = ApplyMap('person_id2termination_date', person_id),
                'leftday',
                '-'
            )
        ) as datetypedia,
    
        // Mes (hiredmonth o leftmonth)
        If(
            Month(ApplyMap('person_id2start_date', person_id) + IterNo() - 1) = Month(ApplyMap('person_id2start_date', person_id))
            AND Year(ApplyMap('person_id2start_date', person_id) + IterNo() - 1) = Year((ApplyMap('person_id2start_date', person_id))),
            'hiredmonth',
            If(
    			Month(ApplyMap('person_id2termination_date', person_id)) = Month(ApplyMap('person_id2termination_date', person_id) + IterNo() - 1)
                AND Year(ApplyMap('person_id2termination_date', person_id)) = Year(ApplyMap('person_id2termination_date', person_id) + IterNo() - 1),
                'leftmonth',
                '-'
            )
        ) as datetypemonth,
    
        // Año (hiredyear o leftyear)
        If(
            Year(ApplyMap('person_id2start_date', person_id) + IterNo() - 1) = Year(ApplyMap('person_id2start_date', person_id)),
            'hiredyear',
            If(
                Year(ApplyMap('person_id2termination_date', person_id)) = Year(ApplyMap('person_id2termination_date', person_id) + IterNo() - 1),
                'leftyear',
                '-'
            )
        ) as datetypeyear
    
    
    RESIDENT hcm_workers
    // El ciclo debe continuar hasta el último día trabajado
    
    WHILE ApplyMap('person_id2start_date', person_id) + IterNo() - 1 <= Today()
    AND ApplyMap('person_id2start_date', person_id) + IterNo() - 1 <= ApplyMap('person_id2termination_date', person_id, Today());
    


    I would like to achieve the porpuse, but leftmont, leftyear and leftday, does not show up on my table. so I am not doing in the right way.

    I would appreciate any help 

    Thank you 

    Show Less
  • forum

    New to Qlik Analytics

    Change colour of rows in a straight table for total

    Hi all, Is there anyway to change the total row from the first picture to look like the second picture? I have managed to change the background colour... Show More

    Hi all,

    Is there anyway to change the total row from the first picture to look like the second picture? I have managed to change the background colour for each expression using the formula: =If(Dimensionality() = 0, RGB(169,169,169))

    However, I can't seem to change the cell colour where it says total. Thanks

    qlik capture.pngqlik capture 2.png

    Show Less
  • forum

    Connectivity & Data Prep

    Data refresh based on the country

    Hi Experts, I have a simple question but did not receive unambiguous answer. I want to refresh data in data load editor but it keeps failing (please s... Show More

    Hi Experts,

    I have a simple question but did not receive unambiguous answer.

    I want to refresh data in data load editor but it keeps failing (please see screenshot below). App use connection to MSSQL server. Does my internet speed could affect that? Or maybe the country where I am in the moment (although it worked in first week)? Other apps from different data source work perfectly fine.

    Ernests_0-1728305417876.png

    Until now I thought Qlik cloud will work anywhere if only there is internet.

    Thanks

    Show Less
X
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!