Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
1,775 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.

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.

Find a forum to ask a question, start a discussion, or find documentation and videos.

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

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.

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

  • QlikView App Development

    Get sum between 2 special record that user select

    Hi guys,I have a table like below. I want to have two list box with status. start status and end status. when user select start status and end status ... Show More

    Hi guys,

    I have a table like below. I want to have two list box with status. start status and end status. when user select start status and end status we can show sum (duration) between these tow status for each message code. 

    for example if we select  first status =2 and end status=5 we have two number. for messagecode=1 we have 100 and for messagecode=2 we have 70. what should I do?

    MessageCodeMessagelogstatusduration
    1101110
    1102220
    1103340
    1104410
    1105530
    1106620
    1107710
    2108150
    2109230
    2110310
    2111410
    2112520
    2113630
    2114710
    Show Less
  • New to Qlik Sense

    Automate Date Logic

    Hi, I have 2 KPI's whereby each month, I have to update hard coded values. What would be great is to automate these, any idea how I can amend my code ... Show More

    Hi, 

    I have 2 KPI's whereby each month, I have to update hard coded values. What would be great is to automate these, any idea how I can amend my code please to show previous months data? 

    Sum({<Week = {"=MonthName(Week) = MonthName('01/12/2019')"}>}[Total Cost])

     

    Show Less
  • Qlik Sense Integration, Extensions, & APIs

    Measure corresponding to specific set of dimensions

    Hi,I am building a Qlik Sense Extension that has two dimensions and two measures. What I need is that the measure one values should be calculated on u... Show More

    Hi,

    I am building a Qlik Sense Extension that has two dimensions and two measures. What I need is that the measure one values should be calculated on unique combination of values of both the dimensions (which is the default behavior), but measure two values should be calculated on unique values of only dimension one.

    So for example, if my data is:

    ABC
    1210
    1210
    1310
    4510

     

    And I chose dimension 1 as "A", dimension 2 as "B" and both measures as sum of "C", then in my extension,  "layout.qHyperCube.qDataPages[0].qMatrix" should return the following table.

    dimension1dimension2measure1measure2
    122030
    131030
    451010

     

    It has one row per unique combination of values of dimension1 and dimension2. The measure1 is calculated on each unique combination of values of dimension1 and dimension2 (which is the default behavior). The measure2 is what I need help with. It should be calculated on each unique values of just dimension1 (and dimension2 should be ignored).

    Is this possible. If so, how?

    Show Less
  • New to QlikView

    Remove dimension result if no expression data for a period

    I am looking to remove results from a dimension where there has been no results for a set period of time.As you can see from the image, James has had ... Show More

    I am looking to remove results from a dimension where there has been no results for a set period of time.

    As you can see from the image, James has had no scores for more than 6 weeks so should not show in the table anymore as he will have left the company. 

    QlikHelp1.PNG

    Thanks for any help.

    Show Less
  • New to Qlik Sense

    Bar Chart shows current and previous 6 months data

    Hi,i'm using Qlik Sense and i am new to this. i need help on how to display current and previous 6 months data on the bar chart. I have 3 years data i... Show More

    Hi,

    i'm using Qlik Sense and i am new to this. 

    i need help on how to display current and previous 6 months data on the bar chart. I have 3 years data in total. 

    Kindly help me on how to display the data in details. Please show me step by step. 

    X-axis is Submission Date (YearMonth)

    Y-axis Count(change request)Capture.PNG

    Show Less
  • New to QlikView

    JOIN IN SQL

    Hello ,I am very new to Qlikview Scriptinng. I am having an issue with my script.Data:SQL selectAccount.Account key,Account.Account NBR,Account.vsc ke... Show More

    Hello ,

    I am very new to Qlikview Scriptinng. I am having an issue with my script.

    Data:

    SQL select

    Account.Account key,
    Account.Account NBR,
    Account.vsc key,
    Accoun.Date key

    Department. Department NBR,
    Department.Department Date key,

    Sale.sale DT Key,
    Sale.sale ID,
    sum(sale) as Total

    vendor Account .Account key,
    Vendor Account. name,
    Vendor Account. CD
    vendor Account.vsc key

    FROM

    Account,
    Department,
    sale,
    Vendor

    where Account.Datekey = Department.date key

    And Sale.sale DT key = Department.deaptment date key

    And account. account key = vendor account. account key,

    and Account. vsc key = vendor account.vsc key

    and // Date condition


    group by


    all the fields my the above tables.


    I believe the table Account and vendor has inner join by linking the field account key(Bold lines). so, wen there is no data in vendor the account data also getting excluded.

    I want the Account data even when there is no vendor data. so I need to perform left join.

    Could anyone help me on this.

    Show Less
  • Qlik Sense Data Connectivity

    Qlik Sense Document Analyzer

    I feel like I'm asking a really stupid question (probably am), but I'm trying to find what the flags showing in the Qlik Sense Document Analyzer mean.... Show More

    I feel like I'm asking a really stupid question (probably am), but I'm trying to find what the flags showing in the Qlik Sense Document Analyzer mean. Does anyone have a list of what those flags mean? Or how to fix? The app is written by Rob Wunderlich and the Flag I'm looking at now is called 'Suboptimal Numeric Storage'. It seems like this means we're storing dual data in about 200 fields. So then my question is, what is the impact? Is it really slowing down performance in the application? Or is there something else it impacts? I've read through the text files but all I find there is things that were added to the application, not a 'how-to-use' this app. Qlik Sense...not Qlikview answers please. Thank you so much in advance for reading - my question to the community has gotten no response.

    Show Less
  • New to QlikView

    Authenticating Qlik Engine API

    Hello, I’m trying to Authenticate the engine api using Java Apache http client and a WebSocket, I am getting a session Id but when I attempt the WebSo... Show More

    Hello, I’m trying to Authenticate the engine api using Java Apache http client and a WebSocket, I am getting a session Id but when I attempt the WebSocket it returns mustauthenticate: true. Instead of false. Has anyone done this is Java ? Or JavaScript for that matter. The Qlik admin at my company will not allow security certs to be issued or used so that method is not at option. Any guidance is greatly appreciated!

     
    Show Less
  • Qlik Sense Advanced Authoring

    Qlik Sense Business stability - QBS

    Hi guys, is it just me or is the Qlik Sense Business (formerly cloud) not necessarily very stable? I am mostly referring to windows timing out real qu... Show More

    Hi guys,

     

    is it just me or is the Qlik Sense Business (formerly cloud) not necessarily very stable? I am mostly referring to windows timing out real quick and/or automatically refreshing/reconnecting when I am working in load script.

    Anyone?

    B.

    Show Less
  • New to QlikView

    2 tables same field name

    2 tables with same keyname ARTNRLOAD ARTNR,MENGEKG,PREISLV,PREISGV,PREISEKES,PREISLVES,VORGDATUM;SQL SELECT * FROM umsatzPOS where VORGDATUM = '12-5-2... Show More


    2 tables with same keyname ARTNR

    LOAD ARTNR,
    MENGEKG,
    PREISLV,
    PREISGV,
    PREISEKES,
    PREISLVES,
    VORGDATUM;
    SQL SELECT * FROM umsatzPOS where VORGDATUM = '12-5-2019';


    LOAD ARTNR,
    ARTID,
    ARTBEZ,
    ARTEINHEIT,
    VERGLEICHT,
    TEXTID0,
    TEXTID1,
    TEXTID2,
    TEXTID3,
    TEXTID4;
    SQL SELECT * FROM STAMMARTIKEL;

    This generates a $Syn1 table

    creating a grafic object will say all expressions deactivated

    i need a connection by pickinng ARTNR form STAMMARTIKEL; and show all records in umsatzPOS with that ARTNR

    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 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