Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to create a table that lists every field, which has columns for the total number of nulls, the percentage of rows that have a null, etc. What is the best way to go about this? I have a pivot table that uses $Field as the dimension, but I am unsure how to count the null values in Qlikview.
Hello Qlik community,
I am struggling a bit with a data transformation I need to perform.
I have a table like this one
start_date | division | service | ID |
01/01/2025 |
EMEA | AAA | AHEMA |
01/03/2025 | APAC | BBB | AHEMA |
01/04/2025 | EMEA | CCC | AHEMA |
01/01/2025 | LAM | DDD | KILMA |
01/05/2025 | NAM | EEE | KILMA |
What I need to get is this table below with a new field Period
start_date | division | service | ID | Period |
01/01/2025 | EMEA | AAA | AHEMA |
202501 |
01/01/2025 | EMEA | AAA | AHEMA | 202502 |
01/03/2025 | APAC | BBB | AHEMA | 202503 |
01/04/2025 | EMEA | CCC | AHEMA | 202504 |
01/04/2025 | EMEA | CCC | AHEMA | 202505 |
01/01/2025 | LAM | DDD | KILMA | 202501 |
01/01/2025 | LAM | DDD | KILMA | 202502 |
01/01/2025 | LAM | DDD | KILMA | 202503 |
01/01/2025 | LAM | DDD | KILMA | 202504 |
01/05/2025 | NAM | EEE | KILMA | 202505 |
I've tried something like that but it is not working as it is ignoring the change of division/service
LET vMaxDate =num(monthstart(today()));
LOAD distinct
start_date,
division,
service,
DATE(MonthStart(start_date+ IterNo() - 1),'YYYYMM') AS Period,
ID
FROM [lib://AttachedFiles/Classeur1.xlsx]
(ooxml, embedded labels, table is Feuil1)
WHILE start_date+ IterNo() - 1 < $(vMaxDate);
I am missing something here but can't figure it out.
Thanks for any help !
IndiaMatch would be favorable for fans who want to follow sports's up-to-the-second progressive updates but aren't always technologically able! You cant work, or commuting or millions of times access to match info I would be happy to be near customer onsite updates, mapping every ball from detailed accurate ball-by-ball coverage, with milestones and stats on all the notable moments. Fans can feel engaged with Team India's connectedness to a moment without it going up on a half-baked screen or on-demand media.
Hello,
In Qlik Cloud, how can I test the Access section with scope reduction?
Is it possible to simulate the display for a specific user?
(I'd like to avoid app reload between each test)
Regards
Hi Folks,
Hope you're doing well !!
I came across one of the requiremnet where we need to show all measures value in descending order in pivot table of qliksense.
Is there a way to do customize sorting of pivot tables in Qlik sense so that measures should show in descending order, I have tried both sort by first measure and sort by expression but still lagging to get this.
Regards,
KK
Hi guys, we have a very special problem for the dedectives among us 🙂
We installed Qlik Sense Enterprise on a VM using the CNAME qlik-dev.ad.ourdomain.de. Everything lookes fine after installation. Services are running under the service account. Ports are open, Qliks certificates are correct.
When using localhost/qmc or hub, logged in with the service account, everything works fine but no authentication window appears.
When using qlik-dev.ad.ourdomain.de/qmc or hub or even localhost in incognito mode the windows authentication window appers but after entering the correct user/password the attached ERR_UNEXPECTED appears.
Has anyone of you experienced a problem like that?
Kind regards, Andy
Morning All,
I have the following table appearing on the preview page of my app. I've not deliberately generated this and it doesn't connect to my data in any way. It also appears to not be causing any problems.
The source is Snowflake. App is in Qlik Cloud Analytics.
Thanks in advance.
Hello Qlik Community,
I've encountered a very peculiar behavior with an expression in Qlik Sense SaaS that seems to defy standard parsing rules and might indicate a bug. I'm hoping to get some insight, confirmation, or a potential explanation for this.
The Goal:
I'm trying to calculate the sum of Revenue for a specific Period defined by a variable vMaxPeriod, using the TOTAL qualifier to get a grand total (disregarding chart dimensions).
The Working Expression (Surprisingly):
My expression only works when structured exactly like this, including the // (comment) characters and specific line breaks:
Sum({$<Period={$(vMaxPeriod)}>} // TOTAL [GL_Hub] Revenue)
Key Observations for the Working Expression:
The Problem: Expressions That Don't Work (and why they should according to documentation):
If I remove the // comment, or if I consolidate TOTAL [GL_Hub] Revenue onto a single line after the set analysis, the expression breaks and returns an error.
Removing // (should work if // were just a comment):
Sum({$<Period={$(vMaxPeriod)}>} TOTAL [GL_Hub] Revenue)
Consolidating TOTAL and Field on one line (standard recommended syntax):
Sum({$<Period={$(vMaxPeriod)}>} TOTAL [GL_Hub] Revenue)
My Environment:
My Question to the Community:
I've verified that $(vMaxPeriod) resolves correctly to a valid period value and that [GL_Hub] Revenue is the correct field reference. The issue consistently lies with the presence/absence of // and the specific line breaks.
Any insights or similar experiences would be greatly appreciated!
Thank you,
Will
Hi!
I have a straight table in QLik Sense and I built such table in QlikNprinting and then form it I wanted to built pivot table.
I changed headers to be blue but values columns does not keep that color:
but when data is added:
here are my settings:
keep source format also turned off for columns.
how can i make it work?
Qlik NPrinting February 2024 SR3
Version: 24.4.14.0
Qlik Sense Enterprise on Windows
Is it safe to delete logs from this folder C:\ProgramData\Qlik\Sense\Log\CapabilityService
Both old and new.
And why some logs are of 32 GBs
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Analytics and Business Intelligence Platforms.
We’re excited to introduce the ability to manage automations in shared spaces, enabling collaboration and execution through the context of a shared space.
A one-day focused event designed to give you practical strategies and real-world use cases for transforming data, analytics, and AI.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik empowers Foodbank Victoria with real-time data insights, optimizing food acquisition and distribution to deliver 25 million meals annually while reducing waste and costs across its statewide relief efforts.
Qlik accelerates decision-making at Alpha Auto Group, enabling seamless data integration and automation across dealerships, cutting reporting times, and driving scalable business growth.
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!