Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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