Show data for n past weeks

[#1]

Hi to all!

I'm trying to show data for 12 past weeks.

I have a table with these columns (Hub is fixed and user can choose ONLY one hub):

INSERT DATE       HUB    -    VALUE - other stuff

I need something like this, start from current date (today is 02/08):

02/08/2014 - Italy - pippo - 10  - - - - -

26/07/2014 - italy - pippo    11 ----

19/07/2014 - italy - pippo     4 -----

...

...

...

17/05/2014 - italy - pippo    20

From the qvd I took insert date, year(insert date), month(insert date) and week(insert date).

I can use max(date) , max(date,2), min(date) but I don't know how I could solve my issue

Any tips?

thank you guys!

A.

[ecolomer]

Sorry, can you explain me more details about the data input ?

[#3]

Hi Enrique, I'll try to explain better, sorry!

For this table, I have a QVD with columns:

Insert Date (dd/mm/yyyy hh:mm:ss)

Hub

Value (in expressions)

and other columns , but there are meaningless for my issue.

I would to do something like that:

for every hub (fixed first) show the past 12 weeks, so:

week12 - hub - value1

week11 - hub - value2

...

week1 - hub - value.

But I don't know how

Hope I explained better, thanks again for your time!

A.