topic RangeAvg dimension in QlikView

RangeAvg dimension

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

Hi,

Related to my question earlier Reverse order of dimension

to reverse order of dimension when using a Range Sum but this time I want to use Rolling RangeAvg starting from current up to Last 90 days but would like it displayed as 90 --> 7 days in the x axis. Any thoughts?

What I would like to do is to reverse the order of dimension without affecting the Y values.

Thanks

Re: RangeAvg dimension

sudhirpkuwar — Fri, 25 May 2018 06:24:39 GMT

Try the Sort options on chart

Re: RangeAvg dimension

k_burata — Fri, 25 May 2018 06:30:56 GMT

Hi Sudhir, I already did. Problem is I am using a Rolling RangeAvg.

Re: RangeAvg dimension

sudhirpkuwar — Fri, 25 May 2018 07:18:35 GMT

what Sort did you try...?

Re: RangeAvg dimension

sudhirpkuwar — Fri, 25 May 2018 07:19:38 GMT

I m unable to access the Object properties in your QVW

So i cant see your application

Re: RangeAvg dimension

Anil_Babu_Samineni — Fri, 25 May 2018 07:30:57 GMT

I suggest you to read what these functionality do https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/RangeFunctions/rangeavg.htm

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/RangeFunctions/rangesum.htm

Then, Change your table into straight table for analysis purpose how this works, I would suggest you to do testing using RangeSum().

This is what i am getting, without any Range measure

So, Qlik don't know which measure you written for comparison of your sort that you need to segregate using that

Does it make sense?

Re: RangeAvg dimension

k_burata — Fri, 25 May 2018 08:14:38 GMT

I used sorting by Expression. Reattached QV app As well

Re: RangeAvg dimension

k_burata — Fri, 25 May 2018 08:32:30 GMT

Hi Anil,

This works but I am trying to get Rolling Average and not per item in the dimension.

Here is what I'm trying to achive

I did it using barchart (Left graph) but when reversed dimension through sorting the values changed. How can I reverse dimension without changing the values?

Re: RangeAvg dimension

qlikviewwizard — Fri, 25 May 2018 09:52:47 GMT

Hi,Can you attach the sample data?

Re: RangeAvg dimension

sunny_talwar — Fri, 25 May 2018 12:01:44 GMT

As long as your sort order is correct from the script..you can try this

Aggr(RangeAvg(Above(Sum({<[Group] = >}Qty), 0, RowNo())), Month)

Or you can use this approach if you have QV12 or above installed

The sortable Aggr function is finally here!

Re: RangeAvg dimension

k_burata — Wed, 06 Jun 2018 02:35:39 GMT

Thanks Sunny,

This is great!