Range sum not working properly

[#1]

Hello all i have a range sum function which is performing well in a pivot table, but when i use the same expression in line chart the values are plotting wrong on the graph  . What could be the possible cause for this ? is there any bug in qlik view 12 ? or is the exp wrong ?

Range Sum (Above( Sum Amt), 0, Week))

[swuehl]

More than one dimension?

[Peter_Cammaert]

The expression is wrong for sure, because this is not something QlikView understands in any object (unbalanced parentheses?). You'll get a lot of syntax errors from the start.

Can you post the correct expression and the dimensions you use in your line chart, and the set of dimensions that you use in your pivot table? Or maybe even better, an example document with reduced data that exhibits the line chart problem and contains a pivot table that works according to your expectations?

Thanks.

[#4]

yes

[#5]

Range Sum (Above(Sum({$<Data_Type={'Billing'},Qtr={'2016*', '2017*'} >}Amt), 0, Week)

[Kushal_Chawda]

What are the dimensions in charts? Would you be able to post sample file with expected output?

[swuehl]

What you see is most probably due to Above() function considering the column segments or that the sort order of the internal table is different in your two charts.

Above ‒ QlikView

Can't tell more with the few information provided, as always, context is essential to any question, please provide full context (at least all dimensions and expressions, specific chart settings you've modified, maybe also an overview of the data model) with your questions.

[tresesco]

One visible error: Its RangeSum, not Range Sum (no space in between)