Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hiding the values in list box

Hi All,

I have List box with values as below:

Listbox1

A

B

C

1

2

3

A,B,C belong to Alpha

1,2,3 belong to Numeric

I have another listbox with called  Group.

Group

Alpha

Numeric

Now issue is if i select from Group i need to show only available values.  Instead of graying them out.

5 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Not possible, What you can do is create individual field i.e one for Alpha and one for Numeric.

Like

Listbox1:

Load* inline

[

ListBox1 ,Group

A ,Alpha

B ,Alpha

C ,Alpha

];

Concatenate

Load* inline

[

ListBox2 ,Group

1 ,Numeric

2 ,Numeric

3 ,Numeric

];

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
swuehl
MVP
MVP

You can 'Hide excluded' on general tab of list box properties.

Or use a field expressions like

=Aggr(Only({<ListBox1>}ListBox1), ListBox1)

Not applicable
Author

Hi Swuehl thanks for your reply,

But writing that expression wont give me to do "Always one selected value". I also want to do always one selected value there .

swuehl
MVP
MVP

Can you elaborate how you want to operate with these list boxes?

If you enable always one selected values on e.g. the numeric values list box, this will permanently exclude the alpha values. You won't be able to select ever an Alpha value, regardless what is selected in numeric list box.

Not applicable
Author

Yeah I am trying to apply Alternate states to get rid of it.

I am showing few charts based on the slections of Aplha and separate selections of Numeric. so these charts should be populated all the time. to achieve this scenario i am implementing always one selected value in both the listboxes Alpha and Numeric.

Is this possible if i use alternate states??