Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,