Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
2,011 online

Find the forums for your Qlik data analytics products to ask a question, start a discussion, or review documentation.

Find the forums for your Qlik Data Integration products to ask a question, start a discussion, or review documentation.

This forum will provide you with event highlights and related content to get you energized and ready for Qlik’s largest customer and partner event of the year.

Here you will find Qlik Sense resources, partake in interesting discussions, solve problems and foster relationships with Qlik experts from around the globe.

Thank you for joining us in the QlikView Forum, your home for QlikView answers. Discover insights within your data that can transform your business.

Discussion Boards and Documents for Qlik Services.

Join one of our Qlik Community Groups. Anyone can view content in Open Groups, but you must join to participate. Closed Groups require joining in order to view content and participate.

Hear directly from Qlik employees in our nine unique blogs. Check out the new Customer Success Blog!

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

Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.

Learn about the Qlik Community. Explore 'How-To' documentation, ask questions, and engage in discussion around the community platform. This will also be the place where, from time to time, we will do some fun things.

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

Recent Discussions

  • New to Qlik Sense

    How to get drill dimension field in Variable in Reference line expression

    Hi all,I  have a drill down country -> City -> Store in scatter plot . And i am counting the dimension field value in variable in reference line expre... Show More

    Hi all,

    I  have a drill down country -> City -> Store in scatter plot . And i am counting the dimension field value in variable in reference line expression For example:  count (drilldown) . I am having challenge in variable, In drill down dimension  if the value is one,  it will automatically drill into next level . So it is  hard to get the exact dimension in variable .

     

    Please help me on this.

     

     

     

    Show Less
  • New to Qlik Sense

    Filtering Data

    Hello I need to get a count of Inventory, description and breakdown of inventory received date so that I can filter items with an aging of more than x... Show More

    Hello I need to get a count of Inventory, description and breakdown of inventory received date so that I can filter items with an aging of more than x months. I can get a count of inventory and description but am at a loss om how to filter according to aging. My fields are InventoryName, Description, InventoryDescription and ReceivedDate. Any suggestions would be appreciated 

    Show Less
  • New to Qlik Sense

    Circular References for Date

    Hi Everyone, i want to add forecast data (top left) to our data model but i always get a circular reference which i can not solve. How can i associate... Show More

    Hi Everyone, i want to add forecast data (top left) to our data model but i always get a circular reference which i can not solve. 

    How can i associate my forecast data to a date if not like this?Screenshot 2020-02-21 at 15.51.57.png

    Show Less
  • Qlik Sense App Development

    Dynamic Table: don´t show the search glass

    Hello everyone,I´m developing a Financial Flow using a Dynamic Table because I need to navigate down the structure. But I don´t need the user to chang... Show More

    Hello everyone,

    I´m developing a Financial Flow using a Dynamic Table because I need to navigate down the structure. But I don´t need the user to change the order of the levels or to search words. So, I Woldn´t like to show the icons of the search glass (above). Can I exclude them? (example attached)

     

    Show Less
  • QlikView App Development

    Bubble size by slider

    Hello,  I have created a scatter chart.  The size of the bubbles is based on cost.  I have created a slider by percentages to increase or decrease the... Show More

    Hello,  I have created a scatter chart.  The size of the bubbles is based on cost.  I have created a slider by percentages to increase or decrease the cost. When I hover over the bubble after I slide the slider to a different percentage I see that the cost changes correctly but the bubble size doesn't.  What am I doing wrong?  If anyone could point me in the right direction.

    Thanks!

    Show Less
  • New to Qlik Sense

    If Statement with dates

    Hello dear experts,I have a field called Fecha as a date, i'm trying evaluate it with a rate of dates depending of the value which evaluating Date fie... Show More

    Hello dear experts,
    I have a field called Fecha as a date, i'm trying evaluate it with a rate of dates depending of the value which evaluating Date field, once i  try to load data the next error comes(Attached image).
    Loaderror.PNG

    if(Fecha<Date(30/01/2015,'DD/MM/YYYY'),
    if(PM < PE15,1,0),
    if(Fecha>= Date(06/01/2016,'DD/MM/YYYY'),
    if(PM < PE16,1,0),
    if(Fecha<= Date(10/05/2016,'DD/MM/YYYY'),
    if(PM < PE161,1,0),
    if(Fecha<= Date(17/11/2017,'DD/MM/YYYY'),
    if(PM < PE17,1,0),
    if(Fecha<= Date(29/04/2019,'DD/MM/YYYY'),
    if(PM < PE,1,0)
    )
    )
    )
    )
    ) as Sub_PE


    Thanks for help.

    Regards.

    Show Less
  • New to Qlik Sense

    Script Looping or ways to make more efficient?

    Hi all,I have the following script. I need to load a 'Code' and a 'Rate' from a table. From there, I need to associate that code with both 'Group 3' a... Show More

    Hi all,

    I have the following script. I need to load a 'Code' and a 'Rate' from a table. From there, I need to associate that code with both 'Group 3' and 'Group 4' Group, and a 'Location A' and 'Location B' Flag. The script below works fine, but I end up loading the same data 4 times. I do this same type of thing repeatedly throughout my script, so I was wondering if there was more efficient way to do this with a loop or variable or something of the sort. Any help would be appreciated. Thanks!

    LOAD
    'Group 3' as "Group Flag",
    text("Code") as Procedure,
    'Location A' as "Flag",
    Rate
    FROM [lib://table.xlsx];
    LOAD
    'Group 3' as "Group Flag",
    text("Code") as Procedure,
    'Location B' as "Flag",
    Rate
    FROM [lib://table.xlsx];

    LOAD
    'Group 4' as "Group Flag",
    text("Code") as Procedure,
    'Location A' as "Flag",
    Rate
    FROM [lib://table.xlsx];
    LOAD
    'Group 4' as "Group Flag",
    text("Code") as Procedure,
    'Location B' as "Flag",
    Rate
    FROM [lib://table.xlsx];

    Show Less
  • Qlik Sense App Development

    Help with Average of Averages in Reference line

    I have a bar chart that shows the average hours spent on audits by team name in the "Reporting" phase of the project.I'm only interested in hours logg... Show More

    I have a bar chart that shows the average hours spent on audits by team name in the "Reporting" phase of the project.
    I'm only interested in hours logged in United States audits where the field RscActuals='Y'.

    Since I am only interested in audits >= 2019, my Dimension is:  

    =if([Audit Year]>=2019,[Lead Team])

    My expression includes set analysis and looks like this:

    Sum({<[Audit Task]={"Reporting"}, RscActuals={'Y'}, [Audit Region]={'United States'}>} Hours) /Count({<RscActuals={'Y'}, [Audit Region]={'United States'}>} DISTINCT [Audit ID])

    In QlikView I had an "Average" reference line (built in) that I am trying to replicate in QS.

    I have searched through the posts to find some help, but nothing is working for me.

    It should be something like:

    Avg(Total Aggr(
    Sum({<[Audit Task]={"Reporting"}, RscActuals={'Y'}, [Audit Region]={'United States'}>} Hours)/Count({<RscActuals={'Y'}, [Audit Region]={'United States'}>} DISTINCT [Audit ID])
    , [Lead Team]))

    But I can't get it to work.  Please help!

    Show Less
  • Qlik Sense App Development

    Set Analysys com variáveis

    Boa noite.Ainda iniciante no Qlik, estou com dificuldades no Set Análises.Preciso selecionar o mês de consulta a partir do dia corrente e gostaria de ... Show More

    Boa noite.

    Ainda iniciante no Qlik, estou com dificuldades no Set Análises.

    Preciso selecionar o mês de consulta a partir do dia corrente e gostaria de fazer essa seleção no Set Analysis, mas consegui com IF:

    Criei uma variável que indica o mês a ser consultado:

    1) vMesConsulta = IF ( DIV((Num(day(today()))),20)=1, num(month(today()))-1,  num(month(today()))-2)

    Peguei a parte inteira da divisão por 20:
    de 20 a 31 o resultado é 1 e vMesConsulta = Mes Anterior (Mês-1).
    de 1 a 19 o resultado é 0 e vMesConsulta = 2 Meses Atrás (Mês-2).
     
    2) Usei a variável em uma cláusula IF
    =(Sum  ({1}  IF(ano_referencia=year(now()) AND mes_referencia<=vMesConsulta, valor_liquido
    )/1000000))
     
    Funciona, mas me parece que no Set Analysis seria mais adequado, com melhor performance.
     
    Alguém tem uma dica? Pode usar a variável vMesConsulta, que facilitaria a expressão, desde que fique no Set Analysis...
     
    Obrigada.
     

     

     

    Show Less
  • Qlik Sense Deployment & Management

    Irregular, and super long startup time using mashups

    We are experiencing unacceptable long startup times when opening a mashup for the first time. As in the range 5-15 seconds. To narrow down the scope, ... Show More

    We are experiencing unacceptable long startup times when opening a mashup for the first time. As in the range 5-15 seconds.

     

    To narrow down the scope, we have tried jMeter to test repeatedly downloading the two request taking the most time:

    • /resources/assets/external/requirejs/require.js
    • Open the websocket 

    Most requests (50-60%) take less than 100 ms, both require.js and the websocket. Fine.

    25% of the requests are in the interval [100 ms, 1000 ms]. Far from great, but ok.

    The rest spread out between 1 to 5 seconds. Per request. Some requests taking as long as 10 seconds to complete.

     

    Below is a sample of a test run today. We run 20 iterations, wait a minute, 20 new iterations, etc. (Always waiting 100 ms between each request.)

     

    Y-axis is time of the request, in seconds.

    2019-01-14 - Test runs.png

     

    If we zoom in on four of the runs, you better see the spread.  There is an indication that the first requests are generally slower than at the end of a test run. But this is not always the case (like test run 3 in the image below).

    2019-01-14 - Test runs - Zoomed.png 

    We cannot find any other pattern correlating to any other known events. Apart from that there seem to be a correlation between the time opening the websocket and the time it takes downloading the require.js.

     

     

    Does anyone have any ideas on how to divide and conquer this problem? 

    Do you have any idea how to test if it is: Qlik? NodeJS? The OS? The disk? The VM? The Network?

     

     

    We are running Qlik Sense and Qlik QAP on Windows 2016 64-bit, 32GB RAM.

    It is virtual, but with dedicated memory, disk and CPU.

    The test above is removing the mashup and the data model completely from the equation.  It is just looking at opening the connection, and getting a fixed file.

     

    What are your response times? Similar?

     

     

    Any feedback appreciated!

     

    Cheers,

    Vegard 🙂

    Show Less

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for October and November 2019.

Blogs

Qlik Support Updates Blog

Read the latest blogs from Qlik Support and get important and useful support information.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

Groups

Join a Group

Join one of our Qlik Community user groups around an Industry, Location & Language, or Topic.

Groups

Qlik Deployment Framework

This group hosts information related to the Qlik Deployment Framework (QDF).

2700+ Members

Groups

Qlik Healthcare

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

750+ Members

Events

Qlik World 2020

Transform your digital world. Join us for our annual conference (formerly Qonnections) in Phoenix, AZ. Register by February 29th to save $200.

May 11- 14, 2020 Global Conference

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


Events

Qlik Insider: What's New in 2020?

Join us on for a deep-dive discussion and tailored product demonstration on the newest capabilities delivered as part of Qlik’s most recent product release.

February 26, 2020