Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

Re: Hiding the values in list box

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
MVP
MVP

Re: Hiding the values in list box

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

Or use a field expressions like

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

Highlighted
Not applicable

Re: Hiding the values in list box

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 .

Highlighted
MVP
MVP

Re: Hiding the values in list box

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.

Highlighted
Not applicable

Re: Hiding the values in list box

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??