Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bom dia a todos!
Poderiam por gentileza me ajudar com uma questão no Qlikview?
Na tabela abaixo, preciso que a última coluna (UTL_ACUMULADA) traga o valor acumulado da soma da outra coluna a esquerda, sendo a VALOR_UTL:
Desta forma, na última linha, teríamos o valor acumulado igual ao valor total.
Pesquisei no fórum algumas expressões como rangesum, above, porém não tive sucesso.
Obrigado!
Dear Qlik Experts
I have some data in qvd, like so
I want to represent it in a straight table like below. i.e whenever the mat column changes the an empty row should appear and if someone selects 2 mat values the empty row should remain there. I am open to qlik script ideas or straight table ideas.
Regards
Fahad
Hi, I need to fully transpose my table. I have two Columns: key and value, with 12 values.
I need the 12 to-be-columns to be called as the relative "Key" column values, and the values of each to-be-column (only 1 value per column) to be the "values" column values.
I tried Generic Keyword but it creates distinct tables, and it's a problem since i don't know (and cannot know) the future column name a-priori. (i'm thinking roght now to a loop cycling trough the distinct names of the columns and use them as variables to create the join, but I really hope it exists a smarter way!)
Example
before:
Key | Value |
Attribute_Name_1 | Value_1 |
Attribute_Name_2 | Value_2 |
Attribute_Name_3 | Value_3 |
After:
Attribute_Name_1 | Attribute_Name_2 | Attribute_Name_3 |
Value_1 | Value_2 | Value_3 |
Thank you
Afternoon,
I would appreciate some insight from those who have a better understanding of the internal processing of QlikView than I do.
The largest model in our environment is rebuilt everyday via a scheduled task in QMC. It takes around 40 minutes to rebuilt.
When I open that same model using QlikView Desktop and build the model it can take up to 1:30 depending on other processing that is been done on the server. I tested the rebuild and ran it when there was no other activity on the system (after working hours). It still takes over 1 hour to build.
I am puzzled as to why there is such difference in the build times using these 2 methods of rebuilding, as I assume they have the same processing engine. I am running my desktop rebuild on the same server that runs QMC. I log onto that server using a remote desktop connection. We also only have 1 instance of QMC running on that server. I have carried out this exercise as well as once of my colleagues and get the same results.
I am using May 2023 version of QlikView.
I would appreciate some insight into why this is happening.
Hi,
I am using insight advisor and i have a field as Ryear which is numeric (checked via isnum() as well) but when I am searching in insight advisor its not interpreting it .. please suggest what is missing..
Bonjour,
Je cherche à faire un Set Analysis sur un de mes graphiques.
Actuellement j'ai une expression qui me retourne la semaine précédente par rapport à aujourd'hui : Semaine={'$(=weekname(today()-7))'}. => '2025/34' si nous sommes en S35.
Je cherche à avoir la S-1 en fonction de ma sélection dans le champ semaine. J'ai pensé à quelque chose comme : Semaine= {'$(=GetFieldSelections(Semaine)-1)}' mais cela ne fonctionne pas.
Si vous avez une idée je suis preneur.
Merci d'avance et bonne journée
Hi all,
I have two fields, PAN_NUMBER and TRADE_DATE. PAN_NUMBER will repeat as the customer comes again. I want to show the count of Distinct PAN_NUMBER for a year, Total count of PAN_NUMBER for a year, How many Customers repeated in current year, How many customers from previous year were repeated in current year.
Any help or idea is appreciated
Thanks in advance.
Hi Everyone
One of our customer is looking for a report which shows the total number of users and the number of active users on a monthly basis in Qliksense. I have looked through the monitoring apps but couldn't find any such reports. Is it possible to generate such report? Any insights would be helpful
Regards
Sivanesan
Hello experts,
I have assigned colors by value to a calculated dimension. This dimension calculates slices.
The problem is that I cannot get the colors assigned to each slice in the dimension to appear in a Qlik bar chart or when I create a pie chart by selecting “color by dimension.” However, it works fine with Vizlib charts by selecting "Use master item colors".
Are there specific rules between Qlik and Vizlib charts? What are the best practices with calculated dimensions for colors? How can i get a good Qlik bar chart with my colors?
Here are some pictures with Qlik graphics.
This is KO and
this is KO too
This is OK but
this is KO while it's supposed to stay the same
[Updated on 2025/08/13 UTC+8]
Hi everyone,
I have identified the cause — it is related to the HTTP (port 80) vs. HTTPS (port 443) connection.
When accessing via HTTPS (443), the app’s details panel can be modified successfully, whether using host name or IP address.
However, when accessing via HTTP (80), the details panel cannot be modified, regardless of host name or IP.
In the Nov 2024 release, modifying the details panel worked fine over both HTTP and HTTPS.
I would appreciate it if the product team could advise whether in May 2025 we need to adjust any QMC settings, or if this will require a future patch to address.😣
================
[original post]
I’m currently using Qlik Sense Enterprise May 2025 Patch 3, but I’m unable to update any of the fields in the Edit details panel through the Hub — including:
1. App name (Title)
2. Thumbnail image
3. Description
My account has a Professional license, and I’m doing this in my personal workspace (not published to a stream). I have confirmed that my account has the required permissions.
When I make changes and click Done, nothing is saved — the details remain the same.
Has anyone else experienced this? Could this be a bug in this version, or is there a setting I need to adjust?
Empower your organization's data with Qlik - start your FREE TRIAL today!
A guide to PowerCenter 10.5 End of Support and Salesforce’s acquisition, with migration strategies and why Qlik Talend is the trusted choice.
Get insider access to the trends, buzz, and bold strategies from leaders transforming data and AI across industries.
Hear from Qlik and AWS experts on minimizing risk in analytics cloud migration, while future-proofing, optimizing TCO, and advancing AI.
Watch expert-led sessions from Qlik Connect 2025 to see how our latest innovations help you integrate and analyze data.
Your journey awaits! Join us by Logging in and let the adventure begin.
Catalyst Cloud developed Fusion, a no-code portal that integrates with existing Qlik licenses to deliver critical insights across the organization. The results? Time savings, transparency, scalability to expand, and increased adoption.
Catalyst Cloud developed Coeus SEP, a Qlik‑based platform for sharing supply chain data with suppliers.
Billion-dollar organization delivers quality service and consistency at scale with Qlik Answers, powered by Amazon Bedrock.
Thomas More University works with the Qlik Academic Program and EpicData to encourage and inspire students.
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!
Ú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.
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.