Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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
Pencil in our most magical conference yet: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL
Fuel your data and AI journey with the right services, delivered by our experts.
With Qlik Answers™, get personalized, GenAI-driven answers from unstructured data, so you can make decisions with confidence. Learn how in our product roadmap keynote and demo.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
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.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!