Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
k_burata
Creator
Creator

RangeAvg dimension

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?

Capture.PNG

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

Thanks

1 Solution

Accepted Solutions
sunny_talwar

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

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

Capture.PNG

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

The sortable Aggr function is finally here!

View solution in original post

10 Replies
sudhirpkuwar
Partner
Partner

Try the Sort options on chart

k_burata
Creator
Creator
Author

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

sudhirpkuwar
Partner
Partner

what Sort did you try...?

sudhirpkuwar
Partner
Partner

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

Capture.png

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?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
k_burata
Creator
Creator
Author

I used sorting by Expression. Reattached QV app As well

k_burata
Creator
Creator
Author

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

Capture.PNG

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?

Capture.PNG

qlikviewwizard
Master II
Master II

Hi,Can you attach the sample data?

sunny_talwar

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

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

Capture.PNG

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

The sortable Aggr function is finally here!

View solution in original post