Qlik Community

Welcome to Qlik Community

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

    Qliksense App

    Hi All,I want to Share my Qliksense App to the Another  Machine.But the thing is I don want others to see the source code which I have written in the ... Show More

    Hi All,

    I want to Share my Qliksense App to the Another  Machine.

    But the thing is I don want others to see the source code which I have written in the Script. I just want them to use the UI/charts/table which I used in the App.

    How can I do this?

    Show Less
  • New to Qlik Sense

    Importing from file on Hard Disk

    Hi, I am desperately trying to fight my way through creating a new dashboard and have come across a show stopping problem which, after 3 or 4 days of ... Show More

    Hi, I am desperately trying to fight my way through creating a new dashboard and have come across a show stopping problem which, after 3 or 4 days of searching, I just cannot find any help on.  I am successfully importing data from Excel files, which are stored in a folder on my hard disk by dragging and dropping them in the data load screen, however I cannot point the script to these files.  I want to be in the situation where I can save new source data, overwriting the existing files, and then simply click "reload" in the dashboard, and see the new data.  Can anyone please advise what I am missing, and obviously what extra information you need.
    I am using a qliksense cloud based dashboard as I think I can do this in the desktop, but keep receiving warnings the desktop version is ceasing to be used.
    Many Thanks in advance, Paul

    Show Less
  • Qlik Replicate Discussions

    Delay in replication

    I am replicating from Oracle 11g to Azure SQL DB (using redo logs). I have only just set this up within the last few days, but I have noticed very big... Show More

    I am replicating from Oracle 11g to Azure SQL DB (using redo logs). I have only just set this up within the last few days, but I have noticed very big gaps in the delay of processing. i.e. I can see changes in my source DB, but they aren't being picked up by Replicate for sometimes 1 hour or more.

    Show Less
  • Qlik Replicate Discussions

    Bulk apply operation failed

    I am getting many of the below errors in my task log. My source is Oracle 11g and target is Azure SQL DB. The updates do indeed get applied, but I wou... Show More

    I am getting many of the below errors in my task log. My source is Oracle 11g and target is Azure SQL DB. The updates do indeed get applied, but I would prefer they are done in bulk (much faster)

    00003336: 2020-02-20T13:48:35 [TARGET_APPLY ]I: Bulk apply operation failed. Trying to execute bulk statements in 'one-by-one' mode (bulk_apply.c:2312)
    00003336: 2020-02-20T13:48:35 [TARGET_APPLY ]I: Applying UPDATES one-by-one for table '<tablename>' (56) (bulk_apply.c:4810)
    00003336: 2020-02-20T13:48:35 [TARGET_APPLY ]I: Switch back to bulk apply mode (bulk_apply.c:4907)

    Show Less
  • QlikView App Development

    Compare 2 quarters of different years in multiple years

    Hello ExpertsI need to compare results of each quarter + year to its previous quarter + year. I tried different options suggested on community but it ... Show More

    Hello Experts

    I need to compare results of each quarter + year to its previous quarter + year. I tried different options suggested on community but it didn't helped as i have customer and other dimension to it. here is the data.

    CustaccountInvoicedateAmount
    A01-04-201410000
    A01-08-201450000
    A02-04-20152600
    A02-09-201545843
    A10-09-201611465
    B02-05-201655787
    B03-05-201654411
    C04-01-20185570
    C05-01-20185688
    C05-02-201855554
    C09-12-201826898
    D03-03-2019456328
    D04-03-2019224698
    D22-01-20185544

    2020-02-13_15h09_26.png

    I got above results with Pivot Table. For me the next step is to get the difference of each quarter compared with earlier year quarter like below--- yellow marked2020-02-13_15h16_23.png

     

    Please help out... Thanks

    Show Less
  • Qlik Sense App Development

    Restrict identifier

    I want to Resident Load the [Assessment] table to the [Limited Assessment] table while restricting every record in the [Limiter] table. The [Limiter] ... Show More

    I want to Resident Load the [Assessment] table to the [Limited Assessment] table while restricting every record in the [Limiter] table. The [Limiter] table is an excel workbook that looks like this but with many more records. Can you help?

    Identifier

    Inches

    Measure 5

    270

    Measure 8

    85

    Measure 10

    67

    Measure 11

    500

    Measure 13

    325

    Measure 14

    59

    Measure 15

    63

    Measure 17

    35

     


    [Assessment] :
    Identifier,
    Inches
    FROM [lib://Capacity/Sheet1.xlsx

     

    [Limit Assessment] :
    Identifier,
    Inches
    RESIDENT [Assessment] ;
    DROP TABLE [Assessment] ;

    Show Less
  • New to Qlik Sense

    Installing Qlik Sense through Userdata in EC2 AWS

    Hello All,We are trying to install the qlik sense Feb 2019 through the userdata of EC2 instances in AWS. We are passing required service/domain users ... Show More

    Hello All,

    We are trying to install the qlik sense Feb 2019 through the userdata of EC2 instances in AWS. We are passing required service/domain users to the exe and it is failing to validate the service user.

    To be clear, when we run this using userdata, it will be executed via system admin user. And the error comes is below,

    [11EC:1348][2019-04-04T09:50:10]i000: PREREQUISITE CHECK: Service user validation failed.

    [11EC:1348][2019-04-04T09:50:10]i000: PREREQUISITE CHECK: Qlik Sense cannot be installed as Local System.
    [11EC:1348][2019-04-04T09:50:10]i000: About to quit this session (with exit code -1000).

    Is there anyway to install differently in the userdata in AWS EC2?

    Thanks,

    Karthick

     

    Show Less
  • New to Qlik Sense

    Unable to load .xlsx file

    I appear to be getting this error when I'm trying to load a .xlsx file, this error appears when using both the load editor and the data manager. 
  • New to Qlik Sense

    Dynamic load from multiple CSV; source data has duplicate field names

    I have multiple CSV files with slightly different columns that I wish to concatenate load into a single table. Each file contains approximately 120 co... Show More

    I have multiple CSV files with slightly different columns that I wish to concatenate load into a single table. Each file contains approximately 120 columns.

    Unfortunately, the source files also contain multiple "Filler" columns (header = "Filler").

    So, this fails:

    [SDE]:
    Load * Inline [
    SDE
    ];

    // This method won't work, because the file is littered with "Filler" columns (field names must be unique)

    For Each File in Filelist('$(vPath)/$(vFileMask)')

    SET vFile = '$(File)';

    Concatenate
    LOAD *
    FROM [$(vFile)]
    (txt, codepage is 28591, embedded labels, delimiter is ',');

    Next File;

    Is there a way to dynamically load multiple files, but exclude (or dynamically rename) columns named "Filler"?

    Thank you!

    Show Less
  • New to QlikView

    Straight Table Mini Chart - Referencing Calculated Column Values Only

    Hi all, long time reader, first time poster.I have a straight table that contains unique calculated expressions and headings in each column.I want to ... Show More

    Hi all, long time reader, first time poster.

    I have a straight table that contains unique calculated expressions and headings in each column.I want to reference the output of these columns into a mini chart as a sparkline.

    An example of the data can be seen below:

    Capture.PNG

    Any ideas on how I can do this?

     

    Many thanks.

     

     

    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