# New to QlikView

Discussion board where members can get started with QlikView.

Contributor

## Cumulative Total

Hi Sunny, i am not able to attach the qvw in our previous blog so i created new one. please find the attachmen

thanks ,

hima

Tags (1)
1 Solution

Accepted Solutions
MVP

## Re: Cumulative Total

Try this

=RangeSum(Before((count({\$<SHIPPED_DATE={'*'}>}DISTINCT ITEM))/(count(TOTAL <YearQuarter>{\$<CREATION_DATE={'*'}>}DISTINCT ITEM)), 0, ColumnNo()))

13 Replies
MVP

## Re: Cumulative Total

Try this

=RangeSum(Before((count({\$<SHIPPED_DATE={'*'}>}DISTINCT ITEM))/(count(TOTAL <YearQuarter>{\$<CREATION_DATE={'*'}>}DISTINCT ITEM)), 0, ColumnNo()))

Contributor

## Re: Cumulative Total

Hi Sunny,

amazing

your blogs always helps me a lot.

its absolutely working fine, can i create rolling quarters for this. i mean in Reporting Periods part only??

and one more i need is there are few items which are not been shipped yet its coming under quarter Q how can i avoid that

MVP

## Re: Cumulative Total

Can you elaborate on your requirements? May be provided the output you expect to see in QlikView

Contributor

## Re: Cumulative Total

sorry may be was not clear

i want to avoid the Q quarter in the below data. we are getting that Q value due to null values present in the data. but in the shipped count we should show that

i am unable to share the data so i shared the above screenshot.

MVP

## Re: Cumulative Total

Are you using a calculated dimension for the dimension at the top?

Contributor

## Re: Cumulative Total

no i just created year and quarter on that field if see in my script you will find that

MVP

## Re: Cumulative Total

May be use a set analysis to exclude it

{<YearQuarter -= {'Q'}>}

Contributor

## Re: Cumulative Total

Hi Sunny,

i implemented the same in my expression but it is not working. still the Q is appearing in my data is there any chance to remove that.

MVP

## Re: Cumulative Total

What are your dimensions and what expression did you use?