Qlik Community

Welcome to Qlik Community

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

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.

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

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 eight unique blogs. Check out the new Architecture Deep Dive Blog!

Find a forum to ask a question or start a discussion.

Discussion Boards and Documents for Qlik Services.

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

Discussion board and documents related to Qlik Associative Big Data Index.

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.


Make Your Data Dance - Virtual Forum 2019

You’re managing more data than ever before. But are you getting the insights you need? The Qlik Virtual Forum is here to help you take control and make your data dance.

Recent Discussions

  • Qlik Sense Data Connectivity

    Performance issue using Qlik Sense virtual proxy

    Hi All,I do have 2 virtual machines in Azure. One is DEV Qliksense machine and the other is restored machine from the back up of DEV (using Azure back... Show More

    Hi All,

    I do have 2 virtual machines in Azure. One is DEV Qliksense machine and the other is restored machine from the back up of DEV (using Azure backup). Now both machines have the same computer name but different IP's.

    Our requirement is to use the restored machine when DEV system faces a disaster and we make only one machine active at any time. So we have given the same DNS name(devqlik.xxx.client.com) to both the machines. QlikSense URL "https://devqlik.xxx.client.com/hub" or "https://devqlik.xxx.client.com/qmc" can be accessed using both the machines. Only after setting the same DNS name we are facing terrible performance issue (around 4min) accessing hub or QMC. This issue is only when the virtual proxy is used and not with the local host URL. (http://10.xx.xx.xx/hub or http://10.xx.xx.xx/qmc)

    Please note we have stopped/deallocated restored machine and only DEV machine is running. Even if only one machine is running we are facing this issue. 

    Please assist on how to solve this issue.

    Show Less
  • Qlik Sense Deployment & Management

    Qliksense unexpected token error

    Hello, I am running into an error when trying to store data into a QVD file - Attached are some screenshots with the error"Unexpected token:... Show More

    Hello,

     

    I am running into an error when trying to store data into a QVD file - 

    Attached are some screenshots with the error

    "Unexpected token: 'frc_qliksensesvc', expected one of: 'qvd', 'txt', 'qvx', 'delimiter'"

    Anyone have any idea what am I doing wrong?

     

    Thanks,

    Gilad

    Show Less
  • New to Qlik Sense

    How to add colour to expression?

    Hi experts,Can anyone tell me how to adjust the below expression so that 'Pass' is green and 'Fail' is red?=IF(Count({<SLAMet= {'Yes'}>} SLAMet)... Show More

    Hi experts,

    Can anyone tell me how to adjust the below expression so that 'Pass' is green and 'Fail' is red?

    =IF(Count({<SLAMet= {'Yes'}>} SLAMet)/Count(SLAMet)>.98,'Pass','Fail')

    Thanks!

    Show Less
  • New to Qlik Sense

    Agregar una columna con el valor del mes del año anterior

    BuenasPor favor podrían ayudarme, tengo una tabla con campo de fecha y uno de valores, lo que necesito hacer es comparar cada mes con su mes correspon... Show More

    Buenas

    Por favor podrían ayudarme, tengo una tabla con campo de fecha y uno de valores, lo que necesito hacer es comparar cada mes con su mes correspondiente pero en el año anterior.

    Esta es la tabla que tengo, la columna que necesito agregar es COMPARACION, pero no se como hacerlo.

    [Reference Date]NTTValidadoCOMPARACION
    ene. 20185900
    feb. 20185470
    mar. 201810280
    abr. 201814630
    may. 201812570
    jun. 201811830
    jul. 201810
    ago. 20189340
    sept. 201810
    oct. 201810
    nov. 201811260
    dic. 201810280
    ene. 20191189590
    feb. 20198547
    mar. 2019132018
    abr. 20193571463
    may. 20194531257
    jun. 20192681183

     

    Si alguien tiene alguna idea se lo agradecería.

    Show Less
  • New to Qlik Sense

    SQL Query works in SQL Management Studio but not in QlikSense

    Hi Guys!I have a SQL Server Query that works fine in SQL Management Studio. It returns a table with data.When i use the same query in Qlik Sense it re... Show More

    Hi Guys!

    I have a SQL Server Query that works fine in SQL Management Studio. It returns a table with data.

    When i use the same query in Qlik Sense it returns an error: "Connector reply error: ErrorSource: Unknown source, ErrorMsg:Unknown description".

    I´m using Microsoft OLE DB Provider for SQL Server.

    Attached are both codes

    Please help!! Thanks in advance!

    Marcos

     

    Show Less
  • Qlik Sense Deployment & Management

    Qlik Sense does not detect previous version

    hi collegues, I have a problem when I try to update to the version of April 2019, it does not appear the option to update, it seems like it did not de... Show More


    hi collegues, I have a problem when I try to update to the version of April 2019, it does not appear the option to update, it seems like it did not detect the previous version (November 2019 patch 1),in the attachment are the images.Installing.pngServices.pngVersion.png

    note: the shared folder is on another server

     

    Show Less
  • QlikView Management

    Data Refresh through QMC showing incorrect data

    Hi All,I am facing a problem with the data refresh through QMC. When I reload the dashboard manually through Qlikview it shows Correct data in all the... Show More

    Hi All,

    I am facing a problem with the data refresh through QMC. When I reload the dashboard manually through Qlikview it shows Correct data in all the charts. However when I refresh the dashboard through QMC the values changes drastically in all the charts. 

    I have checked if any filter is being applied by refreshing through QMC, but there isn't any.

    I have also removed last document state through Access point to no avail.

    Can anyone help?

    Show Less
  • New to Qlik Sense

    Getting Cumulative Percentage from a breakdown of a field

    Hello experts, I have items for 3 months and they are under same "month" field but grouped by April, May, June. Under each month, there are ... Show More

    Hello experts, 

    I have items for 3 months and they are under same "month" field but grouped by April, May, June. 

    Under each month, there are managers and there are employees under each manager. 

    What I'm trying to do is getting percentage that accumulates from employees to manager then to  each month. 

    Eventually totaling up to 100%.  

     

    I can get the percentage breakdown of employees, but it doesn't accumulate accordingly. Also, The table sums all the items for all 3 months and gets the percentage which give me around 30% for each month.  I want sum of total items separately so it will give me total of 100% for each month but I can't figure out how.

    Here is the expression that I used 

    SUM([Item1])/Sum(total<Employees, Manager>Item1)

    and there is the snapshot of part of my pivot table. Thank you for your help!

    Untitled.jpg

     

    Show Less
  • QlikView Management

    Updating QlikView Desktop version 12.10 SR 1 url not found

    Hi!I'm trying to update my outdated version of QlikView Desktop (v. 12.10 SR 1) and I get the following error: http://www.qliktech.com/UpdateURL ... Show More

    Hi!

    I'm trying to update my outdated version of QlikView Desktop (v. 12.10 SR 1) and I get the following error: http://www.qliktech.com/UpdateURL not found.

    Might this be caused by the change from qlikview to qlik?

    If so, how can I determine the download url?

    Show Less
  • Qlik Sense App Development

    Current Year Vs Prior Year Script

    Hiya,  I'm looking to add in the script a bit to categorise as prior year vs current year. So all my files are labelled the same With t... Show More

    Hiya, 

     

    I'm looking to add in the script a bit to categorise as prior year vs current year. 

    So all my files are labelled the same With the differences being the Month and Year. 

    What I would like to be able to do is have Qliksense identify that the latest file in date is May 2019, and that is categorised as Current Year, and then have it find the one that's May 2018 and have that categorised as Prior Year so I can compare the two in multiple tables. 

    I can't seem to find something a previous thread that works/gives me what I need, but I have got Qlik to recognise the May 2019 etc as a date and this is my script to do that.

     

    Script.PNGSJL snip.PNG

    Please could someone help? 

    Thanks

    Show Less

Blogs

Qlik Community Blogs

Check out our community blogs to stay current on the latest and greatest information about Qlik products.

7 Blogs

Groups

Join a Group

Join one of our Qlik Community groups related to an Industry, Location, Language, or Topic.

28 Groups

Events

Events & Meetups

Participate in an upcoming Qlik related event, webinar, or local meetup.