topic Chart inter record functions rule out sorting in QlikView

Chart inter record functions rule out sorting

Tue, 10 Mar 2015 13:29:11 GMT

I would like to create a waterfall chart and need to calculate the offsets. As an important requirement, however, the chart should show the values in descending order.

I narrowed the issue down to the following problem, see table. Essentially I would like QV to sort according to column 2 and consecutively calculate column 3.

Product Units Unit Offset

C 4 0

D 3 4

B 2 7

A 1 9

In QV I calculate column 3 by the following statement

RangeSum(Above(Column(1),1,RowNo()-1))

which yields the right values except that the above() function seems to rule out the sort order (the rows are now sorted by "Product")

Maybe this is related to the bug I discovered here, but maybe somebody already found a workaround.

Re: Chart inter record functions rule out sorting

hic — Tue, 10 Mar 2015 14:48:15 GMT

If you use inter-record functions, the "normal" sort functions don't work. Instead you need to sort by expression. So, entering "Units" or Avg(Units) here should do the trick.

See also bullet 2 in the instructions of Recipe for a Pareto Analysis where I use an inter-record function to create the Pareto chart.

HIC

Re: Chart inter record functions rule out sorting

Wed, 11 Mar 2015 09:38:44 GMT

Thanks, works! That's indeed a good trick to know!