How to make Conditional values in valuelist?

[#1]

Dear Qlikview users,

I created a straight table with a 'custom dimension' by the use of te Valuelist function.

See the example below:

The dimension definition is as follows:

=valuelist('TW1','TW2')

For the columns 'Alpha' 'TKP' and 'Interpolated (-10)', i use expressions. The Alpha expression is as follows:

if(valuelist('TW1','TW2')='TW1','#',' ')

&

if(valuelist('TW1','TW2')='TW2','#',' ')

I have a list selectionbox with a list of TW's (Time Windows)
See example below:

How can I make sure that the "TW1"-row in my straight table is only shown when "TW1" is selected in the selectionbox?

Also, the list selectionbox allows multiple selections.

[sibin_jacob · Accepted solution]

Use variables...

Create two variables

Variable1 and Variable2 .

Variable1= subfield(concat(Time_selection,'|'),'|',1)

Variable2= subfield(concat(Time_selection,'|'),'|',2)

Use dimension as valulist(Variable1,Variable2)

Please share your application....

[#3]

Hi,

I added my application as an attachment