Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Show predefined values in a Listbox

Hello,

how do I create a filter in a listbox to achieve the result as i Picture 2 without making a choise in the two

listboxes? Shall I do an expression with a set or?

Qv1.png

Qv2.png

1 Solution

Accepted Solutions
Highlighted
Luminary
Luminary

Re: Show predefined values in a Listbox

Hi,

You could do a simple if statement as an expression in the list box.

For example:

If(Switch=21 and Level=3,BDescription)

This will reduce the values in the list box and will not show the grey values.

Hope this helps!

View solution in original post

1 Reply
Highlighted
Luminary
Luminary

Re: Show predefined values in a Listbox

Hi,

You could do a simple if statement as an expression in the list box.

For example:

If(Switch=21 and Level=3,BDescription)

This will reduce the values in the list box and will not show the grey values.

Hope this helps!

View solution in original post