Set analysis with Date vs Date - 364

Thu, 17 Jan 2013 18:30:45 GMT

Hi Experts,

I have scenario where I would like to compare the sale of a date with the least 364 days of the date ( for example this image).

But i want to add a dimension "date" to the chart. The aim is to compare sales day by day

Date	Category	Sales	Sales - 364
03/01/2013	Books	0	50
03/01/2013	Electronics & Computer	25	0
03/01/2013	Movies	15	5
05/01/2012	Books	50	3
05/01/2012	Clothing	0	5
05/01/2012	Movies	5	12

I try with expression :

Sales = =sum({$<DATE={">=$(=min(DATE))<=$(=max(DATE))"},Année=,Mois=,Trimestre=,Jour=>}Montant)

and

Sales - 364 = sum({$<DATE={">=$(=date(min(DATE)-364))<=$(=date(max(DATE)-364))"},Année=,Mois=,Trimestre=,Jour=>}Montant)

But with that, Qlikview returns : chartwithdimensiondate.JPG

I think we should use the function aggr () but i'm not sure.

Any help is highly appreciated.

Thanks & Regards,

topic Set analysis with Date vs Date - 364 in QlikView