Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
nishika
Partner - Contributor III
Partner - Contributor III

Cummulative the data till current month as the first bar and then disappear the previous month bars from the bar chart

Hi

In Bar chart, im having data for two year i.e  2021 and 2022.

Bar Graph should do the following

Cumulative the data till current month will be the first bar (i.e for today March will be the first bar) ,Jan and Feb should  disappear  from the bar chart and append to December and should show data for next year only.

Cumulative till month done by below expression :

variable: $(v_rolling) = sum([order volume]-[billed volume])
=if(CalendarMonthName <= Month(today()),aggr(rangesum(above(sum($(v_rolling)),0,RowNo())),territory,(CalendarMonthName,(Numeric))),sum($(v_rolling)))

ngangrad_0-1614869798223.png

Please Help for disappearing the bar for the previous month from the actual and append to the last of December 

Condition is should only show data for Next year after the december.

Labels (2)
0 Replies