topic Re: variables in same order in list boxes in QlikView

variables in same order in list boxes

Anonymous — Sun, 29 May 2016 16:42:45 GMT

Hi All,

I am having difficulties in arranging two list boxes in the same order. The variable values in the list boxes are in the same row in the data source, and when i select multiple values in one list box the values in the other list box are the corresponding values but not in the same order

e.g:-

date	sales
24-05-2016	23456$
25-05-2016	345645$
26-05-2016	23678$
27-05-2016	123445$

now if we have two list boxes as shown below

list box A - This has been sorted in descending order

date
27-05-2016
26-05-2016
25-05-2016
24-05-2016

List box B - i want the value sales in the other list boxes in the same order as shown below

Expected List box

Header 1
123445$
23678$
345645$
23456$

Please let me know how this scenario can be achieved every time i select multiple values?

- Sonthu

Re: variables in same order in list boxes

oknotsen — Sun, 29 May 2016 19:14:12 GMT

Check the Sort tab. I think you can sort by expression. You probably can make an expression based on the date field.

Alternatively, you could use a Table Box.

Re: variables in same order in list boxes

MarcoWedel — Sun, 29 May 2016 19:33:11 GMT

Hi,

as your sample data is already sorted by date ascending, your could sort the "sales" ListBox in load order reversed:

table1:
LOAD Date#(date,'DD-MM-YYYY') as date,
    Money#(sales,'#,##0.00$;-#,##0.00$') as sales
FROM [https://community.qlik.com/thread/218755] (html, codepage is 1252, embedded labels, table is @1);

hope this helps

regards

Marco