topic Re: Reverse order of dimension in QlikView

Reverse order of dimension

k_burata — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

How do you reverse the order of the dimension without affecting the values? Tried sorting dimension in reverse order but getting the wrong values.

TIA.

Re: Reverse order of dimension

jyothish8807 — Mon, 21 May 2018 04:53:05 GMT

Hi Kim,

As far as i know you cannot achieve the same output with "Full Accumulation" on , since it will consider the max month as first month and do the calculation from the bottom.

The best solution in this case is to use Rangesum(above).

Br,

Re: Reverse order of dimension

k_burata — Mon, 21 May 2018 08:36:07 GMT

Hi KC,

Problem is I don't get the same values when I reverse the dimension. I would like to sort it Apr --> Jan and not Jan --> Apr. Is there like a function that would just flip the chart without changing the values?

Regards,

Re: Reverse order of dimension

ogautier62 — Mon, 21 May 2018 08:46:00 GMT

Hi,

RangeSum(bottom) ?

Re: Reverse order of dimension

jyothish8807 — Mon, 21 May 2018 08:46:09 GMT

You can sort the rangesum chart by setting Y axis decending in sort

Re: Reverse order of dimension

jyothish8807 — Mon, 21 May 2018 08:47:30 GMT

refer the attached.

Re: Reverse order of dimension

sunny_talwar — Mon, 21 May 2018 11:56:48 GMT

You can also try this expression

=Sum(TOTAL {<[Group]>} Qty) - RangeSum(Above(Sum({<[Group]>} Qty), 1, RowNo()))