Discussion board where members can learn more about Qlik Sense Data Connectivity.
In Qlik Sense
I need Sum of Sales for Rolling 12 Months and also my Year Month needs to show only 12 months. Below is sample data please ignore the values and need to represented in line chart
In Line chart Year Month as X Axis and Sum of Rolling 12 Month Sales in in Y Axis.
I used rangesum(above(sum(sales)),0,12)) but on line Chart X Axis is dsiplaying all Year Month with null values which I dont want to show.
I need to show only 12 Months on X Axis and Sum of Rolling 12 Months. Any suggestions
|Year Month||Sales||Sum of Rolling 12 months|
Still All Year Months as displayed in chart with value Zero. I need to display only Last 12 Months on X Axis and metric needs to be Sum of Rolling 12 Months for the corresponding month.