Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Last Week vs. Last Week Previous Year ect...

I am looking for some instructions on how to get a view within Qlikview that looks like the following:

Desired View.JPG

I have been using a competitor's visualization tool and am wondering if Qlikview can do what I need in a more fashionable way.

My data is broken down by day over the past 3 years and can be in either format:

Date, Revenue, Orders, Visits ...

Jan 1, 54434,    56,        783432

OR

Date,  Metric,  Value

Jan 1, Revenue, 54434

Jan 1, Orders,   56

Jan 1, Visits,    783432

We operate on a Monday to Sunday basis so if today is Jan 4, 2012 "Last week" would mean December 26, 2011 through January 1, 2012.

Last week Previous Year would be same week as last week one year ago.

Week Previous would be December 19, 2011 through December 25, 2011.

% Diff mean "(last week - last week prev year) / last week"

I am somewhat new to Qlikview and am unfamiliar with the scripting process or the funcions within the expression box so any and all help is much appreciated.

Please let me know what you can come up with because I am kind of at a loss right now.

I am using Personal Edition so I can't open any other documents either, so screenshot or something of the like would be best.

Thank you tons in advance

Jared

0 Replies