Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 259,223 members
  • 5,036 online
  • 2,041,585 posts
  • 153,630 Solutions
Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now

Welcome to Qlik Community

Recent Discussions

  • forum

    Brasil

    Soma Acumulada por Data Base

    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 v... Show More

    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:

    msfoliveira_0-1756728412195.png

    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!

     

    Show Less
  • forum

    App Development

    Introducing blank rows in qlikview straight table.

    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 e... Show More

    Dear Qlik Experts 

    I have some data in qvd, like so

    fahadhashmi_0-1756712186166.png

     

    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. 

    fahadhashmi_1-1756712206011.png

     

     

    Regards 

    Fahad

    Show Less
  • forum

    App Development

    Full transpose of a table

    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 "Ke... Show More

    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:

    KeyValue
    Attribute_Name_1Value_1
    Attribute_Name_2Value_2
    Attribute_Name_3Value_3

     

    After:

    Attribute_Name_1Attribute_Name_2Attribute_Name_3
    Value_1Value_2Value_3


    Thank you

     

     

    Show Less
  • forum

    QlikView Administration

    Slow reload times for QlikView using QlikView desktop

    Afternoon,I would appreciate some insight from those who have a better understanding of the internal processing of QlikView than I do.The largest mode... Show More

    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.

    Show Less
  • forum

    Insight Advisor

    Year field is not interpreted by Insight advisor

    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 it... Show More

    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..

    Qlik1_User1_0-1755072359945.png

     

    Show Less
  • forum

    Francophones

    Set Analysis sur la semaine -1 en fonction d'une sélection

    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 ra... Show More

    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

    Show Less
  • forum

    App Development

    Need to find the repeat count of PAN from previous year in current year

    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_NUMB... Show More

    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.

    Show Less
  • forum

    Administering and Monitoring

    Total number of users and active users

    Hi EveryoneOne 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 Qlik... Show More

    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

    Qlik Sense Enterprise on Windows 

    Show Less
  • forum

    Visualization and Usability

    How to use calculated dimension's color in visualization?

    Hello experts, I have assigned colors by value to a calculated dimension. This dimension calculates slices. The problem is that I cannot get the color... Show More

    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.

    Marilyne_0-1754300809181.png  This is KO and 

    Marilyne_3-1754301148673.png

    this is KO too

     

     

    Marilyne_1-1754301031711.png

    This is OK but 

    Marilyne_2-1754301091932.png

    this is KO while it's supposed to stay the same

     

     

    Show Less
  • forum

    App Development

    Unable to Save App Details via Hub

    [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 access... Show More

    [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?

    Show Less

Empower your organization's data with Qlik - start your FREE TRIAL today!

Leaderboard

Customer Story

Catalyst Cloud (Fusion)

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.

Customer Story

Catalyst Cloud (Coeus SEP)

Catalyst Cloud developed Coeus SEP, a Qlik‑based platform for sharing supply chain data with suppliers.

Customer Story

Instant Answers Empower Thousands of Users

Billion-dollar organization delivers quality service and consistency at scale with Qlik Answers, powered by Amazon Bedrock.

Customer Story

Empowering Students With Data Skills for Real-World Impact

Thomas More University works with the Qlik Academic Program and EpicData to encourage and inspire students.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

Your Place, Your People

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Qlik en México

Qlik en México

Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.

All are welcome

Hello from Japan

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Parlons Données

Parlons Données

Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.

open to all

Did you know...

Qlik Free Trials

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.

Did you know...

Turn change into opportunity

Salesforce’s acquisition of Informatica could put your flexibility on hold? Qlik makes it easy to keep your data initiatives moving forward.