list of columns in variable for use in ValueList - better method?

[david_kesselhei]

Hi,

I need to build a ValueList containing 11 measures because I want to put those measures in the same chart. That means I'll need to build a nested If() for all 11 measures and I would like that to be as easy to read as possible.

What I have so far:

I was able to define a a variable which does what I want it to do:

=CHR(39) & 'Impressions' & CHR(39) & CHR(44) & CHR(39) & 'Impressions' & CHR(32) & 'Unique' & CHR(39) 

Which evaluates to 

'Impressions','Impressions Unique'

I can now use this variable (let's call it vImpressions) in a ValueList:

ValueList(vImpressions)

While it does work it seems a bit too much work to build the list that way. 

Question:

Is there an easier way to build a variable containing a list that can be passed to a function?

Thank you for your help.

[Blashyrkh]

Hi Marcus,

I have done a query Changing Object Dimensions / expressions options with this option. Wouldn't that degrade Qlik pre-calc performance? As Measure List is not related to data Mart? 

Thanks in advance