topic Re: Need Help To Have one Blank Field but not Selectable in QlikView

Need Help To Have one Blank Field but not Selectable

Thu, 16 Jul 2015 15:26:02 GMT

This Is standard behavior of Qlik:

But I want the listbox to be looks like

Here I have split it into three list boxes with expression wild match. The problem I am not able to select elements in all three columns at same time.

Re: Need Help To Have one Blank Field but not Selectable

Anonymous — Thu, 16 Jul 2015 19:42:43 GMT

Hi,

The LF1 and LF2 need to be in the center?

If not you can sort by text ascending,

Re: Need Help To Have one Blank Field but not Selectable

dionverbeke — Thu, 16 Jul 2015 20:19:25 GMT

you can use the <expression> to limit your selection and use 3 listboxes.

You get there in the general tab, field subtab then scroll down all fields until you see

<expression>. Add your set analysis there and it will simulate what you want.

Kr,

Dion

Re: Need Help To Have one Blank Field but not Selectable

ramoncova06 — Thu, 16 Jul 2015 20:48:35 GMT

this would be tricky, but since it seems as you do not want to have search enabled for the listbox, you could try creating three different listboxes and then putting them inside of a container, this way you could control whatever is inside each box and have them always aligned

Re: Need Help To Have one Blank Field but not Selectable

Qrishna — Thu, 16 Jul 2015 21:03:59 GMT

You have make use of alternate states.

See attached .

Re: Need Help To Have one Blank Field but not Selectable

phaneendra_kunc — Thu, 16 Jul 2015 21:39:23 GMT

Wild match wont work here. I would suggest to use "On Any select Trigger" & "3 dummy fields".

See attached for you reference.

Re: Need Help To Have one Blank Field but not Selectable

Fri, 17 Jul 2015 06:46:39 GMT

yes LF1 And LF2 has to be in middle

Re: Need Help To Have one Blank Field but not Selectable

Fri, 17 Jul 2015 08:38:57 GMT

i have tried with spiting it into three different table but then selection is not working

and then tried to connect the three table to master table then three different selection is not possible.

Re: Need Help To Have one Blank Field but not Selectable

Fri, 17 Jul 2015 08:40:23 GMT

please send the attachment again as its seems to be incomplete. Thank you.

Re: Need Help To Have one Blank Field but not Selectable

Fri, 17 Jul 2015 08:42:41 GMT

yes i have tried with that solution but then i can not select from three diff list boxes as they are fro same table.

Re: Need Help To Have one Blank Field but not Selectable

Qrishna — Fri, 17 Jul 2015 14:09:36 GMT

See attached.

Re: Need Help To Have one Blank Field but not Selectable

phaneendra_kunc — Fri, 17 Jul 2015 16:47:14 GMT

Did you saw the example i shared? It involves in creating a "On Any Select Trigger"

Document Properties --> Triggers --> On any Select --> Action --> Select in field