Skip to main content

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 182,290 members
  • 2,360 online
  • 1,735,854 posts
  • 132,843 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

    New to Qlik Sense

    Search by map/coordinates

    Hi, This may not be possible however, is it possible if I have a list of roads and postal codes(Zip codes) linked with global coordinates to setup a p... Show More

    Hi,

    This may not be possible however, is it possible if I have a list of roads and postal codes(Zip codes) linked with global coordinates to setup a page whereby you can search for coordinates and it would return all roads within a set mile radius e.g. 1 mile?

    I could have just a postal code search however I've found that either side of a road could have a different postal code.

    I don't want to have a road name search e.g. high street would bring back 1000s of results. You would need a multitude of filters

    With the coordinates you could input latitude and longitude and then a range of roads would appear 

     

     

    Show Less
  • forum

    New to Qlik Sense

    Set Analysis , Date not showing on X axis , How to include 0 values in Vizlib ch...

    Hello  so i have to show values of sales for the past 30 days , including the days which have 0 value for sales  Usually in qlik sense chart , i can d... Show More

    Hello 

    so i have to show values of sales for the past 30 days , including the days which have 0 value for sales 

    Usually in qlik sense chart , i can do it with a toggle button of show null values /show missing values

    But i am using a Vizlib chart which doesnt have that option , so the only way to correct it is with expression 

    I saw that Sum({1}0) works 

    But it doesnt work in my case ., because i use a count statement , could someone help me solve this ...

    Basically, How to  use a set analysis statement to show 0 values for dates and show all 30 dates

    Show Less
  • forum

    New to Qlik Sense

    Get Previous Quarter in QLIK Sense

    I want to get the previous quarter dynamically based on the selection in Month field. In this case the data is available for Oct-21 (Q4-21) and I want... Show More

    I want to get the previous quarter dynamically based on the selection in Month field. In this case the data is available for Oct-21 (Q4-21) and I want to get Jun-21(Q2-21) to show in label of KPI.

    Currently this is the formula I am using : 'Q'&ceil(Month(QuarterStart(max(FDAY),-1))/3) which is not working for this case.

    Can you guide me on the correct formula I have to use?

     

    harika189_0-1675444608815.png

     

    Show Less
  • forum

    App Development

    Qlik App for Tracking Usage

    Hello, I was wondering whether there is QlikSense app that shows the usage statistics for all the Qlik apps such as the number of users who accessed t... Show More

    Hello,

    I was wondering whether there is QlikSense app that shows the usage statistics for all the Qlik apps such as the number of users who accessed the app, number of clicks on each sheet etc. If someone could point me to such an app that would be very helpful. I am using QlikSense SaaS Cloud version. TIA.

    Show Less
  • forum

    New to Qlik Sense

    Restrict values to be shown on x-axis

    Hi all, I would appreciate if you could help me with this one. Based on the attached file I need to have a chart that has dimension for x-axis from th... Show More

    Hi all,

    I would appreciate if you could help me with this one. Based on the attached file I need to have a chart that has dimension for x-axis from the column Next 3 months. But the dimensions should be limited only to cells that are in the same row with the cells 01.01.2023 from the column Data Month – Year (current cycle). I.e. on the x-axis we should have Feb, Mar and Apr. This file will be appended every month and therefore Next 3 months dimension should be dynamic, i.e. always linked to the current cycle. Column Next 3 months will be populated accordingly. Therefore during the next cycle (Data Month – Year  01.02.2023) x-axis should have Mar, Apr and May.

     

    Show Less
  • forum

    Qlik Replicate

    AWS JDBC Driver for Aurora PostgreSQL

    Like to know if QLIK support AWS JDBC Driver for Aurora PostgreSQL
  • forum

    App Development

    Qlik Sense screen resolution issue

    Qlik sense app was developed on large screen with screen resolution 100%. However most people are using their laptops with recommended screen resoluti... Show More

    Qlik sense app was developed on large screen with screen resolution 100%. However most people are using their laptops with recommended screen resolution of 150%. Some elements, like text box or variable input become too small for the text inside of it. KPIs for example, have property layout behavior that can be setup to responsive or fluid but there is no such option in textboxes or variable input. Is there a wat to make it work with any screen resolution?

    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

    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

    Qlik Compose for Data Warehouses

    Just updated to May 2022 (2022.5.0.403) Getting errors Generating Marts

    Just updated, to the latest May 2022 version. I'm getting SYS,GENERAL_EXCEPTION,Object reference not set to an instance of an object, when trying to r... Show More

    Just updated, to the latest May 2022 version.

    I'm getting SYS,GENERAL_EXCEPTION,Object reference not set to an instance of an object, when trying to rebuild a marts that have mostly reference dims (one local dim).

    The main mart - all local dims generated with no issues.

    Where are the log files from the generation - ie. where is SYS,GENERAL_EXCEPTION,Object reference not set to an instance of an object this logged.  I thought I searched all the logs, I cant find where this error exists so I can fix it.

     

    Ron

    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