Pivottable, Listbox and sort Function

[Frédéricdh]

Hello,

I have two Objects, a Pivottable with the Dimensions Location and Weeks and a Listbox with only Week.

In the Pivottable the location have a particular order and the expression in the pivottable is Sum ({<Week= >} Load)

But when I click on a week in the Listbox, the order isn't anymore respected. see image:

What must I do?

[Frédéricdh]

An when i use the expression Sum(Load) without set modifier, I have this:

the order is now ok but I want to see all the pivottable

[hic]

The sort order uses - by default - the current selection as input. If you have an expression with a set expression, you need to use the same set expression in the sort order.

So, try to sort by expression and use {<Week= >} in it.

[Frédéricdh]

thanks for the reply, it's very nice.

my sort order is based on: Match ( Location, 'A', 'B', 'C'), where i must insert the set expression?

[hic]

That expression will not always work. You need an aggregation function. See more on https://community.qlik.com/t5/Design/Use-Aggregation-Functions/ba-p/1475833

You could try 

Match( Minstring( {<Week= >} Location ), 'A', 'B', 'C' )

[Frédéricdh · Accepted solution]

wonderfull but i Must work to understand why.

[Frédéricdh]

And now i want to color the different location but Qlikview color the Total too:

the expression for the color is Pick(Match(Minstring({<Week=>} Location), 'A', 'B'), rgb(X,Y,Z), rgb(Y,X,Z))

and sometimes Qlikview doesn't color the location although it colored for another installation: