topic Re: Sorting Strait table with 2 dimantions and 3 measures in App Development

Sorting Strait table with 2 dimantions and 3 measures

sogloqlik — Wed, 16 May 2018 19:18:24 GMT

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.

Re: Sorting Strait table with 2 dimantions and 3 measures

isingh30 — Wed, 16 May 2018 19:41:05 GMT

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

Thanks

Re: Sorting Strait table with 2 dimantions and 3 measures

sogloqlik — Thu, 17 May 2018 11:55:34 GMT

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.

Re: Sorting Strait table with 2 dimantions and 3 measures

isingh30 — Thu, 17 May 2018 12:16:06 GMT

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

Thanks.

Re: Sorting Strait table with 2 dimantions and 3 measures

vvira1316 — Thu, 17 May 2018 12:27:32 GMT

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

Re: Sorting Strait table with 2 dimantions and 3 measures

sogloqlik — Thu, 17 May 2018 12:40:16 GMT

Hi.

Thanks for you reply.

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

Re: Sorting Strait table with 2 dimantions and 3 measures

sogloqlik — Thu, 17 May 2018 12:45:34 GMT

Attached

Re: Sorting Strait table with 2 dimantions and 3 measures

campbellr — Thu, 17 May 2018 12:52:45 GMT

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

Re: Sorting Strait table with 2 dimantions and 3 measures

sogloqlik — Thu, 17 May 2018 13:35:02 GMT

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)