Qlik Community

Welcome to Qlik Community

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

May Qlik Alert You – Welcome to the Qlik Alerting Product Forum! Join in on the discussion around Qlik’s intelligent alerting solution for Qlik Sense! This is an open group to share and collaborate!

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.

Participate in Qlik Technical Previews, submit ideas, and review documentation.

Learn about upcoming Qlik related events, webinars and local meetups.

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 ten unique blogs. Check out the new Product Insight & Ideas Blog!

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

Discussion Boards and Documents for Qlik Services.

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

  • No Boards Found
  • forum

    New to Qlik Sense

    Display pre aggregated fields in KPI

    Hello,I am a beginner in Qlik Sense. Since I am working on a huge dataset, I am aggregating the values before importing it in Qlik Sense to improve th... Show More

    Hello,

    I am a beginner in Qlik Sense. Since I am working on a huge dataset, I am aggregating the values before importing it in Qlik Sense to improve the  performance. Now, I wish to only display a pre-aggregated field in a KPI chart. Below are the options that I get while adding a new measure to the KPI chart.

    prithviKamath_0-1596219180087.png

    If I forcefully edit the expression to remove the aggregation, it does not display any value.

    prithviKamath_1-1596219261895.png

    My aggregated table now looks like this:

    prithviKamath_0-1596230445226.png

    So I plan to have a Filter panes for Year and Gender and KPI chart or Patient Count. 

    Can anybody kindly suggest a work around?

    Any help will be greatly appreciated! Thanks!

    Show Less
  • forum

    QlikView App Development

    Two separate fields in a dimension

    How is it possible to make 2 separate fields in a dimension. See attachment for a further explanation.
  • forum

    QlikView App Development

    Combined chart : second measure height of bar

    In a combined chart: how to add a second measure to "height of bar". I am currently only able to add a second measure to  "height of line"   See attac... Show More

    In a combined chart: how to add a second measure to "height of bar". I am currently only able to add a second measure to  "height of line"   See attachment

    Show Less
  • forum

    New to QlikView

    default date > field date

    Hello There,how to use this kind of function in QlikViewIF(06/30/2020 > FieldDate, "yes" the also IF field A- (MONTHS BETWEEN 06/30/2020 - FieldDate) ... Show More

    Hello There,

    how to use this kind of function in QlikView

    IF(06/30/2020 > FieldDate, "yes" the also

    IF field A- (MONTHS BETWEEN 06/30/2020 - FieldDate) == REM, "CURRENT"
    ELSE "FUL"

     

    Thanks

    Bing

    Show Less
  • forum

    New to QlikView

    How to summarize and show expression totals in Pivot table

    Hi All,I have to create a pivot table like below. I have 8 expressions and 3 dimensions.  A sample  requirement is below.I have created the NSC and TS... Show More

    Hi All,

    I have to create a pivot table like below. I have 8 expressions and 3 dimensions.  A sample  requirement is below.

    I have created the NSC and TSC part , but I have to create a summary part as well. 

    So in the summary for Programme A the YTD should TSC-A + NSC-A(100+200=300),

    similarly for B it should be TSC-B + NSC-B.(500 + 100=600). 

    Is this possible ? Please can any one help?

    Category ProgrammeManagerYTD
    TSCAX100
     BX500
    TSC-Total  600
    NSCAX200
     BX100
    NSC-Total  300
    SummaryAX300
     BX600
    Summary Total   900

     

    Regards

    Ankhi

    Show Less
  • forum

    New to QlikView

    Section Access on multiple values in the same field

    I am trying to implement Section Access on some fields. DIVISIONSALESCORPORATEMARKETINGEVENTSMAINTENANCEBRANCHACCOUNTSHRLEGALITSERVICESTRAVELSUPPLYLOC... Show More

    I am trying to implement Section Access on some fields. 

    DIVISION
    SALES
    CORPORATE
    MARKETING
    EVENTS
    MAINTENANCE
    BRANCH
    ACCOUNTS
    HR
    LEGAL
    IT
    SERVICES
    TRAVEL
    SUPPLY
    LOCAL
    SALES
    CORPORATE
    MARKETING
    EVENTS
    MAINTENANCE
    MEDICAL
    PUBLICITY

     

    LOCAL table is sort of a super set table of DIVISION table with two additional values

    Here are my requirements:

    1. I need to grant ADMINS access to all the values in 3 fields.

    2. All USERS should have access to MEDICAL and PUBLICITY in LOCAL by default

    3. I need some USERS to have access to SALES and CORPORATE in DIVISION

    4. I need some USERS to have access to SALES in DIVISION, ACCOUNTS in BRANCH

    My Credentials are based on IDs. I tried some methods but 2nd condition keeps failing if I enable other conditions. How do I achieve this?

    SECTION ACCESS;

    ACCESS:
    LOAD * INLINE
    [ACCESS,ID,DIVISION,BRANCH,LOCAL


    Show Less
  • forum

    New to QlikView

    Compare fields from multiple tables

    I have tables as shown (First row is table name)LimitedID Full TableID Alternate TableID2 I need to check if ID2 has any matching values in Full Table... Show More

    I have tables as shown (First row is table name)

    Limited
    ID

     

    Full Table
    ID

     

    Alternate Table
    ID2

     

    I need to check if ID2 has any matching values in Full Table 'ID' and if it does, then check if ID2 matches with any Limited table 'ID'

    In simple case, 

    if(Alternate Table ID2 = Full Table ID, then check

    if(Alternate Table ID2= Limited 'ID', then 'Yes','No') in the script. 

    How do I achieve this in the script?

    Show Less
  • forum

    Qlik Sense Deployment & Management

    QlikSense Desktop (free) discontinues in June 2020

    Today I read that QlikSense desktop will no longer available for download and use (as well as existing installations) from June 2020. Rumour or fact ?... Show More

    Today I read that QlikSense desktop will no longer available for download and use (as well as existing installations) from June 2020. 

    Rumour or fact ?

    Why do this ? Besides profiteering ? Surely there are other ways to encourage early adopters ? Forcing people to Qlik SaaS offering is not a great option as it does not support much in the way of extensions and of course locks out 3rd party extension provides such as VizLib which I use when prototyping before migrating to a server.

     

    Show Less
  • forum

    QlikView Scripting

    Can't create macro user defined function

    I'm trying to create a macro user-defined function like this thread:https://community.qlik.com/thread/115191Function addTheseForMe(var1, var2)addThese... Show More

    I'm trying to create a macro user-defined function like this thread:

    https://community.qlik.com/thread/115191

    Function addTheseForMe(var1, var2)

    addTheseForMe= var1+var2

    End Function

    However, when I try to run this in script:

    LET varA = 7;

    LET varB = 8;

    LET varAB = addTheseForMe(varA, varB);

    I get this error:

    Syntax error

    Unexpected token: '(', expected one of: ':', 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'OPERATOR_MULTIPLICATION', 'OPERATOR_DIVISION', 'OPERATOR_STRING_CONCAT', 'like', ...

    LET varAB = addTheseForMe>>>>>>(<<<<<<varA, varB)

    What is wrong?

    Show Less
  • forum

    Community Corner

    Round of Applause - August 2020

    While it's hard to believe we are in August already, it does mean a new month and another opportunity for our monthly "Round of Applause". This month... Show More

    Brett Bleess.jpg

    While it's hard to believe we are in August already, it does mean a new month and another opportunity for our monthly "Round of Applause". This month goes to our very own Qlik employee Brett Bleess! Brett is part of our Digital Support team,  has over 3500 posts, and countless interactions in the community. Brett is a valued partner to our team and we appreciate all of his interactions and moderation he provides.  

    Brett started with Qlik in Oct 2004 and has been a part of the support organization the entire time due to his overwhelming drive to solve problems.  When he started, we were on version 6 of the QlikView product and that was the only product we had! His community presence is part of his job, however, he really enjoys spending time in the community as things tend to be a bit more laid back and collaborative than in the case environment.  Also, much of the time things are not as urgent and people tend to be much more appreciative of the help/guidance they receive. While he mainly collaborates in the QlikView product area,  when time allows, he is able to get into the Qlik Sense forum.

    In his spare time, Brett enjoys doing projects around his house as well as for friends and family. He has a dedicated woodworking shop in his backyard with a full suite of tools. He really enjoys building new things and fixing old. Brett grew up on a farm and really misses working on tractors. He wants to buy a subcompact tractor, so he can do projects using the tractor.  Due to the virus tractors are in short supply, however, he is hopeful to buy one soon. 

    Let's give Brett a round of applause by adding a comment and/or giving him a like! @Brett_Bleess @Courtney_Cromley @Wlad_Masi @Melissa_Potvin 

     

    Show Less

Top Participants

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for April and May 2020.

Blogs

Customer Success Blog

Read all about Qlik's Voice of the Customer program and Customer Success initiatives.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

Groups

Covid 19

We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.

open to all

Groups

QlikView to Qlik Sense

Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.

open to all

Groups

Qlik Healthcare

This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.

750+ Members

Events

Qlik Customers Share COVID-19 Supply Chain Strategies

Amazon Produce Network and Odyssey Logistics discuss how they’re using Qlik to help manage their operations during Covid 19

On Demand Webinar

Events

Events & Meetups

Virtual Meetups are now a possibility! With the impact of COVID-19, the Qlik Meetup network has expanded its support to include the ability to host your next Meetup online. Email QlikMeetups@qlik.com to get your virtual Meetup started!’


Events

Direct Relief Uses Qlik to Manage Its COVID-19 Supply Chain

Qlik can help you manage your supply chain risks during COVID‑19.The nonprofit organization, Direct Relief, uses Qlik’s Supply Chain solution to scale its delivery of medical supplies worldwide.

Available on Demand