topic Re: Dynamic selection in QlikView

Dynamic selection

Thu, 18 Feb 2016 12:49:47 GMT

I have 11 variables of which one variable (say Fieldnames) contains the variable names of the other 10 variables. Is there any way I can select a field by selecting the corresponding value from the variable 'Fieldnames' ?

Lets say if i have to create a dynamic list box which would show the values in the field which I select from the variable "Fieldnames"??

Re: Dynamic selection

Oleg_Troyansky — Thu, 18 Feb 2016 22:22:55 GMT

I think you are confusing Variables and Fields. TO clarify, Variable can only hold a single value at a time, while a Field (stored in a Table) can hold multiple values at a time.

If you wanted to have a dynamic List Box that shows a field of your choice, you don't have to create another field for that. It's enough to create a Dimension Group (Document Properties --> Groups) and use the Group in the List Box. The users will be able to select what field to show.

cheers,

Oleg Troyansky

Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Milan, Italy and Austin, TX!

Re: Dynamic selection

Fri, 19 Feb 2016 11:47:17 GMT

Thanks for your response.

The issue is like this,

there are 4 variables lets say A,B,C,D

with the following values

A B C D

1 2 3 A

1 2 5 B

2 3 5 C

2 3 5

2 4 5

I need to summarize in a table the values of A,B,C dynamically viz if a user selects 'A' from

the list box(of variable D), the table should show summarized values of A and similarly for B & C.

I know the variable 'D' has values which are names of other variables. But can we by some way make

such a dynamic table