topic How can I force only one selection across multiple listboxes in QlikView

How can I force only one selection across multiple listboxes

Fri, 11 May 2012 15:31:51 GMT

I have a sample dataset as below

Record#	Amount	AUM_tag	AUS_tag	TCP_tag
1	100	AUM	AUS	TCP
2	200	AUM	AUS	TCP
3	300	AUM	AUS	TCP
4	400		AUS	TCP
5	500		AUS	TCP
6	600			TCP

Ideally I would like to create single listbox that showed values AUM , AUS , TCP.

and charts get updated based on what user chooses.

Couldn't find an easy way to accomplish above, I ended up creating three listboxes.

Now I would like to enforce only one selection between 3 listboxed at one time.

Any ideas?

Re: How can I force only one selection across multiple listboxes

erichshiino — Fri, 11 May 2012 18:33:13 GMT

Hi,

You can separate your tags in a single field and associate it with the records. This way, you can use this new field as your only list box.

It will be similar to this script:


temp:
LOAD * INLINE [
    Record, Amount, Tag1, Tag2, Tag3
    1, 100, A, B, C
    2, 200, A, B, C
    3, 150, , B, C
    4, 120, , , C
    5, 50, , , C
];
Table:
Load Record, Amount
Resident temp;
Tags:
Load Tag1 as Tag,
Record
Resident temp
where len(Tag1)> 0
;
Tags:
Load Tag2 as Tag,
Record
Resident temp
where len(Tag2)> 0
;
Tags:
Load Tag3 as Tag,
Record
Resident temp
where len(Tag3)> 0
;
drop table temp;

Hope this helps,

Erich

How can I force only one selection across multiple listboxes

Wed, 16 May 2012 13:51:07 GMT

You can select a value from three different fields in a single list box. Create a list box and in the properties, instead of choosing a field name, choose <expression>. Then, in the expression dialog box, try this: ='AUM=' & AUM_tag & ' AUS=' & AUS_tag & ' TCP=' & TCP_tag then click OK. You will then have a list box that shows all of the combinations of the three field values that occur in the data. A single click on the values shown in the list box selects the corresponding value from each of the three fields at once. You should put a meaningful title into the listbox and, if needed, adjust the list box sort to sort on one of the fields.