topic Re: dinamically populate list box in QlikView

dinamically populate list box

Mon, 10 Sep 2012 18:20:46 GMT

Hopfully very simple question:

I have a table Metrics with 2 columns:

ID, Value

1, One

2, Two

3, Three

....

And I have a variable "Flag" with two possible values: "Choice 1" and "Choice 2".

How do I create a listbox that will be populated with values "One" and "Two" if variable "Flag" = 'Choice 1', and only value "Three" if variable "Flag"='Choice 2'?

Thank you!

Re: dinamically populate list box

Tue, 11 Sep 2012 07:36:45 GMT

why don't you simply join this two tables?

LOAD * INLINE [

ID, Value

1, One

2, Two

3, Three

];

left join LOAD * INLINE [

Value, Flag

One, Choice1

Two, Choice1

Three, Choice2

];

Re: dinamically populate list box

Tue, 11 Sep 2012 13:12:20 GMT

That kinda works, but my listbox (where I display Value) shows all values. When I pick my Flag="Choice1", value "Three" simply gets greyed out.

What I need is ONLY display values in the list box that relate to "Choice1" if "Choice1" is selected in the variable.

In reverse, I need to display only value "Three" if "Choice2" is selected in the Flag.

Thank you!

Re: dinamically populate list box

Tue, 11 Sep 2012 13:19:12 GMT

so change that listbox to tablebox with Value field only