Pivot Table Sorting - Qlik sense

[Anonymous]

Hi,

I Have ש pivot table with three dimensions and one expression,

the table is fully expanded and the third dimension shows only top 10.

I want that the third dimension will be in descending order by the expression.

any idea.

Thanks,

Jacob

[luismadriz]

or even better, your qvf

[luismadriz]

I just created one with the data you posted

And the qvf..

Please give it a go and let me know,

Cheers,

Luis

[Anonymous]

I think that I wasn't clear, my desire is that in each store + Group the items will be sorted by the quantity.

i.e

Shop	Group	sum(Qty)
A	I	58
		54
		35
B	I	85
		42
		23
	II	55
		22
		15

[luismadriz]

Hi, those items in the screenshot are sorted by the quantity for each shop and group.

I still don't get it

[luismadriz]

Where are the items?

[luismadriz]

like this?

[luismadriz]

Hi Jacob,

Please let me know if you still have this question

Cheers,

Luis

PS. When applicable please mark the appropriate replies as Correct. This will help community members know which discussions have already been addressed and have a possible known solution. Please mark replies as Helpful if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as Helpful if you feel additional info is useful to others

[Anonymous]

Hi,

The solution you offered is working depending on the data set, in my case is not working well...

[luismadriz]

Hi Jacob,

When you created the post offered a requirement and some data, then I provided you with a solution that proved to solve the problem as you posted it.

I don't have any information about your data set, I only have the information you provided. If you want, please create another post with information that's closer to your situation.

As for this post, can you please close it?

Many thanks,

Luis

[Anonymous]

Awesome Luis! luismadriz‌

I was searching all day for this solution and finally found it in the qvf file you've shared over here.

This saves me a weekend shift, so cheers to you mate

Your efforts are much appreciated!

Mike