Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Qlik Sense - pivot sorting by measures

Hello community!

I am new in Qlik and I alrdy have a lot of questions! But at this moment I got stuck with setting up pivot table. I cannt find how could I sort my pivot table by measures. There is only option to sort it by dimensions. Is there any option to have it sorted by measures?

I use 6 rows and 2 measures and I need to sort it by one measure. It is mandatory for me to analyse data.

I have found a few questions regarding to this, but unanswered or outdated for old version of Qlik.

Thank you very much!

..DB

9 Replies
Khan_Mohammed
Not applicable

Re: Qlik Sense - pivot sorting by measures

Can you share the sample file or at least share the screen shot of your pivot table and what sorting order you needed?

Thanks.

Khan_Mohammed
Not applicable

Re: Qlik Sense - pivot sorting by measures

You cannot sort a chart by measure.

A chart can be only sorted by dimensions. So if you sort your dimension, it will automatically sort the measure as well.

You can sort by expression or numerically or alphabetically as shown below.

Change sorting to 'Custom' and you'll see these options.

Sorting.png

Not applicable

Re: Qlik Sense - pivot sorting by measures

This is how it looks, typical pivot table. I need to sort it by number on the right "by measure". I need these numbers sorted from lowest ot highest. Yea I know that I can sort it by dimension, but it sorts it by "names" in rows, not by numbers on the right.

qlik.png

Khan_Mohammed
Not applicable

Re: Qlik Sense - pivot sorting by measures

Yes you can do that.

In sorting>Custom>aggr(Count(Your Expression), Your Dimension)>Check Descending

Percent.png

Not applicable

Re: Qlik Sense - pivot sorting by measures

Nice! It helped! Thank you very much! ...Sad is, that it works only sometimes.

Sort by first dimension is ok. but for the rest it works on 80% only.

For sort I use - "aggr(Count([Name of measuring]), [Current dimension])" and still there is more then one "glitches"

for web.png

Khan_Mohammed
Not applicable

Re: Qlik Sense - pivot sorting by measures

Hmmm.. I don't know. It should work fine with no glitches.

You can either use

aggr(Count([Name of measuring]), [Current dimension])

or

aggr(Sum([Name of measuring]), [Current dimension])

and adjust to Descending always.

mredmond
Not applicable

Re: Qlik Sense - pivot sorting by measures

It would seem that sorting by measure would be a totally normal thing to do (as with bar charts, where it is available by clicking). Why is this harder in pivot charts?

enricocamerin
Not applicable

Re: Qlik Sense - pivot sorting by measures

I have the same problem I tried all kind of weird aggr and dual formula I read in other post in the forum but without any success.

Very frustrating that such a basic capability is not available. Probably it works with one measure but if you have more measure  it no longer works

remyverhoeven
Not applicable

Re: Qlik Sense - pivot sorting by measures

Tried this, but cannot get it to work with more columns.

I have "CustomerNames" as rows, "Years" as columns and "Revenue" as measures.

In this case I have multiple Years (columns) and want users to be able to sort on Revenue easily. 

Is there another way? 

Very basic feature for a pivot table. Really odd that this is not out of the box included tbh!