Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Week to Week Comparison

Hi guys,

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! Smiley Happy

Thanks

J

Labels (2)
4 Replies
Highlighted
Specialist
Specialist

Re: Week to Week Comparison

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 😉

Highlighted
Creator III
Creator III

Re: Week to Week Comparison

Did this not get answered in your other post ?

 

Or are you now asking how to do this in script?

Highlighted
Creator
Creator

Re: Week to Week Comparison

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

 

Highlighted
Creator III
Creator III

Re: Week to Week Comparison

So is the problem that the week numbering is off? I'm still a bit confused. It would help a lot if you could post a mock-up of your expected results, perhaps in comparison to what you have now if possible.