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.
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.
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 |
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
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!
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!
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.
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
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 Minutes
Do you like it? We are happy about any comments.
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
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!
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!