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.

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!