topic Re: Range sum not working properly in QlikView

Range sum not working properly

Thu, 29 Jun 2017 21:48:20 GMT

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))

Re: Range sum not working properly

swuehl — Thu, 29 Jun 2017 22:20:21 GMT

More than one dimension?

Re: Range sum not working properly

Peter_Cammaert — Thu, 29 Jun 2017 22:30:52 GMT

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.

Re: Range sum not working properly

Thu, 29 Jun 2017 23:44:25 GMT

yes

Re: Range sum not working properly

Thu, 29 Jun 2017 23:47:11 GMT

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

Re: Range sum not working properly

Kushal_Chawda — Fri, 30 Jun 2017 09:31:12 GMT

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

Re: Range sum not working properly

swuehl — Fri, 30 Jun 2017 09:54:42 GMT

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.

Re: Range sum not working properly

tresB — Fri, 30 Jun 2017 10:06:32 GMT

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