topic Re: Display Listbox based on $Field Selection Dynamically in QlikView

Display Listbox based on $Field Selection Dynamically

settu_periasamy — Fri, 02 Jan 2015 03:59:57 GMT

Hi Guys,

I need to display the listbox based on the $Field selection. The listbox should display with the order(like $FieldNo). see the below screen shot for reference.

ttached the sample file.

Re: Display Listbox based on $Field Selection Dynamically

Anonymous — Fri, 02 Jan 2015 04:18:47 GMT

Try adding a condition in the layout tab using GetFieldSelections().

Re: Display Listbox based on $Field Selection Dynamically

naveen_y19 — Fri, 02 Jan 2015 04:18:48 GMT

Right Click on properties for each List box, in the properties page goto Layout Tab --> Select Show Conditional and put the following condition in it "=if($Field='Ctype', True(), False())"

do the same thing for

From --> =if($Field='From ', True(), False())

Product --> =if($Field='Product ', True(), False())

Re: Display Listbox based on $Field Selection Dynamically

settu_periasamy — Fri, 02 Jan 2015 04:55:10 GMT

Hi Naveen,

Thanks. But i have more than 300 Fields. The user will select the Field, based on their need.

is any other way to do this?

Re: Display Listbox based on $Field Selection Dynamically

tresB — Fri, 02 Jan 2015 04:56:56 GMT

Dsiplay condition, like:

Max(If($Field='Ctype',1,0))=1

PFA

Re: Display Listbox based on $Field Selection Dynamically

settu_periasamy — Fri, 02 Jan 2015 05:13:10 GMT

Thanks Tressco. I have more than 300 fields. My attached was just for sample.

need to display the Listbox, anywhere in the $Field Selection.

Re: Display Listbox based on $Field Selection Dynamically

tresB — Fri, 02 Jan 2015 05:18:57 GMT

So you don't want to write this condition for all these 300 list boxes, right? I am afraid, that effort might not be bypassed.

Re: Display Listbox based on $Field Selection Dynamically

settu_periasamy — Fri, 02 Jan 2015 05:47:35 GMT

I can use the expression =$(=$Field) in the Listbox Expression. But this is working for only one selection.

If i select more than one Field, the listbox should display nearby Previous Listbox. find the attached please

Re: Display Listbox based on $Field Selection Dynamically

jagan — Fri, 02 Jan 2015 05:53:45 GMT

Hi,

Use this expression for the list boxes

=$(=SubField(GetFieldSelections($Field, '|'), '|', 1))

=$(=SubField(GetFieldSelections($Field, '|'), '|', 2))

=$(=SubField(GetFieldSelections($Field, '|'), '|', 3))

Hope this helps you.

Regards,

Jagan.

Re: Display Listbox based on $Field Selection Dynamically

tresB — Fri, 02 Jan 2015 05:57:57 GMT

The way you trying is fine. And that would only work for one selection, because you are defining expression of one listbox, so based on your selection you can get a different field value in a list box but not many list boxes.

Re: Display Listbox based on $Field Selection Dynamically

settu_periasamy — Fri, 02 Jan 2015 06:01:58 GMT

Thank you Jagan.

Re: Display Listbox based on $Field Selection Dynamically

tresB — Fri, 02 Jan 2015 06:04:19 GMT

So, this way again you have to write 300 expressions for all 300 list boxes.

Re: Display Listbox based on $Field Selection Dynamically

settu_periasamy — Fri, 02 Jan 2015 06:09:07 GMT

No, Just I create 24 Listbox with the expression =$(=SubField(GetFieldSelections($Field, '|'), '|', 1)) to =$(=SubField(GetFieldSelections($Field, '|'), '|', 24)). The End user can select the ListBox based on their need(within 300 Fields.)