Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
johnso2080
Contributor
Contributor

Dynamic ValueList

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

0 Replies