Everything you need to make your Qlik Community experience valuable.
Explore official Support and member created content.
A live, in-person thrill-ride - full of insights, learning, and peer-to-peer connections.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.
Get started on Qlik Community, find How-To documents, and join general non-product related discussions.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
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
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
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?
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.
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.
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?
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!
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.
Edit: added a different screen shot, that includes the ShippedQuantity measure for comparison.
Qlik Compose for Data Warehouses
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
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!
If you want to know what's new across all of the products in our growing Qlik product portfolio.
Get the latest Support information about end-of-product support, new service releases, and general support topics.
Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
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.
Subscribe to our Events and Webinar page so you do not miss an event
opportunity!
Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.
There is more than one way to find upcoming events, look on the right side
of any Qlik Community forum!
Subscribe to our Events and Webinar page so you do not miss an event
opportunity!
Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.
There is more than one way to find upcoming events, look on the right side
of any Qlik Community forum!