topic Re: Display listbox based on the selections from a common list box holding field name in QlikView

Display listbox based on the selections from a common list box holding field name

Wed, 16 Oct 2013 10:50:13 GMT

Hi All,

Can anyone help me out with approach to get dynamic list box based on field selection.

Ex: I have a list box with all field names. Now once clicked on any of the field in the list box a new list box should be visible holding selected field values.

Regards,

Prajna

Re: Display listbox based on the selections from a common list box holding field name

rustyfishbones — Wed, 16 Oct 2013 10:54:17 GMT

Create a list box and dynamically show it based on the Field selection

Add this as a conditional option in Layout Tab

Count(DISTINCT FieldNames) = 1

the list box will only show if a selection is made in the FieldNames List Box

Re: Display listbox based on the selections from a common list box holding field name

Wed, 16 Oct 2013 11:21:59 GMT

Hi,

I have to create a list box and under layout I have to give Count(DISTINCT FieldNames) = 1 ????

Then what should be chosen for dimension and FieldNames referrred can be $(Field)??? or what exactly it signifies?

Re: Display listbox based on the selections from a common list box holding field name

israrkhan — Wed, 16 Oct 2013 11:29:23 GMT

hi,

create a list box and on properties Layout>> Show, check conditional and put condition

=Count(DISTINCT YourFiledName) >= 1 , it Mean this list will be visible only when you will select 1 or more fields in other list, you dont need any dimension ,or any other step, try this and let us know, its works or not..

Re: Display listbox based on the selections from a common list box holding field name

Wed, 16 Oct 2013 11:37:33 GMT

Hi,

Now the main list box has say 10 field names. On click of each field name I should get a list box holding data for that particular field.

So in the exp =Count(DISTINCT YourFiledName) >= 1

yourFiledName holds what name??

Regards,

Prajna

Re: Display listbox based on the selections from a common list box holding field name

israrkhan — Wed, 16 Oct 2013 11:46:52 GMT

the field name which you will select..

and You wrote " On click of each field name I should get a list box holding data for that particular field."

what type of data, or you mean the selected field name?

let me know in detail. your fields name. or if you can attach an example doc..

Re: Display listbox based on the selections from a common list box holding field name

Wed, 16 Oct 2013 11:53:40 GMT

for ex: I have field names likes this in a list box called list box1

list box1

Branch Name

Account Type

Now when I click on field Branch name.. A list box with Branch Name data should appear. As shown below

Branch Name

next on click of Account Type.. A list box with Account Type data should appear.

Re: Display listbox based on the selections from a common list box holding field name

Wed, 16 Oct 2013 12:04:25 GMT

Hi,

I would do:

1) Create a variable

vCurrentField: =$(Field) it is a formula

2) 1st list box:

Dimension: = $Field

3) 2nd ListBox:

The Expression: = $(=vCurrentField)

Fabrice

Re: Display listbox based on the selections from a common list box holding field name

tresB — Wed, 16 Oct 2013 12:20:59 GMT

May be like attached sample?

Re: Display listbox based on the selections from a common list box holding field name

Wed, 16 Oct 2013 13:37:22 GMT

hi..

I tried this em not getting any result

Regards,

Prajna

Re: Display listbox based on the selections from a common list box holding field name

Wed, 16 Oct 2013 13:45:51 GMT

Hi,

You have given data in script.. but I need to get from sql query. How to achieve this?

Regards,

Prajna