topic Re: do listbox have dropdown facility? in QlikView

do listbox have dropdown facility?

nithin_miryala — Thu, 14 May 2015 15:18:32 GMT

Hi Everyone,

I have situation, where i need to select the Region which should have checkbox's and it should be under a dropdown ?

I used listbox to get the regions as in above picture. i need the same as a dropdown..

Will it be possible??

Re: do listbox have dropdown facility?

Miguel_Angel_Baeyens — Thu, 14 May 2015 15:20:26 GMT

Hi,

You would need to use either an extension object or an inputbox using constraints. See attached.

Miguel

Re: do listbox have dropdown facility?

Clever_Anjos — Thu, 14 May 2015 15:22:46 GMT

Not a listbox, but you can use a pivot table to do this

PFA

Re: do listbox have dropdown facility?

nithin_miryala — Thu, 14 May 2015 15:23:11 GMT

Hi,

But do we have any option of getting checkboxes in that?

Re: do listbox have dropdown facility?

nithin_miryala — Thu, 14 May 2015 15:24:38 GMT

Hi,

But i want checkboxes as above image.. is it posssible?

Re: do listbox have dropdown facility?

Clever_Anjos — Thu, 14 May 2015 15:29:00 GMT

Not using the pivot table unfortunately

Re: do listbox have dropdown facility?

stigchel — Thu, 14 May 2015 15:31:04 GMT

You can fake it by using a textbox with text and a image for the arrow down. Add a trigger to the textbox that when clicked it will display the normal list box (without caption) directly underneath. Then set a trigger to the field in that listbox to hide the listbox again

Re: do listbox have dropdown facility?

nithin_miryala — Thu, 14 May 2015 15:33:19 GMT

Unfortunately, i want it to be dynamical, as my data is not restricted.

Re: do listbox have dropdown facility?

stigchel — Thu, 14 May 2015 15:36:49 GMT

Not sure what you mean, this has nothing to do with data restriction. I'm suggesting to use a textbox looking like a dropdown that when clicked will display the normal listbox directly underneath

Re: do listbox have dropdown facility?

nithin_miryala — Thu, 14 May 2015 15:44:02 GMT

Yeah, i Understand that but i want firstly all the regions under a dropdown, then a a check box before every region, so i cant fake using a text box.

So i think it is not possible.

Re: do listbox have dropdown facility?

Miguel_Angel_Baeyens — Thu, 14 May 2015 15:44:30 GMT

No, there is not.

An extension object is definitely what you are looking for.

Miguel

Re: do listbox have dropdown facility?

nithin_miryala — Thu, 14 May 2015 15:47:36 GMT

What is the name of it and where can i find it?

Re: do listbox have dropdown facility?

awhitfield — Thu, 14 May 2015 15:48:06 GMT

Your options with a list box are

Or if you want a drop down then use an single item multi box, there's no standard option to do both, drop OR check box - your choice.

Andy

Re: do listbox have dropdown facility?

stigchel — Thu, 14 May 2015 15:49:55 GMT

See example attached, it uses the action of the textbox to set a variable which is used in the conditional show of the listbox

Re: do listbox have dropdown facility?

nithin_miryala — Thu, 14 May 2015 15:50:43 GMT

Yeah, Thanks for reply. I am checking whether it is possible or not.

Re: do listbox have dropdown facility?

Vidit — Thu, 14 May 2015 15:53:19 GMT

Hi,

if you just want to achieve a drop down, a simpler way will be to use that field in MultiBox instead of List box.

It will give you a drop down by default

Re: do listbox have dropdown facility?

nithin_miryala — Thu, 14 May 2015 15:53:42 GMT

Thank You Piet, i think it may be helpful