Qlik Community

Qlik Sense App Development

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

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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

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.

8 Replies
Highlighted
Partner
Partner

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

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

Highlighted
Creator
Creator

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

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

Best Regards.

Adam

Highlighted
Partner
Partner

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

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

Highlighted
Creator
Creator

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

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

Highlighted
Partner
Partner

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

Hi,


Any way you can share some example data?

Highlighted
Creator
Creator

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

Hi Ali,

Attached file above, thanks for your time.

Best Regards.

Adam.

Highlighted
Partner
Partner

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

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

Highlighted

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

Try expression like this, in Sorting by expression area:

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