Qlik Community

Welcome to Qlik Community

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

  • Qlik Sense Deployment & Management

    How to approve sheet to add to base sheet.

    We have Nov 2018 QlikSense version. I am root admin.Question:How do I approve either User created sheet or Community sheet to base app.  Currently I a... Show More

    We have Nov 2018 QlikSense version. I am root admin.

    Question:

    How do I approve either User created sheet or Community sheet to base app. 

     

    Currently I am not able to see any sheet that user has created. 

     

     

    Show Less
  • New to QlikView

    Script Key between tables

    I have two tables on the Script:Telehone_table:loadTelephone,Campaing_code,Campaing_descrip,Campaing_start_date,Campaing_end_date Telephones_records:T... Show More

    I have two tables on the Script:

    Telehone_table:

    load

    Telephone,

    Campaing_code,

    Campaing_descrip,

    Campaing_start_date,

    Campaing_end_date

     

    Telephones_records:

    Telephone,

    Date,

    Calls,

    Sales

    The most obvious will be to do  use Telephone as KEY but  the problem here is that Telephones are reused over time for new campaings, so there is a list of about 50 telephones whereas they are reused for Campaings over time. How to link those tables by a convination of Telephone, Campaing_start_date and Campaing_end_date?

    Here is a small sample of each table

    Telephone_table:

    Telephone,       Campaing_code,      Campaing_descrip,     Campaing_start_date,     Campaing_end_date

    1001 (*)                    001                                 Campaing1                      01/01/2019                            15/01/2019

    1001                     002                                  Campaing2                      16/01/2019                             23/01/2019

    .....                           ......

    Note (*): Watch that the same telephone number 1001 is reused for Campaing1 and Campaing2

    Telephone_records:

    Telephone,           Date,                      Calls,           Sales

    1001                       01/01/2019          20                   3

    1001                       02/01/2019          25                   6

    .....                            .....

    Thanks in advance!!!

     

     

    Show Less
  • Qlik Sense SaaS & Multi-Cloud

    Qlik Sense Business Download Pivot Table to Excel

    Hello everyone,Recently I have moved my client from Qlik Sense Cloud to Qlik Sense Business and it was a great upgrade as Qlik Sense Business has much... Show More

    Hello everyone,

    Recently I have moved my client from Qlik Sense Cloud to Qlik Sense Business and it was a great upgrade as Qlik Sense Business has much more features and more user friendly.

    The one issue however we are having is export pivot table to excel. When you download Pivot table with multiple rows and columns qlik downloads entire data where all the columns and rows are expanded what makes excel impossible to read or work with.

    I am attaching a picture of pivot table in Qlik and the excel file that have been downloaded so you can see the outcome.

    Is this a bug that will be fixed soon as my client is very upset with that and I am sure there will be more?

    Please help

    Excel Download:

    excel download.JPG

    Pivot on Qlik

    Pivot in Qlik.JPG

     

    Show Less
  • New to Qlik Sense

    Risk Chart Creation

    I am new to using qliksense and we just now started trying to incorporate it into our workflows at my place of employment. I was wondering if it is po... Show More

    I am new to using qliksense and we just now started trying to incorporate it into our workflows at my place of employment. I was wondering if it is possible to create an interactive F-N chart (like what is shown below) in qlik sense that can be filtered based on the data that is in an excel spreadsheet?

     

    F-N chart for dam safety.png

    Show Less
  • Community Corner

    Using set analysis to analyze data only in the latest report date

    Hi,I'm working on a database of reports that get generated every day. Each day, for one of the charts, I would like to see the analyzed data only for ... Show More

    Hi,

    I'm working on a database of reports that get generated every day. Each day, for one of the charts, I would like to see the analyzed data only for the latest report date. 

    For example. in a particular table, I would like to see the sum of EstSales according to various groups of products, but only for the latest report date.

    I've used the following formula but it gives me an error.

    Sum({$<[Report Date]={max([Report Date])}>} EstSales)

     

    If I substitute max([Report Date]) with the actual date '21/01/2020', using the following code below, the formula works fine. But this would entail me changing the date in the formula manually daily.

    Sum({$<[Report Date]={'20/1/2020'}>} EstSales)

    Interestingly, the formula max([Report Date]) works fine when I'm trying to display this in the title of the chart. But somehow does not work in the expression i'm using for the calculation

    Eg. ='Jobs by Part Number as of ' & max([Report Date]) shows up as "Jobs by Part Number as of 21/1/2020"

    Is there something wrong with my set analysis formula or do I need to use a different date formula to achieve the correct result?

     

    Thanks very much!!

    Show Less
  • Qlik Sense App Development

    Section Access only allowing USER or ADMIN, but not both.

    Hi,I have an odd issue with my section access.  Only ADMINs are getting access (not USERs), so I loaded my section access into a table to see what it ... Show More

    Hi,

    I have an odd issue with my section access.  Only ADMINs are getting access (not USERs), so I loaded my section access into a table to see what it was doing. That's when I discovered if I include a mix of ADMIN and USER users, only the ADMIN ones are loaded. If I change it to be only USER (or even add in some others like TEST, DUMMY etc) , then it loads everything. I've tried loading the section access inline and also from an xlsx file.

    My section access script:

    Section Access;

    LOAD * inline [

    ACCESS,USERID,COST_CENTRE
    ADMIN,ABCDE\abc1111,*
    USER,ABCDE\def2222,1000
    USER,ABCDE\ghi3333,2000
    ];

    section application;

    My table script:

    TEST:
    LOAD * inline [
    ACCESS,USERID,COST_CENTRE
    ADMIN,ABCDE\abc1111,*
    USER,ABCDE\def2222,1000
    USER,ABCDE\ghi3333,2000
    ];

    So my question is, how am I supposed to have ADMIN and USER in section access? Or am I supposed to only have ADMIN or USER, not both?

    Show Less
  • Qlik Sense Deployment & Management

    User Created sheet is not view able for Root admin, how to approve

    We have published dashboard where user has created community sheet and now wants me (admin) to make this part of Base sheet.Question:When i go to view... Show More

    We have published dashboard where user has created community sheet and now wants me (admin) to make this part of Base sheet.

    Question:

    1. When i go to view app in published stream as a ROOT ADMIN should be able to see all the user created sheet? Currently this is not the case. I am not able to see all the sheet users created only the ones that were posted in community. When i Right click on community sheets, I don't get "Approve" option. 
    2. If answer is NO to above question then how do you approve sheets as admin for other users. 
    3. what is the correct process and how do rest of Admin in community handle this process. 

     

    New to QlikSense, thx for help. 

    Show Less
  • Qlik Sense Advanced Authoring

    Qlik sense desktop to Qlik Sense cloud

    Hi All,Our database is on Sql Server Management Studio. And we use R Script too. We were using Qlik sense Desktop but recently we decided to migrate f... Show More

    Hi All,

    Our database is on Sql Server Management Studio. And we use R Script too. We were using Qlik sense Desktop but recently we decided to migrate from Qlik Sense Desktop to Qlik Sense cloud. Could you please suggest the system specification required?  What is the common practice to use - qvd or csv files?

    Thanks beforehand.

    Kind Regards

     

     

    Show Less
  • Qlik Sense SaaS & Multi-Cloud

    Qlik Sense Cloud to On-premise

    Hi,Recently a client decided to migrate from Cloud to On-premise. We applied a signed license key (the same as used on Cloud); after assigning the lic... Show More

    Hi,

    Recently a client decided to migrate from Cloud to On-premise. We applied a signed license key (the same as used on Cloud); after assigning the licenses (professional), the following error appears 'you have no access pass'. We tried with analizer license too on published apps, but nothing seems to work.

    Can someone explain me what I'm missing?

     

    Show Less
  • QlikView App Development

    Qlik Market is down?

    Hi is the Qlik Market website broken?Everytime I access it nothing loads and I can't search anything:https://market.qlik.com/

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 January 31, and save $300.

May 11- 14, 2020 Global Conference

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


Events

Customer Spotlight Series

Discover the secrets behind data-driven transformation with real-world examples from Qlik customers.

Watch the Series Today