Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
670 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

    Qlik Sense Enterprise Cloud SaaS and React.js CORS/CSP issues

    We've been setting up dashboards in the SaaS cloud solution for Qlik Sense Enterprise. Now we'd like to fetch and display such visualizations in our R... Show More

    We've been setting up dashboards in the SaaS cloud solution for Qlik Sense Enterprise. Now we'd like to fetch and display such visualizations in our React.js web app using the qdt-components package, either using the visualization API or Picasso. However, when I try the demo code (from https://github.com/qlik-demo-team/qdt-components/blob/master/docs/usage/React.md), I get CORS errors saying:

    Access to XMLHttpRequest at 'https://<our account>.eu.qlikcloud.com/api/v1/csrf-token' from origin 'http://our-app.loc:3000' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource.

    Access to XMLHttpRequest at 'https://<our account>.eu.qlikcloud.com/api/about/v1/language' from origin 'http://our-app.loc:3000' has been blocked by CORS policy: Response to preflight request doesn't pass access control check: The value of the 'Access-Control-Allow-Credentials' header in the response is '' which must be 'true' when the request's credentials mode is 'include'. The credentials mode of requests initiated by the XMLHttpRequest is controlled by the withCredentials attribute.

    WebSocket connection to 'wss://<our account>.eu.qlikcloud.com/app/<app id>/identity/wejlwWbvqWuKeIui?reloadUri=http%3A%2F%2Four-app.loc%3A3000%2Flogin' failed: HTTP Authentication failed; no valid credentials available

    I've noticed that all tutorials and most posts use the Windows server software, which seems to have settings for CORS/CSP as well as things like virtual proxies. How can we do this in the SaaS cloud version?

    If somebody could point us in the right direction, that'd be awesome!

    Show Less
  • Qlik Sense App Development

    Showing excluded values in a Qlik Sense table

    Hello Friends,Appreciate your time. I am looking for a solution to show the excluded values(in the grey color instead of disappearing) after making a ... Show More

    Hello Friends,

    Appreciate your time. I am looking for a solution to show the excluded values(in the grey color instead of disappearing) after making a selection in my Qlik Sense table.

    for example,

    let say I have the below table

     

    customer,units

    1,10

    2,20

    3,30

    4,40

    5,50

     

    In a QS table, when I click  the first row, the rest are all getting removed, Is there any way to show it in a gray color instead?

    I have attached a demo app for your reference

    below is my expression

    units: aggr(sum(qty),customer) 

    Thank you,

    Kiruthiga

     

     

     

     

    Show Less
  • New to QlikView

    Filter by Range using beginning and ending value

    Hi,I want to create a range filter where users can select the beginning year (from drop down menu) and ending year (from drop down menu) and get reven... Show More

    Hi,

    I want to create a range filter where users can select the beginning year (from drop down menu) and ending year (from drop down menu) and get revenue for those years.

    For example, data includes 2015 through 2019. But a user may want to select data from 2016 to 2018 and therefore input those years as beginning and ending years.

    Is this possible?

    Note: I am aware that I can create a list box but I am not looking for that.

    Thanks,

    CD

    Show Less
  • Qlik Sense App Development

    How to create a reference date from two interval dates in fact table

    Hello,I want a same situation , in my fact table (Contrat) , i have two date (begin_date and end_date) which mean begin en end of contrat identify by ... Show More

    Hello,

    I want a same situation , in my fact table (Contrat) , i have two date (begin_date and end_date) which mean begin en end of contrat identify by Contrat_ID.

    I want when a user choose one date (month , year or complete data) , application show a contrat that selected date is between begin_date and end_date contrat.

     

    Contrat:
    load * inline [
    Contrat_ID ,Home_Contrat_ID, begin_dade , end_date
    1,1,'01/01/2017','01/01/2018'
    2,2,'01/01/2014','01/01/2016'
    3,3,'01/11/2014','01/12/2014'
    4,4,'01/11/2014','01/12/2014'
    5,5,'02/09/2019',''
    ];
    // '' means blanck space, when the contrat is active
    // Contrat_ID = Home_Contrat_ID
    Resident:
    load * inline [
    Resident_ID ,Contrat_ID , first_enter_dade , out_date
    1,1,'01/01/2017','01/01/2018'
    2,5,'02/09/2019',''
    3,4,'01/01/2014','01/12/2014'
    4,2,'01/01/2014','01/12/2016'
    5,3,'01/11/2014','01/12/2014'
    ];

    Home:
    load * inline [
    Home_ID ,Home_Contrat_ID, home_type
    1,2,'T3'
    2,4,'T1'
    3,5,'T7'
    4,3,'T3'
    5,1,'1'
    ];

    DatamodelDatamodel

    Show Less
  • New to QlikView

    Defining set analysis in a variable and using the variable within the expression

    Hi, I am defining some set analysis in a variable like below..vSetAnalysisMonthYear={' & chr(39) & '$(vSelectedMonthYear)' & chr(39) &'}I now need to ... Show More

    Hi, 

    I am defining some set analysis in a variable like below..

    vSetAnalysis

    MonthYear={' & chr(39) & '$(vSelectedMonthYear)' & chr(39) &'}

    I now need to use this variable in the set analysis in the actual expression like below but i can't get it to work..

    Sum({<'$(vSetAnalysis)'>}Sales)

    Can anyone help to get this to work please?

    Show Less
  • Qlik Sense App Development

    two associations between tables different filters by constant type

    How to create this association for ShipTo and BillTo address associated to an order header? In T-SQL for Microsoft SQL Server, we use the following SQ... Show More

    How to create this association for ShipTo and BillTo address associated to an order header? In T-SQL for Microsoft SQL Server, we use the following SQL for reports.

    select h.cust_order_number, BillTo.Name, BillTo.Email, ShipTo.Name, ShipTo.State, ShipTo.Country

    from orders h

    left outer join addresses ShipTo on h.shipAddressRef = ShipTo.addressID and ShipTo.type = 'SHIP_TO'

    left outer join addresses BillTo on h.shipAddressRef = BillTo.addressID and ShipTo.type = 'BILL_TO'

     

    The first association is created correctly, when I pick the address table and apply a filter (i.e. type = 'SHIP_TO'). How do I pick the same table and apply a different filter for the BILL_TO? Qlik Sense Data Manager is replacing the first address and association, instead of making the second association as I intend. 

    Show Less
  • Qlik Connectors Discussions

    Unable to connect to database using qlickcloud

    In Qlik cloud I created new app with new connection to Microsoft Azure SQL database. Connection test worked fine. Then I was able to see the data thro... Show More

    In Qlik cloud I created new app with new connection to Microsoft Azure SQL database. Connection test worked fine. Then I was able to see the data through "Select data" option. Script was inserted without any issues as well. But then I try to load data I get this error message:

    The following error occurred:
    (Connector error: Unable to connect to database: Error message: Please check the values for Username‚ Password‚ Host and other properties. Description: General error)
     
    The same load script in Qlik Sense desktop version works fine. 
     
    Any ideas what can be wrong? 
    Show Less
  • QlikView Scripting

    Add all matched values from tables B and C to Table A

    Hi!! I've been having a really rough time trying to solve this but i keep on getting bad Data. The context is i'm trying to join Leads with effective ... Show More

    Hi!! I've been having a really rough time trying to solve this but i keep on getting bad Data. The context is i'm trying to join Leads with effective purchases, and i need all the values from the purchases to add on to the matching Social Security numbers on my Table of Leads (or another table alltogether) in order to understand conversion rate values.

    The challenge i'm trying to figure out is that in Tables B and C, sometimes the Social security numbers are duplicated because one person can be the buyer for several products, so I can only count the record once or I get crazy conversion rates (Ex: Google shows, for product B, 120% conversion rate with 40 leads, and more than 40 sales because it isnt de-duplicating correctly with "DISTINCT")

    What I need to figure out is how to load the following so that the Lead, that has richer data, joins with the sales data from tables B and C.

    Here's an example of the data i'm loading:

    Table A (LEADS):

    SOCIAL SECURITY NUMBER,

    Origin Platform (Facebook/Google/ETC),

    Name,

    Last Name,

    If lead is PAID or ORGANIC,

    PRODUCT INTERESTED IN (between A and B),

    DATE

    TABLE B (PURCHASES PRODUCT A):

    SOCIAL SECURITY NUMBER (OF PURCHASER),

    DATE (OF PURCHASE),

    TABLE C (PURCHASES OF PRODUCT B):

    SOCIAL SECURITY NUMBER (OF PURCHASER),

    DATE (OF PURCHASE).

     

    Can anybody help me solve this? It's eating my brain away.

    Show Less
  • New to QlikView

    Can we enable Status->Task tab in qlikview QMC for specific users

    Hi All,Can we enable Status->Task tab in qlikview QMC for specific users. Basically we need to provide only privilage to specific users run their task... Show More

    Hi All,

    Can we enable Status->Task tab in qlikview QMC for specific users. Basically we need to provide only privilage to specific users run their tasks in QMC. Not to touch anything in Qlik view QMC.

    Show Less
  • QlikView App Development

    Troubleshooting RangeSum variables

    I thought I understood RangeSum was able to ignore a value that doesn't calculate, like if adding up field1 + field2 + field3 and one of the fields is... Show More

    I thought I understood RangeSum was able to ignore a value that doesn't calculate, like if adding up field1 + field2 + field3 and one of the fields is null or not numbers.

    I am trying to use RangeSum(var1,var2,var3) to add up three variables and it is not working .... I can't figure out why. The var1, var2, and var3 are calculating fine. I can see them when I put them in separate expressions by themselves.  When I change from RangeSum to var1 + var2 + var3 it works correctly. Why? 

    I'm not using any of the powerful parts of RangeSum for accumulation or anything like that. Nothing fancy at all. The variables I have are just large-ish expressions and I need to add some of them together, so instead of repeating the expressions, I use the variables. 

    I am using QlikView 12.4. Any help or suggestions are appreciated, thank you.

    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