Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jmialoundama
Specialist
Specialist

Bar chart : Sum cumul for previous et next months

Hi, 

I have this graph :

jmialoundama_0-1655843824123.png

 

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 : 

jmialoundama_1-1655844374549.png

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

jmialoundama_0-1655847489017.png

 

Thanks in advance

Labels (1)
0 Replies