Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
sogloqlik
Creator II
Creator II

Sorting Strait table with 2 dimantions and 3 measures

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.

8 Replies
isingh30
Specialist
Specialist

Your requirement is not clear. Can you share sample application or data?

Thanks

sogloqlik
Creator II
Creator II
Author

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.

isingh30
Specialist
Specialist

Please share data in excel. I don't have access to qlik sense.

Thanks.

vvira1316
Specialist II
Specialist II

I've added Sales Manager to your app and Sales Desc sorting is still there. Please check

sogloqlik
Creator II
Creator II
Author

Hi.

Thanks for you reply.

There is still a problem. the cumulitive percentage Measure is not sorted the way it was.

sogloqlik
Creator II
Creator II
Author

Attached

campbellr
Creator
Creator

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.

Accumulations

sogloqlik
Creator II
Creator II
Author

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)