topic Re: List box - Hide field / Create drop down selection in QlikView

List box - Hide field / Create drop down selection

Anonymous — Thu, 30 Oct 2014 20:36:31 GMT

Hello,

Looking for some help with a list box. I am trying to restrict several values from appearing in the list box, while also creating a drop down selector vs. your typical selection box. With the first requirement, I tried to use the following code:

aggr(only({<[GROUP/RETAIL]-={'UNK', 'INVOL'}>}[GROUP/RETAIL]),[GROUP/RETAIL])

with the folowing result:

Looking for some help to properly exclude the values.

For the second requirement, I would like to show only 2 or 3 of the choices, with a drop down arrow if possible to bring up all the other choices. I am trying to do this for a state list box as well if possible.

Thank you for all help as always

Re: List box - Hide field / Create drop down selection

JonnyPoole — Thu, 30 Oct 2014 20:59:52 GMT

With that code , which values exactly do you want to show ? Everything but UNK and INVOL ? I'm not clear.

Re: List box - Hide field / Create drop down selection

Anonymous — Thu, 30 Oct 2014 21:22:50 GMT

You can simulate a dropdown by using a multibox with just one field displayed.

For that one field, click Expression on the General tab of the multi box and enter an expression to the effect of:

If(WildMatch([GROUP/RETAIL], 'UNK', 'INVOL')=0, [GROUP/RETAIL])

(There may be a more elegant expression to use - this just off the cuff)

Re: List box - Hide field / Create drop down selection

Anonymous — Fri, 31 Oct 2014 20:17:40 GMT

blackmon and Jonathan,

That definitely helped and got me one step closer. Is there a way to hide the the Group retail row, and also the selection part on the side? I think it would like really clean if I could just show the Source drop down. I looked up hide suffix or prefix but I am not sure on the syntax.

Re: List box - Hide field / Create drop down selection

Anonymous — Fri, 31 Oct 2014 20:28:24 GMT

I was able to take out Group/Retail. But I was wondering if I could take out the selection box to the right of Source. Just not sure of the syntax if there is a way.

Also, it seems like this may be good to select through tabs in the document. Is there any type of code for that?

Thank you for all the help!

Re: List box - Hide field / Create drop down selection

Anonymous — Fri, 31 Oct 2014 20:55:57 GMT

I don't know that you can completely hide the selection. Checking the grid style checkbox on the multibox Presentation tab will make it more concise though.

You can change tabs by adding a trigger. Settings-->Document Properties-->Triggers tab. In Field Event Trigger, select desired field. Click Add Actions-->Add.Select Layout under Action Type and Activate Sheet under Action. Click OK then put your sheet name in the Sheet ID box.

You can also enter a formula if different values take you to different sheets. Or add a trigger to set a variable with the sheet name and use dollar sign expansion to populate the Sheet ID field. There are myriad ways to go about this really.

Re: List box - Hide field / Create drop down selection

Anonymous — Tue, 04 Nov 2014 16:54:18 GMT

Blackmon,

Thanks for the help. Each step worked.