Qlik Community

Welcome to Qlik Community

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

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

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 eight unique blogs. Check out the new Architecture Deep Dive Blog!

Find a forum to ask a question or start a discussion.

Discussion Boards and Documents for Qlik Services.

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

Discussion board and documents related to Qlik Associative Big Data Index.

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.


Introducing Qlik Gallery

Announcing the newest addition to the Qlik Community, Qlik Gallery!

Qlik Gallery is all about sharing – apps, outcomes, and ideas. This is your space to learn from each other as Qlik users, fans, thought leaders and data enthusiasts

Recent Discussions

  • New to Qlik Sense

    Data Model Viewer disabled

    HelloI did fresh install of Qlik Sense Desktop and create my first app. I add some table in-app manualy and also connect to one data source (Oracle DB... Show More

    Hello

    I did fresh install of Qlik Sense Desktop and create my first app. I add some table in-app manualy and also connect to one data source (Oracle DB). Everything work except Data model viewer. This option is (in left upper menu) still disabled. I can not access it. Any idea?

    Show Less
  • Qlik Sense App Development

    No se visualizan los campos de una tabla

    Buen diaTengo un desarrollo donde la llave es compuesta, la tabla principal se une con el cliente y las llaves tienen la siguiente estructura sucursal... Show More

    Buen dia

    Tengo un desarrollo donde la llave es compuesta, la tabla principal se une con el cliente y las llaves tienen la siguiente estructura sucursal+'-'+Empresa, la union se hace correrctamente, tambien hago la union con un calendario. Pero al visualizar la informacion si no hago ningun filtro se visualiza, pero al filtrar por año y mes, ya no se visualiza nada excepto la llave primaria de la sucursal, saben a que se debe eso? algun consejo?

    Saludos!

    Show Less
  • New to QlikView

    Ajax / Web View

    Hello everyone, I ask you a question.Why does the appearance of my designs on ajax client change so much?For example, the graphics change in size and ... Show More

    Hello everyone, I ask you a question.
    Why does the appearance of my designs on ajax client change so much?
    For example, the graphics change in size and they are not aligned correctly as I see them in desktop version.
    The tables also change in size as well as the fonts and some colors look different.
    Should I set the pages in some special way or something?
    Thank you very much for your comments.

    Regards

    Show Less
  • Qlik Sense App Development

    Avoiding If for the following Expression

    I do not want to add if else in my expression as we are going through some standards.Please help me to convert the below expression without Ifif(GetSe... Show More

    I do not want to add if else in my expression as we are going through some standards.

    Please help me to convert the below expression without If

    if(GetSelectedCount([Employee])=1,
    avg({<Level={3}, [Department Code]={2}, Country={'India'}>} Target),
    if (GetSelectedCount(Department)=1,
    avg({<Level={2}, [Department Code]={2}, Country={'India'}>} Target),
    avg({<Level={1}, [Department Code]={2}, Country={'India'}>} Target)))

    Show Less
  • New to Qlik Sense

    Help with joining 3rd table

    Please could you assist with table join:FACTBudget:LOAD      [Position ID],     [Cost Centre],     Budget as Amount,     'Budget' as Type,     'Budget... Show More

    Please could you assist with table join:

    FACT

    Budget:
    LOAD 
         [Position ID],
         [Cost Centre],
         Budget as Amount,
         'Budget' as Type,
         'Budgeted'as [Wage Type Text],
          Date,
          [Position ID]&[Cost Centre] as PositionKey
    FROM
    Table1, Source1
     
    JOIN
    Actuals:
    LOAD [Cost Center] as [Cost Centre],
        Employee,
         Name1, 
         [Wage Type Text],
         [Posting Date] as "Date", 
         Amount,
         'Actuals' as Type,
         Position as [Position ID],
         Position&[Cost Center] as PositionKey
    FROM
    Table2, Source1
     
    I need to join this table to create a single Fact Table  but only have  'Employee' and data for 1 month as the table is overwritten daily
     
    LOAD Employee,
         Date,
         Annual_Balance_NoBooking,
         Daily_Hours,
         AL_Liability as Amount, 
         'Leave Balance' as Type,
         'Leave Balance'as [Wage Type Text]
         FTE
    FROMSource 3
    Show Less
  • Qlik Sense App Development

    How to avoid data load in qlik sense

    Hi community,We need to avoid the pubblication phase in our QlikSense App, in some circustances (i.e. No Data Updated).The app is been reloaded every ... Show More

    Hi community,

    We need to avoid the pubblication phase in our QlikSense App, in some circustances (i.e. No Data Updated).

    The app is been reloaded every 30 mins, the desired effect is to control the data reload and avoid RAM flush.

     

    Is that Possible by the QMC or Scripting?

     

    Thanks,

    Paolo

     

    Show Less
  • New to QlikView

    Block Chart , multiple expressions

    Hello friends, I am new to Qlikview. I have a block chart below. The Chart is sorted as per column ROOMSIZE , once the level is changed , I need the c... Show More

    Hello friends,

     

    I am new to Qlikview. I have a block chart below. The Chart is sorted as per column ROOMSIZE , once the level is changed , I need the chart to show the sorting as per cubicle size .Attached is the qlikview file. Below is the screenshot.

    Data

    BLDG->ROOM->CUBICLE

    BLDGROOMROOMSIZECUBICLECUBICLE_SIZE
    BLDG1ROOM1500CUB130
    BLDG1ROOM1300CUB240
    BLDG1ROOM3400CUB350
    BLDG2ROOM4600CUB660
    BLDG2ROOM5800CUB910
    BLDG3ROOM6100CUB1020

     

    Once the Block chart loads , the data is sorted based on the column ROOMSIZE . However when we select the room , the data is not displayed sorted as per CUBICLE_SIZE , its still sorted as per the ROOMSIZE.

     

    clipboard_image_0.png

    On Selecting the bld1, it displays 2 rooms based on the roomsize , 

     

    clipboard_image_2.png

    But now on selecting ROOM1 , below screenshot , CUB1 &CUB2 are sorted based on the ROOMSIZE ,  How can i have them  sorted based on the cubicle_size

     

    clipboard_image_3.png

    Show Less
  • Qlik Sense Integration, Extensions, & APIs

    Trellis container options [June 2019 Qlik Visualization bundle]

    Hi to all,I'm checking the new Trellis container from the June 2019 Qlik Visualization bundle. I succeeded in basic usage, but I couldn't find any doc... Show More

    Hi to all,

    I'm checking the new Trellis container from the June 2019 Qlik Visualization bundle. I succeeded in basic usage, but I couldn't find any documentation or example about these options of the extension:

    • Show all possible values: what does it actually do?
    • Advanced mode: I tried the placeholders in Set Analysis in the Master Visualization without success. Anyone could provide some hints or examples on how to actually use them?

    Thanks in advance for your time. Best regards.

    - Federico Rizzello

    Show Less
  • QlikView App Development

    Document is getting slower when jumping between sheets

    Hi,We are using text box level triggers for jumping between sheets for the navigation.Application is heavy; it is taking too much time at the time of ... Show More

    Hi,

    We are using text box level triggers for jumping between sheets for the navigation.

    Application is heavy; it is taking too much time at the time of navigation.

    clipboard_image_0.jpeg

    The screenshot is as per the above.

    Could you please suggest on this.

    Thanks.

    Show Less
  • New to Qlik Sense

    Ignore Filters on All Fields but One - with Equation

    I have the following fields: Company, Question, Response, Year.I am trying to create a gauge that shows the response to a specific question for a spec... Show More

    I have the following fields: Company, Question, Response, Year.

    I am trying to create a gauge that shows the response to a specific question for a specific year.

    Here is my equation:
    KPI: SUM({$<Question={"Cost"}>}Response)

    My min/max bounds are:
    Minimum: =MIN({<Question={"Cost"}>}Response)
    Maximum: =MAX({<Question={"Cost"}>}Response)

    This works fine, but I want to lock my min and max so they don't respond to a filter.  That way I can filter by company and the gauge value will change, but the min and max will not.  However, I still want to filter by year.  I want the 2018YE min value and the 2018YE max value for my min and max. 

    I found several methods of attempting this, but none had an equation for the KPI.  I'm sure I'm just messing up my brackets or parentheses somehow, but I can't figure out how to tell my max and min to ignore all filters except the filter on Year. 

    Any suggestions would be appreciated.  Thank you!

    Show Less

Blogs

Qlik Community Manager Blogs

Hear from the Qlik Community team about the latest platform enhancements, announcements, and more.

Blogs

Qlik Education Blog

Check out the latest Education Blog written by Kevin Hanegan,Qlik Chief Learning Officer.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products. We have 8 blog types for you to choose from.

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 Insider Webinar Series

What's New in 2019. Register for the Qlik Insider Webinar Series to stay connected on our latest releases

Available On Demand Webinar

Events

Events & Meetups

Participate in an upcoming Qlik related event, webinar, or local meetup.

Events

Welcome to Qlik

Join the “Welcome to Qlik” webinar and learn about the Qlik Ecosystem

Tuesday, August 27, 2019 Webinar