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: 
  • 249,121 members
  • 7,115 online
  • 2,031,725 posts
  • 152,958 Solutions
Announcements
WEBINAR April 23, 2025: Iceberg Ahead: The Future of Open Lakehouses - REGISTER TODAY

Welcome to Qlik Community

Recent Discussions

  • forum

    Francophones

    Tableau avec mois sans mesure

    Bonjour à  tous,Dans un graphe, où figure le nombre d'incidents par mois, comment afficher les mois qui n'ont pas de mesure (d'incident).Exemple :Janv... Show More

    Bonjour à  tous,

    Dans un graphe, où figure le nombre d'incidents par mois, comment afficher les mois qui n'ont pas de mesure (d'incident).

    Exemple :
    Janv 3 incidents
    Fevrier 1 incident
    Avril 4 incidents
    comment avoir Mars 0 incident sans creer cette ligne dans la table des incidents ?
    Sachant que mes abscisses sont les An et Mois d'incidents et les ordonnées le nombre d'incidents
    Merci

    Show Less
  • forum

    App Development

    Paste and Select - Variable Input and Button Action

    Users need to be able to paste a list of values from excel and use those values as selections in a field. I have seen examples of this done using vari... Show More

    Users need to be able to paste a list of values from excel and use those values as selections in a field. I have seen examples of this done using variable input and a button with select action.

    In my use case, however, only values that contain text characters are being returned. Values that only contain numbers are being ignored in the selection process. 

    Here is my current setup:

    1. Variable input box to set: vMemberID_Selection

    2. Button Action: Select values in a field

    3. Button Field: PRIMARY_MEMBER_ID //text field

    4. Button Value: =replace(vMemberID_Selection,' ',';') //replace the empty space delimiter from excel with a semi-colon

    When I paste the below list from excel, only the first 3 values are returned for PRIMARY_MEMBER_ID. The last two values that only contain numbers are ignored.

    PER-12345678;ORG-12345678;EMP-dsvo3sdf6sdfs48fs4;23456789;34567890

    I have also tried manually converting the Button Value to text but still experienced the same behavior:

    =text(replace(vMemberID_Selection,' ',';'))

    =replace(text(vMemberID_Selection),' ',';')

    Any ideas what could be causing this issue and how to resolve?

     

     

    Show Less
  • forum

    Qlik Replicate

    About AS400 Relative-Record-Number

    Hi teamI have the following questions:1.Is it possible to get Relative-Record-Number of AS400 by AR_H_STREAM_POSITION of Qlik Replicate?2.Is there any... Show More

    Hi team

    I have the following questions:

    1.Is it possible to get Relative-Record-Number of AS400 by AR_H_STREAM_POSITION of Qlik Replicate?

    2.Is there any header or variable to output Relative-Record-Number other than AR_H_STREAM_POSITION?

     

    I would like a primary response by 2025.4.25.

    Show Less
  • forum

    Visualization and Usability

    Qlik Sense Trial – kein Mandant verfügbar / Weiterleitung zur Analytics Tour

    Hallo zusammen,ichhabe mich für die 30-tägige Testversion von Qlik Sense Business mit meiner geschäftlichen E-Mail registriert. Nach dem Abschluss der... Show More

    Hallo zusammen,ich
    habe mich für die 30-tägige Testversion von Qlik Sense Business mit meiner geschäftlichen E-Mail registriert. Nach dem Abschluss der Registrierung werde ich jedoch immer zur "Qlik Cloud Analytics Tour" weitergeleitet und sehe keine Option, einen Mandanten zu erstellen oder in die eigentliche Qlik Sense Umgebung zu gelangen.
    Wenn ich mich unter https://qlikcloud.com anmelde, erscheint "Keine Mandanten zum Verwalten vorhanden".
    Könnt ihr mir helfen, meinen Testzugang korrekt zu aktivieren?
    Vielen Dank im Voraus!

    Show Less
  • forum

    Administering and Monitoring

    Unable to Disable Security Rule in QMC

    Hi All,I have not much knowledge of Security rule in QMC.There is one issue I am facing as Rootadmin. I am unable to duplicate the application in my w... Show More

    Hi All,

    I have not much knowledge of Security rule in QMC.

    There is one issue I am facing as Rootadmin. I am unable to duplicate the application in my work space.

    It is for all applications.

    There are two security has been created in QMC for RootAdmin and unable to disable newely created one.

    In fact, i am unable to update anything in security rule. suppose i am changing any action under resouce filter, it is not getting updated. like create, Read etc..

    May be security rule  is getting overriden. 

    Request your suggestion for resolving this issue as none of developer able to duplicate the application.

    I am attaching the screenshot for reference.

    Thanks in advance!!

    Qlik Enterprise Manager 

     

     

     

     

    Show Less
  • forum

    Connectivity & Data Prep

    How to Connect Local Excels files in Qlik sense Cloud.

    I have a virtual machine with some Excel (.xls) files saved in a local folder.I manually upload these files using the Data Manager in Qlik Sense to cr... Show More

    I have a virtual machine with some Excel (.xls) files saved in a local folder.
    I manually upload these files using the Data Manager in Qlik Sense to create an app.

    However, when I reload the app, it fetches data from the uploaded file stored under 'Data Files' within Qlik Sense, rather than from the original source file in the local folder.

    As a result, any changes made to the original Excel file (or if I replace it with a new version) are not reflected in the app after a reload.

    I would like the app to always load the most recent data from the source Excel file in the local folder on the VM.
    How can I achieve this?


    -I also install Qlik Gateway- Direct access
    -Also try to achieve this Using Qlik Data Transfer but not able to achieve

     

    Show Less
  • forum

    Visualization and Usability

    [Need HELP]Achieving the requirement in pivot table

    Hi All, i would like to know the possiblity of achieving the requirement in front end.I am struggling with calculating the opening balance and closing... Show More

    Hi All,

     

    i would like to know the possiblity of achieving the requirement in front end.

    I am struggling with calculating the opening balance and closing balance since it is very dynamic.

     

    Initial opening balance = 20

    Opening Balance = last week closing balance

    Closing Balance = Opening Balance + New PR Added  - PR Coverted  - PR Deleted

     

    last week closing balance is next week opening balance and so on 

     

    QVF Attached

    prashanthd_0-1745217048666.png

     

     

     

     

    Show Less
  • forum

    App Development

    QlikSense rounding value during load script

    Been working with Qlik for 5 years, never seen this issue before. Loading data from a parquet file, all floats are rounded to 2dp when I add them as d... Show More

    Been working with Qlik for 5 years, never seen this issue before. 

    Loading data from a parquet file, all floats are rounded to 2dp when I add them as dimension. If I load the fields as TEXT(Field), the numbers come out ok, if I show them as measures, they are fine. 

    What's going on here? How can I fix? There's hundreds of columns being imported that are impacted so I need a general fix, not just for that specific field. 

    Thanks a lot 

    Show Less
  • forum

    App Development

    Nested AGGR() and IF()

    Hello! I need to count the number of customers that have made at least one purchase in each of the last three weeks and have that in a chart where Wee... Show More

    Hello!

    I need to count the number of customers that have made at least one purchase in each of the last three weeks and have that in a chart where Week is the dimension.  I have the following expression, but it is not calculating the correct number and I cannot figure out why.  I was wondering if I needed to switch the order of IF() and AGGR(), or if there was a better way to get this result.

    Thank you!

    Count(distinct aggr(
        if(
            Count({< [Invoice Date] = {">=$(=date(Max(%DateKey)-20,'MM/DD/YYYY'))<=$(=date(Max(%DateKey)-14,'MM/DD/YYYY'))"} >} DISTINCT [Order Number]) >= 1 and
            Count({< [Invoice Date] = {">=$(=date(Max(%DateKey)-13,'MM/DD/YYYY'))<=$(=date(Max(%DateKey)-7,'MM/DD/YYYY'))"} >} DISTINCT [Order Number]) >= 1 and
            Count({< [Invoice Date] = {">=$(=date(Max(%DateKey)-6,'MM/DD/YYYY'))<=$(=date(Max(%DateKey),'MM/DD/YYYY'))"} >} DISTINCT [Order Number]) >= 1,
            [Customer Number]
        ),
        [Customer Number]
    ))

    Show Less
  • forum

    Move to Qlik Cloud Analytics

    Qlik Cloud Analytics trial

    How can I activate the 30-day Qlik Cloud Analytics trial? When I try to register, it redirects me to a guided tour instead.
Leaderboard

Customer Story

Optimizing Food Relief with Qlik

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.

Customer Story

Data-Driven Strategies Set To Fuel Growth

Qlik accelerates decision-making at Alpha Auto Group, enabling seamless data integration and automation across dealerships, cutting reporting times, and driving scalable business growth.

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.

Location and Language Groups

Choose a Group

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

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

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

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!