Skip to main content

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 181,531 members
  • 9,879 online
  • 1,734,482 posts
  • 132,699 Solutions
Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!

Welcome to Qlik Community

FOR NEW MEMBERS

Everything you need to make your Qlik Community experience valuable.

SEARCH KNOWLEDGE BASE

Explore official Support and member created content.

QLIKWORLD 2023!

A live, in-person thrill-ride - full of insights, learning, and peer-to-peer connections.

Analytics

Forums for Qlik Analytic solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration

Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

Qlik Gallery

Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

Ideation

Participate in Qlik Technical Previews, submit ideas, and review documentation.

Support

Chat with us, search Knowledge, open a Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

Events

Learn about upcoming Qlik related events, webinars and local meetups.

Groups

Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

About Qlik Community

Get started on Qlik Community, find How-To documents, and join general non-product related discussions.

Blogs

Hear directly from Qlik employees in our ten unique blogs.

Qlik Resources

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Qlik Academic Program

Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Recent Discussions

  • forum

    Brasil

    Filtros Ano e Mês Atual

    Boa tarde,No Qlik Sense, como posso fazer para que, ao abrir o aplicativo, já seja selecionado automaticamente o mês e ano atual, sem ser necessário s... Show More

    Boa tarde,

    No Qlik Sense, como posso fazer para que, ao abrir o aplicativo, já seja selecionado automaticamente o mês e ano atual, sem ser necessário selecionar manualmente nos filtros respectivos?

     

    Obrigado

    Show Less
  • forum

    New to Qlik Sense

    Obtener un cálculo con datos de una tabla pivotante

    Hola a todos! Requiero hacer una nueva columna con la siguiente formula: "Utilidad Unitaria" = "Utilidad Operación" / "Volumen 3" Los datos están dent... Show More

    Hola a todos!

    Requiero hacer una nueva columna con la siguiente formula:
    "Utilidad Unitaria" = "Utilidad Operación" / "Volumen 3"

    Los datos están dentro de una tabla pivotante.

    tabla pivotante.png

     

    De antemano les agradezco el aporte.

    Show Less
  • forum

    Integration, Extension & APIs

    Get child nodes of a specific node from a tree cube with getHyperCubeTreeData

    Hi Everybody, I am trying to implement a hierarchical drop down menu in the mashup using enigma js. To get the data I am using a session object of typ... Show More

    Hi Everybody,

    I am trying to implement a hierarchical drop down menu in the mashup using enigma js. To get the data I am using a session object of type 'tree' and 'getHyperCubeTreeData' method. 

    The whole tree is quite large so I decided to extract it one level at a time (qDepth = 1) based on user's clicks (without selection). E.g. I only extract the children of the node that the user clicked.  

    The problem I have is I can't quite get how do I specify the qArea to extract only a specific node's children. I was trying to get qArea limits from a selected parent but apparently something is wrong there, the function returns random (as it seems) parts of the cube, the whole field or an empty array. 

    Could you please help me to specify the qArea parameter to get a specific node's children?

     

     

     

    const hierarchyObject= {
        qInfo: {"qType": "tree-list"},
        qTreeDataDef: {
            qDimensions: [
                { qDef: {  qFieldDefs: ['=[Field1]'], qNullSuppression : true} },
                { qDef: {  qFieldDefs: ['=[Field2]'], qNullSuppression : true} },
                { qDef: {  qFieldDefs: ['=[Field3]'], qNullSuppression : true} },
                { qDef: {  qFieldDefs: ['=[Field4]'], qNullSuppression : true} },
                { qDef: {  qFieldDefs: ['=[Field5]'], qNullSuppression : true} },
                { qDef: {  qFieldDefs: ['=[Field6]'], qNullSuppression : true} },
                { qDef: {  qFieldDefs: ['=[Field7]'], qNullSuppression : true} },
            ],
            qInitialDataFetch: [{
                //qMaxNbrOfNodes: 100,
                qTreeLevels: { qDepth: 1, qLeft: 0},
                qTreeNodes: [{qArea: {qLeft: 1, qTop: 0, qWidth: 100, qHeight: 100}, }]
            }],
            qMode: 'DATA_MODE_TREE',
            qOpenFullyExpanded: true,
            qSuppressMissing: true,
            qAlwaysFullyExpanded:true
        }
    }

     

     

     

    async function drillDown(node) {
            console.log(node)
            let leftOffset  = node.qTreePath.length+1;
            let topOffset   = node.qGroupPos; 
            let batchHeight = node.qGroupSize  ;
    
            console.log(leftOffset, topOffset, batchHeight)
            let obj = await hierarchyObject;
    
            let treeData = await obj.getHyperCubeTreeData({
                  qPath: `/qTreeDataDef`,
                  qNodeOptions: {
                    qMaxNbrOfNodes: 100000,
                    qTreeLevels: { qDepth: 1, qLeft:  leftOffset},
                    qTreeNodes: [ {qArea: {qLeft: 1, qTop: topOffset, qHeight: 1, qWidth: 1}}],
                  },
                });
    
            console.log(treeData)
            
        }

     

     

    Show Less
  • forum

    App Development

    Converting text field to date

    Hi, I have column that contains "date" written in txt format (Date_inv)  , how can I convert it to date format ? example: please fine attached sample... Show More

    Hi,

    I have column that contains "date" written in txt format (Date_inv)  , how can I convert it to date format ?

    example:

    smobariki_0-1674895708486.png

    please fine attached sample file

    Best regards,

    Sharbel

     

     

     

    Show Less
  • forum

    App Development

    set analysis with expression searches

    Hello everybody, I would like to write an expression that counts customers who placed orders worth more than 150 in a certain time frame. I wrote this... Show More

    Hello everybody,

    I would like to write an expression that counts customers who placed orders worth more than 150 in a certain time frame.

    I wrote this expression but it is wrong because the symbol " is repeated several times:


    Sum({$< customer_id={"=Sum({$<OrderDate={">=$(=Date(vStartDate))<=$(=Date(vEndDate))"}>} Amount)>150"} >} oneCustomer)

    What is the correct syntax to get the desired result?

    Thanks in advance

    Show Less
  • forum

    New to Qlik Sense

    hide row pivot table

    How do I hide a row in a PivotTable. For example:I have a table with a dimension and a measureDimension      MeasureA                         10B     ... Show More

    How do I hide a row in a PivotTable. For example:

    I have a table with a dimension and a measure

    Dimension      Measure

    A                         10

    B                         50

    C                         45

    I would like to hide the size equal to 'B'.

    Show Less
  • forum

    New to Qlik Sense

    Selective Dimensions in Pivot Table

    Hi Everyone, My data is like this I want to display the pivot table in a way that the Rows are not duplicated for the locations with '-' in them. Cur... Show More

    Hi Everyone,

    My data is like this

    mansoorsheraz_1-1674847587575.png


    I want to display the pivot table in a way that the Rows are not duplicated for the locations with '-' in them. Currently it looks like this:

    mansoorsheraz_0-1674847534879.png

    But I want that the + sign should not appear before the 19 Div 1 here as the location4 and location5 are '-' for it. I have tried using if condition and also the "Show column if" but they are not working. Any help is appreciated.

    Regards.

     

    Show Less
  • forum

    New to Qlik Sense

    Return a string in a Field from looking up a string in another Field

    Hi - I have what I think should be a relatively simple task to write a chart expression for, but have been unable to find a solution from searches. Ho... Show More

    Hi - I have what I think should be a relatively simple task to write a chart expression for, but have been unable to find a solution from searches. Hoping somebody can help.

    I have a table with two columns /Fields - Baseline and Release_Date

    Baseline                           Release_Date

    2022 Dec BOD 4             20/11/2022

    2022 Dec BOD 5             18/1/2023

    I already have a Variable that returns the latest date, 18/1/2023, from the Release_Date Field - vLatest_Release_Date = Date(Max([Release_Date])) - and I need an expression that returns the '2022 Dec BOD 5' by 'looking up' the Variable in the Baseline Field

    The Baseline Field format can have many different formats - the expression just needs to return what's there based on the Release Date.

    Many thanks, Richard

     

    Show Less
  • forum

    Qlik Application Automation

    How to teach myself about QlikView?

    I'm freelancing a little until the end of my education. I found a company that would hire me for a few days per month. Here is what will expect me: Th... Show More

    I'm freelancing a little until the end of my education. I found a company that would hire me for a few days per month. Here is what will expect me:

    They have a few different systems. All backed by some kind of RDMS. And there is a QlikView installation. Nothing more. QlikView is not configured to do anything, it's just installed on a dedicated server.

    Tney need a few reports, by aggregating data from different sources. They also want something like a daily export of the data.

    I have no QlikView experience, but would like to tackle the job. Are there any resources online to educate myself?

    Show Less
  • forum

    QlikView Administration

    Windows task Scheduler job not running in Qlik server

    Hi All, Greetings!! I have created a windows task using the service account and scheduled it on daily basis around 09:00 AM. below the batch file used... Show More

    Hi All,

    Greetings!!

    I have created a windows task using the service account and scheduled it on daily basis around 09:00 AM.

    below the batch file used:

    "D:\Program Files\QlikView\qv.exe" /l "\\naspqvlrd\QVSource\portfolio\Loading\financial.qvw"

    Issue: job did not start and status is showing in ready state only. While manually running the task its showing running but no result. Task history shows that Task scheduler completed successfully.

    Need more understanding of the below batch file:

    "D:\Program Files\QlikView\qv.exe" /l "\\naspqvlrd\QVSource\portfolio\Loading\financial.qvw"

     As per my understanding, it will open the qv.exe file(that is empty Qlikview file) first and opens the QVW file(financial.qvw) in that empty QV file which is provided in shared path.

    D:\Program Files\QlikView\qv.exe"

    Observations: I could see Qlikview software is installed/placed in the C:\Program Files\QlikView\qv.exe but not in the "D drive"(like above batch file path)

    is it the problem that unable to find the location of the QV file in C drive to run the job?

    appreciate your help!

    Regards,

    RickyK

     

    Show Less

Blogs

Community News

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

Blogs

Qlik Academic Program Blog

Read the latest blog around the Qlik Academic Program.

Blogs

Qlik Product Innovation Blog

If you want to know what's new across all of the products in our growing Qlik product portfolio.

Blogs

Support Updates Blog

Get the latest Support information about end-of-product support, new service releases, and general support topics.

Blogs

Qlik Design Blog

Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.

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

Events and Webinars

QlikWorld 2023!

Get ready for QlikWorld: The Conference for Data Thrill-Seekers. From exciting innovations to spine-tingling keynote presentations and lots of peer networking, you'll discover how you and your data can help your business succeed.

Find your city

Events and Webinars

Qlik and Qlik Community Hosted Events

Subscribe to our Events and Webinar page so you do not miss an event opportunity!

choose and register

Event

Welcome to Qlik

Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

On-Demand

Events

Upcoming Events and Webinars

There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

Upcoming

Events and Webinars

Qlik and Qlik Community Hosted Events

Subscribe to our Events and Webinar page so you do not miss an event opportunity!

choose and register

Event

Welcome to Qlik

Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

On-Demand

Events

Upcoming Events and Webinars

There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

Upcoming