topic Re: How to make Conditional values in valuelist? in QlikView

How to make Conditional values in valuelist?

Wed, 06 Mar 2013 16:28:08 GMT

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 — Thu, 07 Mar 2013 06:52:04 GMT

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....

Thu, 07 Mar 2013 08:54:36 GMT

Hi,

I added my application as an attachment