Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Sorry, can you explain me more details about the data input ?
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.