Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
My Problem is this:
I have a strait table with one dimension, let's say customer and three measures: sales, sales percentage and cumulative percentage.
No problem here.
Now, I need to sort them by sales(Decending). Again, No problem here Using an expression in the dimension.
But, when I add a second Dimensions - Let's say sales manager, I cant sort them again.
Any Ideas?
Regards,
Motty.
Your requirement is not clear. Can you share sample application or data?
Thanks
Hi.
Attached a sample Appl.
This is the Needed Sorting.
The Problem is when I add Sales Manager as a Dimension. I Cant keep the sorting.
Please share data in excel. I don't have access to qlik sense.
Thanks.
I've added Sales Manager to your app and Sales Desc sorting is still there. Please check
Hi.
Thanks for you reply.
There is still a problem. the cumulitive percentage Measure is not sorted the way it was.
Attached
cumulative percentage is the problem. I had issues with trying to do something like this.. you can only sort a table by a dimension when you start using above() and similar functions that are using relative figures, the sorting by a measure happens after the relative stuff. I think I got a little closer with a pivot table, Henric has a blog post about it.
Hi Ron.
I'm not sure why yet but it seems that changing the Cumulative Measure solved the Problem:
rangesum(above( total Sales ,0, count(total Customer)))
Thx.
PS - One Exclusion: If you have Negative numbers the Sales sorting dosnt work (The cumulitve does)