Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
853 online
Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW

Data Analytics

Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration

Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

QlikWorld

This year’s go-to data event is full of inspiring speakers, informative sessions, ideas for up-leveling your data integration and analytics.

Groups

Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

Qlik Gallery

Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

Ideation

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

Qlik Resources

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

Events

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

Blogs

Hear directly from Qlik employees in our ten unique blogs.

About

Get started, find How-To documents, and join general non-product related discussions.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Recent Discussions

  • No Boards Found
  • forum

    New to Qlik Sense

    How to generate total for each section in a column in pivot table?

    Hi,I'm new to Qlik and I'm trying to generate a table as shown below. Using the Pivot table, I came up with getting near the structure but could not a... Show More

    Hi,

    I'm new to Qlik and I'm trying to generate a table as shown below. Using the Pivot table, I came up with getting near the structure but could not add the Total row for Amount as shown for each unique value in Name. How can I add that?

     

    NameID Number Amount 
    James1 $                    2,500
     2 $                    5,584
     3 $                    5,755
     Total $                 13,839
    Stephen6 $                    5,581
     7 $                    5,584
     Total $                 11,165
    Show Less
  • forum

    New to Qlik Sense

    Alternative Dimensions- Filtering.

    Hi,I have an Alternate State on Field "Date" with visualizations that are being affected with the alternate states.This causes other filters to not af... Show More

    Hi,

    I have an Alternate State on Field "Date" with visualizations that are being affected with the alternate states.

    This causes other filters to not affect those visualizations (That are affected with the alternate states).

    I know, for example, that i can do this in the set analysis: Country= $::Country, but that will let only the "Country" Field to affect the visualizations.

    is there a way for me to let all dimensions (Apart from the Date, Which has Alternate States on it) filters Affect the visualizations that are affected by the alternate states?

     

    Thanks,

    Tom.

     

    Show Less
  • forum

    New to Qlik Sense

    add a empty field in load script

    HI.  I want to add an empty column in load script. I have my visualization with column name called as CITY. But the table extracted from database does... Show More

    HI. 

     I want to add an empty column in load script. 

    I have my visualization with column name called as CITY. But the table extracted from database doesn't have the field CITY. How can i add the column name CITY in load script. 

    I tried doing

    abc:

    load 

    ..

    ..

    ..

    ..

    ;

    table1:

    load *, 

    'city' as [CITY];

    resident abc;

    drop table table1; 

     

    I am new to qliksense. Do help. 

    Show Less
  • forum

    New to Qlik Sense

    Get Latest data with three fields and using SQL query.

    HiI have to obtain latest data using sql query. I have loaded the data using HIVE connector. It has three field year,month,date. I want to find max(ye... Show More

    Hi

    I have to obtain latest data using sql query. I have loaded the data using HIVE connector. It has three field year,month,date. I want to find max(year),max(month),max(date) and output the latest partition data. 

    Example:

    Table1:

    Load 

    ..

    ..

    ..

    year, 

    month,

    date;

    Temp: 

    Load max(year) as maxyear,

    max(month) as maxmonth,

    max(date) as maxdate;

    resident table1;

    drop table table1;

    SQL select * from HIVE.tablename;

     

    I want to get the latest partition every time. I am not sure how to use the SQL statement and not sure if I am doing the right thing in load statement. I am very much new to qliksense. 

    Thanks in advance. 

    Show Less
  • forum

    QlikView App Dev

    Expression from fields

    Hi all,I have these fields as an example:Field_a123Field_b_1456Field_b_2567Field_bField_b_1Field_b_2 I want to create Field_c with the following expre... Show More

    Hi all,

    I have these fields as an example:

    Field_a

    1

    2

    3

    Field_b_1

    4

    5

    6

    Field_b_2

    5

    6

    7

    Field_b

    Field_b_1

    Field_b_2

     

    I want to create Field_c with the following expressions:

    Field_c

    =Field_a*Field_b_1

    =Field_a*Field_b_2

     

    Later I need in chart expression the value of Field_c (pre-defined expression). (by selecting Field_b_1 in Field_b, the related expression in Field_c should be computed).

    How can I generate Field_c and how the expression in Field_c can be recignized in chart expression (by selecting Field_b_1 or Field_b_2 from Field_b) ?

    Any help please?

    Thanks in advance.

    Show Less
  • forum

    App Development

    Replacing dash with empty in table

    All,I have a simple table.User              App      User Access last used NA               User Access Last used EMEAUser A          Test          03... Show More

    All,

    I have a simple table.

    User              App      User Access last used NA               User Access Last used EMEA

    User A          Test          03/21/2020                                                          -

    User B         Test A             -                                                                      05/04/2021 

    I want to fill the dash with blank. To achieve that I tried using the below expression in the app but did not take the effect.

    =if(isnull([User Access Last Used NA]),'',timeStamp([User Access Last Used NA], 'DD/MM/YYYY'))

    I tried some thing like this and did not work either.

    =if([User Access Last Used]='-','',timeStamp([User Access Last Used], 'DD/MM/YYYY'))

    Can some one please take a look and advice?

    Thanks

    Show Less
  • forum

    App Development

    Section access issue in Qlik Sense

    Hi All,After reloading the section access script, I am getting  the following error, "Access was denied after reload. Check that the user that reloads... Show More

    Hi All,

    After reloading the section access script, I am getting  the following error, "Access was denied after reload. Check that the user that reloads the script is included in the section access part of the script." 

    I already added my details, however, QS is showing same error.

    Below is the section access I added:

    Section Access;

    SECURITY:
    LOAD * inline [
    ACCESS,           USERID,            RESTRICTION
      USER,      DOMAIN\F12345D,          *
      USER,      INTERNAL\SA_SCHEDULER, *
    ];

    Concatenate(SECURITY)
    LOAD
    Upper(trim("Access")) as ACCESS,
    Upper(trim("UserID")) as USERID,
    Upper(trim(Region)) as RESTRICTION
    FROM [lib://AttachedFiles/ User List.xlsx]
    (ooxml, embedded labels, table is [SECURITY]);

    Star is '*';

    Section Application;

    Thanks

    Nakul

    Show Less
  • forum

    New to Qlik Sense

    Error on installing qliksense desktop

    [59A0:66E0][2021-05-08T20:21:11]e000: Error 0x80070643: Failed to install MSI package. [59A0:66E0][2021-05-08T20:21:11]e000: Error 0x80070643: Failed ... Show More

    [59A0:66E0][2021-05-08T20:21:11]e000: Error 0x80070643: Failed to install MSI package. [59A0:66E0][2021-05-08T20:21:11]e000: Error 0x80070643: Failed to configure per-user MSI package.

    Show Less
  • forum

    QlikView App Dev

    Do not sum if the KEY was previously considered

    Hello guys,I'm using a bar chart with dates (DASI field) on X axis and the sum of seats offered (TOTS field) per airline on Y axis.So, my dimensions a... Show More

    Hello guys,

    I'm using a bar chart with dates (DASI field) on X axis and the sum of seats offered (TOTS field) per airline on Y axis.

    brunolelli87_0-1620488545092.png

    So, my dimensions are: DASI and NCIA, as you can see below:

     

    brunolelli87_2-1620488691488.png

     

    And my expression is: sum({<DASI=>} aggr(sum({<DASI=>} TOTS), KEYI)),

     

    Where:
    DASI is a date field,
    TOTS is the total number of seats
    KEYI is the key field.

    Basically, each fligh has its own Key.

     

    But, my problem is, once I'm summing the total of seats per KEYI and if the airplane took-off at night and landed on the other day, the system is considering two times this KEYI. Because it's a distinct KEYI on day 1 and a distinct KEYI on day 2.


    How can I just consider the KEY (KEYI field) if it has not been previously considered?
    So, if the airplane took-off in one day and landed on another day, I would like to consider the seats offered just on the first date.

    Thanks

     

    Show Less
  • forum

    QlikView App Dev

    policy no is booked as Renewal

    How to check whether the policy has book in renewal or not. If booked then marked them  as renewed

Get Started On Community

Start Here Get Started On Community

Top Participants

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements and other topics.

Blogs

Support Updates Blog

Important and useful support information about end-of-product support, new service releases, and general support topics.

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

Register for QlikWorld Today

Join QlikWorld to hear from Qlik CEO, Mike Capone on activating your data for impact. You’ll also have access over 100 breakout sessions covering data integration and analytics, tips for getting the most out of your data, and a view into what the next generation of BI holds.

May 10-12, 2021

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