RangeAvg dimension

[k_burata]

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

[sudhirpkuwar]

Try the Sort options on chart

[k_burata]

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

[sudhirpkuwar]

what Sort did you try...?

[sudhirpkuwar]

I m unable to access the Object properties in your QVW

So i cant see your application

[Anil_Babu_Samineni]

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

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

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?

[k_burata]

I used sorting by Expression. Reattached QV app As well

[k_burata]

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?

[qlikviewwizard]

Hi,Can you attach the sample data?

[sunny_talwar · Accepted solution]

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!