Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Help with a Rangesum/before formula

I have a range sum formula that works perfectly in a chart that performs a sliding average based on the previous 3 columns in pivot table chart.  The following is the formula

=(rangeavg(before( $(vORDERS,1,3)))  /  (rangeavg(before( $(vINVOICES,1,3)))

The issue I am having is that when i try and use this formula to plot a bar or line chart  I do not get any results.  I would be grateful if anyone could let em  know what I am doing wrong and if thay have any ideas as to a possible workaround.

Many thanks

P.

1 Solution

Accepted Solutions
lironbaram
Honored Contributor II

Re: Help with a Rangesum/before formula

hi i think

before is only working in pivotchart

you need to replace the before function with above function

5 Replies
lironbaram
Honored Contributor II

Re: Help with a Rangesum/before formula

hi i think

before is only working in pivotchart

you need to replace the before function with above function

Not applicable

Re: Help with a Rangesum/before formula

Liron Baram

Many thanks for the quick response.  Your suggestion works perfectly.

P.

Not applicable

Re: Help with a Rangesum/before formula

Liron Baram

Many thanks for the quick response.  Your suggestion works perfectly.

P.

Not applicable

Re: Help with a Rangesum/before formula

Liron Baram

Many thanks for the quick response.  Your suggestion works perfectly.

P.

Not applicable

Re: Help with a Rangesum/before formula

Many thanks Liron Baram

Community Browser