topic Re: Sorting a bar chart by two criteria in Sense in App Development

Sorting a bar chart by two criteria in Sense

godfreydaniels — Wed, 24 May 2017 20:09:14 GMT

In the below image, I want to sort so that Nation is first, A is second, then A1 thru A4 by descending value. In the settings it looks as though this is possible, but it is not working. I've created a Sort column, where Nation is 1, A is 2, and the others are 3. I made the dimension the primary sort column, checked 'by Expression,' and entered, '=Max(Sort).' Then I checked to sort by value, descending. (I also tried with the dimension by expression only, and the measure by descending value.)

When I choose to sort only by the 'Sort' column OR descending value, each works correctly. When I try to combine them, A1-A4 seem to display by load order. How can I achieve the desired result? The app is attached.

Thanks

Re: Sorting a bar chart by two criteria in Sense

sibusiso90 — Wed, 24 May 2017 22:33:23 GMT

Please find the attached below for your sorting issue. I hope you find this helpful. You will just switch off your legend. Pity Qliksense doesn't have text in chart.

Re: Sorting a bar chart by two criteria in Sense

godfreydaniels — Thu, 25 May 2017 12:13:27 GMT

Thank you Sibusiso, but I can't see what you did--your attached file looks like my own. Did you attach the right one?

Thanks

Re: Sorting a bar chart by two criteria in Sense

sibusiso90 — Thu, 25 May 2017 14:34:45 GMT

Hi Godfrey

I have changed the name and made it clearly differential
Please find the below attachment and let me know if you still have issues.

Kindest Regards

Sibusiso

Re: Sorting a bar chart by two criteria in Sense

godfreydaniels — Thu, 25 May 2017 17:05:39 GMT

Thank you--I can see what you did in this one. It achieves the desired effect, but unfortunately can't be used in my case. My sample app is just a proof-of-concept, but the real app would have hundreds of territories, so I will need to use a single measure.

Thanks again for your help.

Edit: I replied in the wrong place--this was meant as a reply to Sibusiso's second reply.

Re: Sorting a bar chart by two criteria in Sense

sibusiso90 — Thu, 25 May 2017 17:52:39 GMT

You can use expection function e() to exclude the first few elements then you all the rest of the elements will be shown, will respond with an example in an hours time

Re: Sorting a bar chart by two criteria in Sense

sibusiso90 — Thu, 25 May 2017 20:19:29 GMT

Hi Godfrey

As promised please find the attached document for the idea I was talking about in the above comment.

Re: Sorting a bar chart by two criteria in Sense

plexpro52 — Fri, 21 Jul 2017 18:01:05 GMT

Hello Sibusiso,

Is there an advantage to using the e() function:

sum({<Relation_display3=e({<Relation_display3={'A','Nation'}>}Relation_display3)>}Value)

...over simply using the "not in" operator? I.e.,

sum({<Relation_display3-={'A','Nation'}>}Value)

Thanks,

René