topic Re: Is it possible to divide a listbox into two? in QlikView

Is it possible to divide a listbox into two?

Tue, 21 Jan 2014 01:10:34 GMT

Hello,

I have a list box which contains over 200 item names and half of them start with 'A' and the others start with 'B'

I tried to divide it using expesion:

listbox1...if(index(ItemName,'A')=1,ItemName,Null())

listbox2...if(index(ItemName,'B')=1,ItemName,Null())

I could divide the listbox, but When I choose items from listbox1,

I can't choose from items from listbox2.

Is there any way to keep the selection?

Or is there any other way to divide the listbos?

I tried alternate state too, but it doesn't work.

Maybe because what I want to choose is items in same columns in same pivot table.

Thank you in advance.

Re: Is it possible to divide a listbox into two?

iktrayanov — Tue, 21 Jan 2014 01:25:03 GMT

You can do it in the load script. something like

load

ItemName,

if(index(ItemName,'A')=1,ItemName,Null()) as ItemName_A

if(index(ItemName,'B')=1,ItemName,Null()) as ItemName_B

...

This way you will have two new fields you can use.

Hope that helps.

Re: Is it possible to divide a listbox into two?

Tue, 21 Jan 2014 01:50:38 GMT

Thank you, Ivan. but I don't want to really devide the items.

I just want to show in two different listbox and keep them as one group of items.

My listbox and chart are like below.

I want to choose A_xxx and B_xxx, but when I devide the listbox, I can choose only A_xxx or B_xxx.

<chart>

item　　　price

A_001　　2000

A_002　　1500

A_003　　1300

B_001　　1300

<Current listbox>

A_001

A_002

A_003

A_004

B_001

B_002

<listbox I want to make>

listbox1:

A_001

A_002

A_003

A_004

listbox2:

B_001

B_002

Re: Is it possible to divide a listbox into two?

Anonymous — Tue, 21 Jan 2014 02:13:27 GMT

Listbox 1:

=IF(WILDMATCH([item],'A*'),[item])

Listbox2:

=IF(WILDMATCH([item],'B*'),[item])

Attachment for reference.

Re: Re: Is it possible to divide a listbox into two?

Tue, 21 Jan 2014 02:19:26 GMT

The ITEMNAME field associated to data model so when ever you select ITEMNAME-A List box the data will be filtered out based on your selection. So you can't select both LB values at the same time.

Here is the Idea:

Please create the 2 fields in the script level with out attaching to data model (Islands).

Please use "Toggle Select" action on these 2 list boxes. Please find the attached qvw for reference.

Re: Is it possible to divide a listbox into two?

Tue, 21 Jan 2014 02:30:35 GMT

Thank you dathu.qv,

This is quite similar to what I want to do. I'll try to adjust it to my qvw.

Thank you very much!

Re: Is it possible to divide a listbox into two?

Tue, 21 Jan 2014 02:34:00 GMT

Please make sure the expression working correctly in your trigger if multiple values selected in one List box.

= '(' & getfieldselection(ITEMNAME_A, '|') & ')'

Re: Is it possible to divide a listbox into two?

Tue, 21 Jan 2014 02:37:27 GMT

Thank you again for the advice.

Re: Is it possible to divide a listbox into two?

Mon, 10 Feb 2014 10:19:10 GMT

Hi Dathu,

I need one help from you.

I have two list box, Year and Month. if i am selecting year, all value of month is coming in Month list box based on year. but when i am selecting Month(any suppose Jan,feb),so year filter is going off and year is now getting selected based on Month.

i want to select Year(suppose 2013 and 2014) and in Month(suppose Jan,Aug) and want to populate the data for selected year and selected month only but filtering is not happening based on both.its taking either month or year.

Could you please suggest what i have to do..?

Regards,

Ratan