Qlik Community

Ask a Question

App Development

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

Support Case Portal will move to Qlik Community Oct 4. Temporary case outage Oct 3. READ DETAILS
Showing results for 
Search instead for 
Did you mean: 

Order of legend items in stacked bar chart

Hi all,

I am having a problem with the order of the items in my legend in a stacked bar chart. My model looks like:


My app looks like:

Screen Shot 2018-10-02 at 18.48.46.png

The first dimension is brand and the second dimension "discountDiff" is defined as:

Class(Aggr(Avg(discountDiff), brand, subbrand, product), 1)

The measure is defined as:

Count(distinct subbrand)

which creates all the buckets that I expect to see. But when I choose a product in my filter, the order of items in the legend is not correct:

Screen Shot 2018-10-02 at 18.48.56.png

I know that it has something to do with the main dimension "brand" that is somehow evaluated before the discountDiff classes is calculated.

I have also read in another discussion that the sorting is based on the measure number behind each bucket, which in this case is the number of sub brands represented by the discountDiff class.

I have tried manipulating the sort order of the discountDiff dimension with a set expression, but I have not managed to get it to work.

Any good advice?


0 Replies