show list box

[#1]

Is there  a way to show a list box only when you select value from a table box..If yes,please provide an example.

Thanks a bunch.

[maxgro · Accepted solution]

PFA

EDIT: sorry, added, try and let me know

[#3]

I dont see any attachment.Can you please send again.

[kuczynska]

Create your listbox. Go to Layout tab and Show section:

Select Conditional show and type an expression, my example:

if(GetSelectedCount(Region) >= 1, 1,0)

Listobox will be displayed only when there is any selection made in the Region listbox (one or more values):

Otherwise, it will not be visible:

[Anonymous]

You can use the "GetSelectedCount"-function;

In the list box properties > Layout > Conditional, write GetSelectedCount(YourField)

If you have several fields that you want to check for selections, use "or";

GetSelectedCount(YourField1) or GetSelectedCount(YourField2)

You can do this for all your fields in your table box, if you want it to react on all selections done in the table.

[Anonymous]

I see that Kuczynska wrote basically the same before me. The minor difference in the syntax is that the conditional is basically an if. I QlikView, all values other than 0 is "true" while 0 is "false".

This means that you do not need to write your own if-statement, as the GetSelectedCount will return 0 (false) when nothing is selected, or the number of selections 1,2,3....(true).

Good luck!

[chaper]

See the atatchment.In the example select a single product from table box will show Customer list box.Is this what you are looking for?

[kuczynska]

kim.rormark You're right IF it's not necessary in this case, for some reason I get used to using it every now and then, probably that's why. GetSelectedCount(Region) >= 1 will do the job as well.

[Anonymous]

I do too, I just try not to give others my own bad habits! Good answer, though!

[#10]

Thank you.It did work