topic Re: show list box in QlikView

show list box

Wed, 19 Aug 2015 19:17:16 GMT

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.

Re: show list box

maxgro — Wed, 19 Aug 2015 19:22:48 GMT

PFA

EDIT: sorry, added, try and let me know

Re: show list box

Thu, 20 Aug 2015 12:48:50 GMT

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

Re: show list box

kuczynska — Thu, 20 Aug 2015 12:55:15 GMT

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:

Re: show list box

Anonymous — Thu, 20 Aug 2015 12:56:19 GMT

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.

Re: show list box

Anonymous — Thu, 20 Aug 2015 12:59:03 GMT

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!

Re: show list box

chaper — Thu, 20 Aug 2015 13:01:25 GMT

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?

Re: show list box

kuczynska — Thu, 20 Aug 2015 13:04:32 GMT

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.

Re: show list box

Anonymous — Thu, 20 Aug 2015 13:09:22 GMT

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

Re: show list box

Thu, 20 Aug 2015 13:09:52 GMT

Thank you.It did work

Re: show list box

Fri, 21 Aug 2015 18:00:32 GMT

Hi Massimo,this really worked for me.Thank you.Only issue I have is for the first value selected in the straight table,I have multpile values displayed in the text box where as when I add that text object field within the table I see only one time display.

Ex:I have country and State column in table box.When I select state I get zip code displayed in the Text Object.(This is how I wanted) I have AB,AR,AL etc for State Column.Now when I select AB in straight table,I get 30009 displayed Multiple times.(Only happening for AB,which is the first value in the column) Now when I add Zip code column into to straight table and when I select AB it get displayed only once.

let me know if you can think of any solution for this.

THANK YOU VERY MUCH.