topic Passing variable to choose one value. in QlikView

Passing variable to choose one value.

Thu, 03 Apr 2014 18:46:24 GMT

Hello All,

I want to create a Input box with a variable with Listed value, such as A B C and when we select A field with that A should also change. For EG:-

NAME Data

A 1

B 2

C 3

So, when a user select A in that Input Box chart should show only A's data.

Any help will be appreciated.

Thanks.

Nicole-Smith — Thu, 03 Apr 2014 18:47:24 GMT

Why not just use a list box with field Name?

Thu, 03 Apr 2014 18:53:13 GMT

There are other values in field Name that I don't want user to select.

Nicole-Smith — Thu, 03 Apr 2014 18:54:28 GMT

You could use an expression in the list box to only get the values that you want:

aggr(only({1<Name={'A','B','C'}>}Name),Name)