Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

abhinayranjan11
New Contributor III

dimension as month and unit for revenue and u r accumulating

Guys can anyone tell me if u have dimension as month  and unit for revenue and u r accumulating these value on value on data points and u want to show only the last month value on data point and not on rest of other in the same chart How to do this?

how to do this?

2 Replies

Re: dimension as month and unit for revenue and u r accumulating

Perhaps this document helps: Calculating rolling n-period totals, averages or other aggregations


talk is cheap, supply exceeds demand
MVP
MVP

Re: dimension as month and unit for revenue and u r accumulating

Abhinay Ranjan wrote:

.........show only the last month value on data point and not on rest of other in the same chart How to do this?

how to do this?

If it is more about showing/restricting datapoints, you can do it using 'Show Value' feature of chart like:

Untitled.png

Community Browser