topic Re: custom sort on an expression listbox in QlikView

custom sort on an expression listbox

Tue, 21 Oct 2014 16:46:54 GMT

Hi All,

I have a listbox based on an expression like the following :

=if(aggr(sum(Amount),CustomerCode)<50, '<50', if(aggr(sum(Amount),CustomerCode)<500, '50-500', if(aggr(sum(Amount),CustomerCode)>500, '>500')))

The listbox is working but I have 2 problems :

1) I cant sort by the good order :

<50
50-500
>500

2) when I select a value from this listbox, the 2 non selected values disappear.

Do you know how to solve these issues pls ?

Regards

Re: custom sort on an expression listbox

maxgro — Tue, 21 Oct 2014 16:55:32 GMT

use dual

dual('<50',1) instead of <50

dual('50-500',2)

....

and sort by number

Re: custom sort on an expression listbox

JonnyPoole — Tue, 21 Oct 2014 16:59:44 GMT

For

#2) add a set modifier to cancel out the CustomerCode selection:

=if(aggr(sum( {$<CustomerCode=>} Amount),CustomerCode)<50, '<50', if(aggr(sum( {$<CustomerCode=>} Amount),CustomerCode)<500, '50-500', if(aggr(sum( {$<CustomerCode=>} Amount),CustomerCode)>500, '>500')))

Re: custom sort on an expression listbox

Wed, 22 Oct 2014 07:45:24 GMT

thank you, works fine