Pivot Table - Sort top article per month

[Anonymous]

Hi!

I started the discussion here https://community.qlik.com/blogs/qlikviewdesignblog/2016/12/12/pareto-analysis

I thought I have found a better solution for the following question: In need a Pivottable that shows the "top articles" in each Month of the Year. The sort order should be:

- Sort YEAR numerically ASC

- Sort Month numerically ASC

- Sort Articels by sum (Sales) in each month. (highest Sales first)

I have created a small example .qvw here: content.heldendaten.eu/SortPivot_TopArticlePerMonth.zip

My current solution (see yellow box in the screenshot) is quite wacky, and I hope that someone has a better solution (maybe with the new sortable aggr?)

Sorting all 3 dimensions by y-Value does not help, as then year and month get sorted the wrong way!

[Anonymous]

Wow, that's interesting Exactly what I want!

Have you talked to someone "official" if this is how it will work in all future releases?

Wenn was it changed at all? Was the sorting changed in QV12.00 Initial Release?

Danke für deinen Einsatz heute! Guten Rutsch & VG nach Deutschland!

Roland

[Anonymous]

One follow up question:

Any chance to sort the pivottable when the Month is in the columns.

Again I can achieve this using my "Aggr"-Dynamic Dimension, but I would love to avoid it!

See again attached .qvw. !

[rbecher]

Found it myself by playing with the options. I think if someone submits this issue (unexpected behavior) this might change in the future. So, still not reliable but a temporarily workaround..

VG und einen angenehmen Jahreswechsel nach Österreich!

Ralf