Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello -
This is the CSS that is currently being loaded for a null background
.qv-st-data-cell-null-value {
background-color: #f2f2f2;
}
I have updated my theme to contain the following
.qv-st-data-cell-null-value {
background-color: #ffffff !important;
}
However after updating/uploading my new theme I am not seeing my new style applied. I still see the style coming in from and being applied from common.css. Other styles from my theme are working, however my latest change is not.
Any thoughts? Thanks.
We have been seeing this error fairly often, for multiple users, in many different locations, on vpn and off vpn. The error is similar to a timeout but happens while the user is actively working in an app. The message shows at the top of the screen like shown below.
when this error happens, developers sometimes lose the recent changes to the script that they were working on. we reported this to Qlik support but did not get any resolution, cause or workaround.
Is anyone else seeing this situation in Qlik SAAS or in QCG?
have you found any causes or workarounds?
Hello,
I'm having on 4th november
the QSDA2024
Qlik Sense Data Architect Certification Exam - 2024
English
I wanted to have the list of all the requirement like the pdf document attached (it's an old one).
With the certification evolving i don't want to miss anything.
Will there be any qlik cloud related question for that certification ?
Thank you
En SQL puedo tener subconsultas con la sentencia WITH, pero Qlik no me las reconoce, alguien sabe como puedo hacer algo similar
WITH
"MAI" AS
(SELECT
"TBL_MOVIMIENTO_MERCANCIA"."ID_CENTRO" AS "ID_CENTRO",
"TBL_MOVIMIENTO_MERCANCIA"."ID_MATERIAL" AS "ID_MATERIAL",
"TBL_MOVIMIENTO_MERCANCIA"."ID_TIPO_MOVIMIENTO" AS "ID_TIPO_MOVIMIENTO",
MAX("TBL_MOVIMIENTO_MERCANCIA"."F_CONTABILIZACION") AS "FUE",
FROM "PRD_CON_INV"."INVENTARIO"."TBL_MOVIMIENTOS_MERCANCIA" "TBL_MOVIMIENTO_MERCANCIA"
WHERE
"TBL_MOVIMIENTO_MERCANCIA"."ID_TIPO_MOVIMIENTO" IN ('101' , '305' , '319' , '501' , '511','901')
GROUP BY
"TBL_MOVIMIENTO_MERCANCIA"."ID_CENTRO",
"TBL_MOVIMIENTO_MERCANCIA"."ID_MATERIAL",
"TBL_MOVIMIENTO_MERCANCIA"."ID_TIPO_MOVIMIENTO"
)
--------------------------------------------------------
SELECT
"PROD"."MAT_PADRE",
"MAI"."ID_CENTRO",
"MAI"."ID_MATERIAL",
MAX("MAI"."FUE") AS "FUE_MAX"
FROM
"MAI"
LEFT JOIN
"PROD"
ON ("MAI"."ID_MATERIAL"="PROD"."MAT_PRO")
WHERE
IFNULL("MAI"."FUE",0)<>0
GROUP BY
"PROD"."MAT_PADRE",
"MAI"."ID_CENTRO",
"MAI"."ID_MATERIAL"
Hi Support,
I'd like to understand what effect changing the settings of a streaming endpoint would have on the task run options. If credentials are updated in the target streaming endpoint, would a full reload of the tables be required? Or would the task be able to resume processing of CDC?
For example, if a Full Load + CDC task was streaming changes to an Amazon Kinesis endpoint, the task was stopped, and the access key and secret key of the Kinesis endpoint was changed, would the tables need to be reloaded?
Apologies if this has been covered in a previous community article.
Regards,
Nak
I'm trying to get a retention data over time based on customer sign-up date.
I have data as follows:
Customer | Start_Date | Months_Active |
A | 1/1/2024 | 4 |
B | 1/1/2024 | 2 |
C | 2/1/2024 | 1 |
D | 2/1/2024 | 3 |
E | 3/1/2024 | 2 |
I want to know how many active customers I had for each month number broken down by Start_Date. This is what the data should look like (the numeric values at the column headers indicate # of months post Start_Date, so '1' indicates 2/1/2024 for customers started on 1/1/2024)
Start_Date | count(Customer) | 1 | 2 | 3 | 4 |
1/1/2024 | 2 | 2 | 1 | 1 | - |
2/1/2024 | 2 | 1 | 1 | - | - |
3/1/2024 | 1 | 1 | - | - | - |
I was trying to find an expression formula that would take value in Months_Active at the top of the pivot table and count Customers whose Months_Active <= to that dimension value. I just can't get there. It's either the wrong approach or I just can't find the right combination of set analyses and functions to get me there.
Any help will be appreciated.
Hi all,
I'm here for a very common issue, retention rate. I want to show in a table the number of customers of the specific month and the number of customers that have bought in the specific month and in the previous too.
I can only solve this problem at front end level, not have permission to access to load editor. Imagine that I have available a table for all transaction at CustomerCode and YearMonth level.
Somenthing like:
YearMonth | CustomerCode | Flag Buyer |
2024-01 | 20 | 1 |
2024-01 | 21 | 1 |
2024-01 | 22 | 1 |
2024-01 | 23 | 0 |
2024-01 | 24 | 1 |
2024-02 | 20 | 1 |
2024-02 | 23 | 1 |
2024-02 | 39 | 1 |
Resulting in:
YearMonth | # Customers | # Retained Customer |
2024-01 | 4 | - |
2024-02 | 3 | 2 |
I'm looking to a formula that can be evaluated at row level, letting me compute for each row how many customer have bought in the row's Month and in the previous.
Thanks,
Davide
I have a chart in QlikSense and I'm exporting it to nprinting, but if I keep source formats, I can't add borders. If I deselect keep source formats, I can add borders, but I lose the conditional formatting that comes from the app.
Is there a way to 'keep source formats' for the conditional formatting to pass through, but be able to add cell borders? It doesn't seem like you can add the cell borders within the chart in QlikSense.
Do not keep source formats:
Keep source formats:
Hello,
I have build a JSON string using tWriteJSONField.
with resulting JSON as:
{
"PrimaryAddress": "1",
"AddressID": "E8BBEB79-7566-4731-BE57-E37F3A2593EA",
"Phone": "(705) 5551212",
"Email": "test_Knock@john.net"
}
However, since I am new to this, I am not sure how to build the following (example) JSON using tWriteJSONField:
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!