Discussion board where members can get started with Qlik Sense.
I have two years-worth of data and I would like to gauge an increase/decrease from week to week of a total parcels.Is this possible at all? I have used the following to give me a "week number"
AutoNumber(weekyear(Date) &'|' & week(Date))
But I am not sure how to go about getting the total as a difference week to week?
Any help is greatly appreciated! :smileyhappy:
If you have a Calendar in your application, you can easily get weeknumbers, per year by just doing as you've suggested.
Week(Date) gives you the weeknumber of a date. You can also make a field in your calendar called WeekYear where you just add the weeknumber to the year.If you then use the Week or WeekYear as a dimension in a graph, you can just use Sum(parcels) which will give you parcels per week in your graph/table/...
Comparison can be done with the Above function, which you should have figured out by now 😉
Did this not get answered in your other post ?
Or are you now asking how to do this in script?
The problem is from my previous post I have discovered there is no Week 1 versus Week 5 of the previous month. To do this I think i am going to have to give each week in the year a week number.
This request from my boss has really baffled me to be honest!! Haha