topic QlikSense Appearance/Colors and legend/Colors custom option impacts legend sortings in App Development

QlikSense Appearance/Colors and legend/Colors custom option impacts legend sortings

adamgaox — Sat, 16 Nov 2024 07:45:55 GMT

Dear All,

I created a stack bar chart with time and product as dimensions.

I sorted the the stack bar by "Sort" field in the script and set the sorting option sort by "Sort" field in product dimension.

Since my product is over 12 products and I turn off the Appearance colors auto option then the "Sort" field not works.

Anybody know how to fix this issue?Thanks in advance.

Assign the sorting option in product dimension.

After disable Colors Auto option the legend sorts changed:

I've attached my qvf file.Thanks a lot.

Best Regards.

Adam.

Re: QlikSense Appearance/Colors and legend/Colors custom option impacts legend sortings

bwisealiahmad — Mon, 27 Aug 2018 07:29:25 GMT

Hi,

I've read about this before and there it was noted that this is default for Qlik Sense. Have you tried to load the data in the specific order you want and then leave it all on "auto"?

Best,

Ali A

Re: QlikSense Appearance/Colors and legend/Colors custom option impacts legend sortings

adamgaox — Mon, 27 Aug 2018 07:44:30 GMT

No, I don't try that.You mean when loading the data in script and add order by in the script?

Best Regards.

Adam

Re: QlikSense Appearance/Colors and legend/Colors custom option impacts legend sortings

bwisealiahmad — Mon, 27 Aug 2018 07:53:15 GMT

Hi,

Yes that could be worth trying...you wouldn't have to have a "Sort" field and I think it would sort default both legend and sorting order.

Let us know how it goes.

Best,

Ali A

Re: QlikSense Appearance/Colors and legend/Colors custom option impacts legend sortings

adamgaox — Mon, 27 Aug 2018 08:54:50 GMT

I tried that way but it not works, actually from the result its auto sort rules is by product name from A-Z.

Re: QlikSense Appearance/Colors and legend/Colors custom option impacts legend sortings

bwisealiahmad — Mon, 27 Aug 2018 20:47:02 GMT

Hi,

Any way you can share some example data?

Re: QlikSense Appearance/Colors and legend/Colors custom option impacts legend sortings

adamgaox — Tue, 28 Aug 2018 02:03:32 GMT

Hi Ali,

Attached file above, thanks for your time.

Best Regards.

Adam.

Re: QlikSense Appearance/Colors and legend/Colors custom option impacts legend sortings

bwisealiahmad — Thu, 30 Aug 2018 09:57:36 GMT

Hi,

Can't seem to get it to work. I tried with some ideas, but can't seem to sort that legend. Seems like that part isn't connected to the actual expression under the sorting.

😕

Best,

Ali A

Re: QlikSense Appearance/Colors and legend/Colors custom option impacts legend sortings

BalaBhaskar_Qlik — Thu, 30 Aug 2018 13:51:53 GMT

Try expression like this, in Sorting by expression area:

=sum({<Salesvalues = {'$(=Max(Salesvalues))'}>}Product)/sum (total Time> Product)