Need urgent help regarding Cumulative Sum

[jaspal_icon]

I have one Bar chart in which I have two dimension :

FIrst Dimension: Month_Year

Second Dimension: Product_Name

And in Expression : rangesum(above( TOTAL sum(Total_Cost), 0, rowno(Total)))

Now is Result I am execpting is that on every next bar the previous bar total should be add. Now if you see the Image the "GREY" color Product has not come in "Aug-2007".

I have set expression to "FULL ACCUMULATION". Dimensions I have check by setting "Suppress When Value is Null" true/false bot. but I Have not able to find the solution.

Kindly grab some time to solve this.

[jaspal_icon · Accepted solution]

Hi

Bilge and Qlik_techie,

Thanks for your help.

The solution not exactly solved my problem but was very helpful to understand.

I got the solution, what I did:

First in Script I Laod Distinct Product Name in a non link table Say Product_table2:

in which I have only Products- Product_New.

Now in Chart

In Dimension I used First MonthYear, Second Product_New(Non Linked Table column).

After that in Express I Wrote Sum(If(Product=Product_New, Total_Cost,0))

By using this expression and using Full Accumulation. it gives a desired Result.

Thanks All.