topic Re: Pivottable, Listbox and sort Function in App Development

Pivottable, Listbox and sort Function

Frédéricdh — Thu, 22 Feb 2024 08:19:51 GMT

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?

Re: Pivottable, Listbox and sort Function

Frédéricdh — Thu, 22 Feb 2024 10:35:12 GMT

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

Re: Pivottable, Listbox and sort Function

hic — Thu, 22 Feb 2024 10:46:57 GMT

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.

Re: Pivottable, Listbox and sort Function

Frédéricdh — Thu, 22 Feb 2024 11:02:07 GMT

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?

Re: Pivottable, Listbox and sort Function

hic — Thu, 22 Feb 2024 12:19:17 GMT

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' )

Re: Pivottable, Listbox and sort Function

Frédéricdh — Thu, 22 Feb 2024 13:21:27 GMT

wonderfull but i Must work to understand why.

Re: Pivottable, Listbox and sort Function

Frédéricdh — Thu, 22 Feb 2024 14:06:14 GMT

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: