Hi,
I have this graph :
I want to add a bar wich calculate all amount before current year and another bar wich calculate all amounts after decembre 2022.
I create 3 expressions :
=Sum({<[Date _rec] = {'>=$(=vCurrentMonth)<=$(=v7NextMonth)'}>}[Amount])
=Sum({<[Date_rec] = {'<=$(=vCurrentMonth)'}>} [Amount])
=Sum({<[Date_rec] = {'>=$(=v7NextMonth)'}>} [Amount])
I want to obtain previous amount and next amount in same graph, but i don't know how can i do it in QlikView :
I try this set analysis :
=rangesum(above(total Sum({<[Date de réception prévisionnelle] = {'<=$(=vCurrentMonth)'}>} [Simulation écart en valeur absolue]),0,rowno(Total)))
But it does'nt group all previous months
Thanks in advance