Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Our Server's User CALs are all occupied. When I tried to release some of them I found that the QMC> System > Licenses > QlikView Server > Client Access Licenses (CALs) > Assign CALs tab returns nothing. It didn't show the User Names as it appears in our other lower QV environments. any suggestions. thanks in advancee.
Is there a way we can update Master Item descriptions for Master dimensions & Measures like we can add { Comment Field } descriptions for Table dimensions & measure in Qlik script?
Hi all,
I am very new to Qlik and still learning Qlik expressions and Set Analysis. I am stuck on a seemingly a very simple task and it appears that ChatGPT has also given up and I cannot find any answers anywhere that can help me with this issue.
So my requirements are pretty simple: A Straight table with the following columns:
Column 1: [MMM YYYY] = Date formatted as [MMM YYYY]
Column 2: [Sales] = Sales for each [MMM YYYY] for the select period
Column 3: [Sale LY] = Sales from the Previous Year, Same month as [MMM YYYY]
In Power BI it will take me less than 2 minutes to do this, by just simply using SAMEPERIODLASTYEAR() function. But Qlik is having none of it and I have tried almost 50 different solutions trying to achieve this.
So I have a FactSales table and a MasterDateCalendar table.
My Sales Expression looks pretty simple:
=Sum([SalesAmount])
For Sales LY I have tried a number of things:
=Sum(
{$<
[SalesDate] =,
Month =,
Year =,
MMYYYY =,
MMMYear =,
YYYYMM =,
YYYYMM = {"=$(=Only(YYYYMM)-100)"}>}
[SalesAmount]
)
Another thing I have tried:
=Sum(
{$<
[SalesDate] =,
Month =,
Year =,
MMYYYY =,
MMMYear =,
YYYYMM =,
[SalesDate] = {">=$(=Num(AddYears(Only([FirstDateofMonth]), -1)))<=$(=Num(AddYears(Only([LastDateofMonth]), -1)))"}>}
[SalesAmount]
)
[FirstDateofMonth] and [LastDateofMonth] are columns from my MasterDateCalendar table.
All of the above show Zeros for Sales LY.
I am absolutely gobsmacked by the fact that such a simple thing in a BI tool could be this difficult to achieve.
Ideally, I would want a straight table with output as shown in the attached image.
Any help or pointers in the right direction will be much appreciated.
Thanks in advance.
We have to match two lists that only have Company names, and no common IDs or any other field to JOIN them on. To use fuzzy logic to match Company name fields to join the table in Load Statment. Please refer to the file and screenshot.
Bonjour,
J'ai un tableau Qlik contenant des valeurs numériques.
Lorsque je le télécharge au format de données "Excel", les nombres apparaissent en millions d'euros.
Comment faire pour que le format d'affichage Qlik soit le même dans l'extraction excel ?
En vous remerciant par avance pour vos pistes.
Céline
Hello everyone,
I have watched some presentation videos about the new Write Tables and I would like to clarify a few points.
From what I understand, Write Tables allow updates only on one or more columns associated with an existing record based on a defined key, but they do not allow inserting new records. Is that correct?
For example, if I want to manage a forecast by country, I could define the country as the key and have an editable column with the forecast amount. In this case, if I need to add a new country, is it possible to do it directly in the Write Table, or must the country already exist in the underlying dataset?
Another point that is not completely clear to me is the 90-day retention of the changes. What exactly happens after 90 days?
Continuing with the forecast example, if this table is used to display the forecast throughout the year, would the editable values for rows that have not been modified for 90 days be removed?
I understand that modified data can be extracted before they are deleted, but in a management table like this I cannot clearly see the practical usage. For example, I cannot write the edited value into another non-editable column within the same table.
Thanks in advance for any clarification.
Hi,
I'm experiencing a strange problem on some of my computers (but not on all of them...)
- In the layout, no icons appear when I hover over charts
- In expression editor, there is no Intellisense prompt when I type functions and fields
- in script editor, there is no prompt either, and the Tab key doesn't cause tabulation, but instead moves focus out of the script.
Does anyone know what it might be caused by, and how to restore the "normal" behavior? mto any chance you've seen this one?
Appreciate your input,
Oleg Troyansky
I have this table with Name and Color
ColorData:
I want to get all the distinct sorted combinations of each name. Joined by a pipe | symbol.
ColorDataCombos:
Note: if it is not possible to get sorted and distinct ones that’s fine. I’ll take all permutations for each name even though there may be many
(Connector error: closing data chunk stream from client) from File Access Gateway
What seems to be causing this error and how can we resolve it?
Attached here are the logs and content of the json file stated in the connectoragent logs
Qlik Data Gateway
FREE TRIAL
Data has stories to tell—let Qlik help you hear them. Start your FREE TRIAL today!
Dare to unleash a new professional you in 2026. Join Connect April 13–15 and supercharge your skill sets.
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Data Integration Tool.
Trends 2026 Alert! Plug into this rewired framework for driving ROI from AI.
Learn why legacy data platforms can’t meet today’s AI and analytics demands and how Qlik provides a modern, independent, future-ready alternative.
Solve the real-world need for real-time data with Change Data Capture (CDC). What is CDC and how to master it?
Your journey awaits! Join us by Logging in and let the adventure begin.
Afcons Infrastructure partnered with Qlik to unify its data and build dynamic dashboards, reducing review times from weeks to hours and enabling on-demand reporting across its global operations.
By implementing Qlik Analytics, Atria Convergence Technologies improves insight into churn, revenue, and downtime, driving faster decisions and more proactive customer support.
Hydronorth uses Qlik to replace disconnected data systems with a single source of truth, improving alignment, speeding up decisions, and reducing manual work.
With Qlik Cloud Analytics, Rexel boosts performance by enabling self-service analysis, reducing prep time, and giving 3,000 users access to trusted insights.
Join one of our Location and Language groups. Find one that suits you today!
Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.
The Qlik Product Recap showcases the newest features with quick demos and shareable resources to help you stay current?
You can test-drive Qlik for free? Try Qlik Talend Cloud to integrate and clean data without code, or explore Qlik Cloud Analytics to create AI-powered visualizations and uncover insights hands-on.
Salesforce’s acquisition of Informatica could put your flexibility on hold? Qlik makes it easy to keep your data initiatives moving forward.
You can move beyond batch processing and harness real-time data to power AI and faster decisions? Discover how in our new eBook, Mastering Change Data Capture.