Skip to main content

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 182,153 members
  • 5,027 online
  • 1,735,594 posts
  • 132,814 Solutions
Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!

Welcome to Qlik Community

FOR NEW MEMBERS

Everything you need to make your Qlik Community experience valuable.

SEARCH KNOWLEDGE BASE

Explore official Support and member created content.

QLIKWORLD 2023!

A live, in-person thrill-ride - full of insights, learning, and peer-to-peer connections.

Analytics

Forums for Qlik Analytic 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

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.

Support

Chat with us, search Knowledge, open a Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

Events

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

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.

About Qlik Community

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

Blogs

Hear directly from Qlik employees in our ten unique blogs.

Qlik Resources

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

Qlik Academic Program

Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

Community Sitemap

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

Recent Discussions

  • forum

    App Development

    Cumulative Sum (Rangesum) by week starts over on first day of month

    I have the following expression in a table: aggr(rangesum(above(sum({<DateFlag_CurrentWeek={1}>}ShippedQuantity),0,RowNo())),CommodityCode,ShipDate) I... Show More

    I have the following expression in a table:

    aggr(rangesum(above(sum({<DateFlag_CurrentWeek={1}>}ShippedQuantity),0,RowNo())),CommodityCode,ShipDate)

    It kind of works, but something is wrong.  I would like to have a cumulative sum of ShippedQuantity by day, which starts over every Sunday, even when there's a new month included in the week's data.

    mikegrattan_0-1675355850139.png

    Edit:  added a different screen shot, that includes the ShippedQuantity measure for comparison.

     

    Show Less
  • forum

    App Development

    Extract data after last special character

    Hi, I'm trying to identify a way to script returning data after the last instance of a character, which may not be in each instance.  In the example b... Show More

    Hi, I'm trying to identify a way to script returning data after the last instance of a character, which may not be in each instance.  In the example below, that character is '-'.  Any help on this would be appreciated.

     

    Data Desired Result
    ABC - 123 123
    ABC - 1234 - 56 56
    ABCD ABCD
    Show Less
  • forum

    QlikView Administration

    Understanding SLK and LEF license methods

    Hello Team! We've facing some question about licensing and compatibility to expand the disponibilization for our clients. I found some articles explai... Show More

    Hello Team! We've facing some question about licensing and compatibility to expand the disponibilization for our clients.

    I found some articles explaining about this new kind of license called Signed License key (SLK). Today in our environment we use License Enabler File (LEF).

    Those two kind of licensing can work together?

    If yes, which impact we should prepare to face?
    If no, what kind of changes should be done to adapt the environment in this new kind of licensing?

    Best regards

    Show Less
  • forum

    New to Qlik Sense

    Nested conditional IF statements determining age ranges

    Hello Qlik Community! I'm looking to use a condition of an Issue Status (Closed/Open) to then calculate an age range. I have a nested IF statement. Th... Show More

    Hello Qlik Community!

    I'm looking to use a condition of an Issue Status (Closed/Open) to then calculate an age range. I have a nested IF statement. The first condition is stating if the issue is "Closed" to calculate the age range between the Issue Created Date, and Issue Closed Date. 

    However, the second condition, if the issue is "Open", I would like to calculate the age range using the difference between the Issue Created Date, and today. 

    I can get these to work independently, but not together. Can someone let me know what I may be missing? Here is what I'm using: 

    =IF(ISSUE_STATUS_NAME='Closed',
    IF(ISSUE_CLOSED_DATE2 - ISSUE_CREATED_DATE2 <= '0', '0 Days',
    IF(ISSUE_CLOSED_DATE2 - ISSUE_CREATED_DATE2 <= '1', '1 Day',
    IF(ISSUE_CLOSED_DATE2 - ISSUE_CREATED_DATE2 <= '2', '2 Days',
    IF(ISSUE_CLOSED_DATE2 - ISSUE_CREATED_DATE2 <= '5', '3-5 Days',
    IF(ISSUE_CLOSED_DATE2 - ISSUE_CREATED_DATE2 <= '7', '6-7 Days',
    IF(ISSUE_CLOSED_DATE2 - ISSUE_CREATED_DATE2 <= '10', '8-10 Days',
    IF(ISSUE_CLOSED_DATE2 - ISSUE_CREATED_DATE2 <= '14', '11-14 Days',
    IF(ISSUE_CLOSED_DATE2 - ISSUE_CREATED_DATE2 <= '30', '15-30 Days',
    IF(ISSUE_CLOSED_DATE2 - ISSUE_CREATED_DATE2 <= '60', '31-60 Days',
    IF(ISSUE_CLOSED_DATE2 - ISSUE_CREATED_DATE2 <= '90', '61-90 Days',
    IF(ISSUE_CLOSED_DATE2 - ISSUE_CREATED_DATE2 >= '91', '91+ Days',
    IF(ISSUE_STATUS_NAME='Open',
    IF(Today() - ISSUE_CREATED_DATE2 <= '0', '0 Days',
    IF(Today() - ISSUE_CREATED_DATE2 <= '1', '1 Day',
    IF(Today() - ISSUE_CREATED_DATE2 <= '2', '2 Days',
    IF(Today() - ISSUE_CREATED_DATE2 <= '5', '3-5 Days',
    IF(Today() - ISSUE_CREATED_DATE2 <= '7', '6-7 Days',
    IF(Today() - ISSUE_CREATED_DATE2 <= '10', '8-10 Days',
    IF(Today() - ISSUE_CREATED_DATE2 <= '14', '11-14 Days',
    IF(Today() - ISSUE_CREATED_DATE2 <= '30', '15-30 Days',
    IF(Today() - ISSUE_CREATED_DATE2 <= '60', '31-60 Days',
    IF(Today() - ISSUE_CREATED_DATE2 <= '90', '61-90 Days', '91+ Days')))))))))))))))))))))))

    Thanks! 

    Show Less
  • forum

    QlikView App Dev

    Simple join of 2 resident tables into new table

    Hi guys,Appreciated if I can get some help here. I have the following scenario in my script: //User id's per task idTask.UserIds:LOAD * INLINE [Task.U... Show More

    Hi guys,

    Appreciated if I can get some help here. I have the following scenario in my script:


    //User id's per task id
    Task.UserIds:
    LOAD * INLINE [
    Task.UserIds.TaskId, UserIdKEY
    'TASKIDA', 'USERIDA'
    'TASKIDA', 'USERIDB'
    'TASKIDB', 'USERIDC'
    'TASKIDC', 'USERIDA'
    ];


    //User data per user id
    User.Data:
    LOAD * INLINE [
    UserIdKEY, User.Data.UserDesc
    'USERIDA', 'User ID A Description'
    'USERIDB', 'User ID B Description'
    'USERIDC', 'User ID C Description'
    'USERIDD', 'User ID D Description'
    ];

    Now I'd like my result table to have all: "User.Data.Userdesc"-values concatenated into one field per unique: "Task.UserIds.TaskId". Probably quite simple for you guys but I can't seem to figure it out.

    I hope you can help me with this.


    Thanks in advance!

     

     

     

    Show Less
  • forum

    Alerting

    Email alerts

    I had a customer ask about email capability in Qlik.  What they were looking for is that if I have a condition to where they are 6 weeks out from paym... Show More

    I had a customer ask about email capability in Qlik.  What they were looking for is that if I have a condition to where they are 6 weeks out from payment coming due, they want an email send to the managers informing them that these payments are coming due.  

    So, my question is does Qlik have a notification capability that works with conditions within the data in my sheets?  Thank you in advance.

    Chris.

    Show Less
  • forum

    App Development

    Evaluate() function on formula in table field during load

    Hi community, I struggle with the attached load script, which is not working as expected although I tried to base it upon the example in the online he... Show More

    Hi community,

    I struggle with the attached load script, which is not working as expected although I tried to base it upon the example in the online help.

    For some reason the Evaluate(FORMULA) returns 0 for the first line and Null for all following lines, so it looks like it does not evaluate the content of the field FORMULA as proper formula.

    TEST:
    Load
    Evaluate(FORMULA) As EVALUATED,
    *
    Inline [FORMULA, FIELD01, FIELD02
    'RangeSum(FIELD01, FIELD02)', 1, 2
    'RangeMax(FIELD01, FIELD02)', 1, 2
    'RangeMin(FIELD01, FIELD02)', 1, 2
    FIELD01 * 3, 1, 2
    ];

     

    Does anybody have an idea, what is wrong in this code? Or is this a limitation of the Evaluate() function?

     

    Best regards,

     

    Dirk

    Show Less
  • forum

    Integration, Extension & APIs

    novofactum smart.builder

    We are happy to announce our new product smart.builder (yes, it is a free product!)https://smartbuilder.novofactum.de/On this web portal you can build... Show More

    We are happy to announce our new product smart.builder (yes, it is a free product!)

    https://smartbuilder.novofactum.de/

    On this web portal you can build your own multipage Qlik Sense mashups with drag and drop. So you don‘ t need any knowledge in web programming to get an awesome mashup. Simply export your build mashup into a zip file and import it to Qlik Sense. You only have to register to login.

    Since we have already benefit from Qlik community solutions many times we make the usage of smart.builder completely free. Further we aim to increase the enthusiasm into mashups for all the power users who have not the time to go deep into the quite complicated web programming world. 

     

    mashup with 3 pages built by  smart.builder in 10 Minutesmashup with 3 pages built by smart.builder in 10 Minutes 

    Do you like it? We are happy about any comments.

    Show Less
  • forum

    Deployment & Management

    QMC suddenly not responding and Dashboards are not accessible

    We have had multiple situations where QMC suddenly is not accessible and until we restart the server dashboards and QMC are not accessible. I have att... Show More

    We have had multiple situations where QMC suddenly is not accessible and until we restart the server dashboards and QMC are not accessible.

    I have attached logs and would like a Qlik Support Agent to parse through this and help us figure out what is happening.

    This is critical and would appreciate your help on this.

    Thanks

    Lass

    Show Less
  • forum

    Qlik Cloud Data Integration

    Embedding Qlik dashboard in a SharePoint site

    Hello everyone,  here‘s the following challenge we‘re facing at our student initiative: We have built our dashboards in Qlik Cloud and we embedded a g... Show More

    Hello everyone, 

    here‘s the following challenge we‘re facing at our student initiative:

    We have built our dashboards in Qlik Cloud and we embedded a graph using its iframe in a SharePoint site.
    This works and it‘s visualised on the SharePoint site. However, this graph is available on the SharePoint site as long as I‘m signed in with my Qlik account.

    Is there a solution to this problem or a suggestion how to embed the dashboards on our SharePoint site? 

    many thanks! 

    Show Less

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!

Blogs

Qlik Academic Program Blog

Read the latest blog around the Qlik Academic Program.

Blogs

Qlik Product Innovation Blog

If you want to know what's new across all of the products in our growing Qlik product portfolio.

Blogs

Support Updates Blog

Get the latest Support information about end-of-product support, new service releases, and general support topics.

Blogs

Qlik Design Blog

Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

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

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Events and Webinars

QlikWorld 2023!

Get ready for QlikWorld: The Conference for Data Thrill-Seekers. From exciting innovations to spine-tingling keynote presentations and lots of peer networking, you'll discover how you and your data can help your business succeed.

Find your city

Events and Webinars

Qlik and Qlik Community Hosted Events

Subscribe to our Events and Webinar page so you do not miss an event opportunity!

choose and register

Event

Welcome to Qlik

Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

On-Demand

Events

Upcoming Events and Webinars

There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

Upcoming

Events and Webinars

Qlik and Qlik Community Hosted Events

Subscribe to our Events and Webinar page so you do not miss an event opportunity!

choose and register

Event

Welcome to Qlik

Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

On-Demand

Events

Upcoming Events and Webinars

There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

Upcoming