Dynamic ValueList

johnso2080 — Thu, 31 Jan 2013 13:17:04 GMT

Hello,

I want to create a variable that provides a string (based on conditions) to be used as an argument for a ValueList() function.

Basically something like

VariableA:

=IF(condition=true,

" 'Value1','Value2','Value3' "

" 'Value4','Value5','Value6' "

)

Expression:

=IF(ValueList(VariableA) = 'Value1'

Result 1

If ValueList(VariableA) = 'Value 4'

Result 2

)

Can anyone explain how to go about this? I've tried a number of different ways but it doesn't seem to be working?

Thanks

topic Dynamic ValueList in QlikView