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 

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: 

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). 

Is there anything I missed? I appreciate any help. 

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

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

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!

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?

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 '-'

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 

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

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.

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

Thanks