Multiple line in a combo chart from one variable

[employe4_2]

HI,

I'm trying to get a combo chart with 2 to 4 measures.

Its easy if i want to do it manually, but i would like to be able to choose the measure you want from a list.

So i use one field selection extension, and what i select in this part is saved into a variable define = GtefieldSelctions(measures)

it work: i defined a master items measure wich take value from my variable andso it display into my combo chart.

But when i select a second one, my variable stock 2 fields seperated with a coma into my master measure item.

So either i creat multiple master measure and multiple field selection extension to be 100% it work,

or trying something with condition, but that's seems pretty hard work/impossible.
Am i getting into something not worth the time ?

thx

[Yoshidaqlik · Accepted solution]

IF(vVar_1=1,
  Valuelist('dim1_1','dim1_2'),
  Valuelist('dim2_1','dim2_2','dim2_3','dim2_4')
)

Hi

Are the dimensions fixed? if it's always 2 and 4 I think you can solve with valuelist

in dimension for example would match the variable that created

IF(vVar_1=1,
  Valuelist('dim1_1','dim1_2'),
  Valuelist('dim2_1','dim2_2','dim2_3','dim2_4')
)

and the measures would be

IF(
	IF(vVar_1=1,
	  Valuelist('dim1_1','dim1_2'),
	  Valuelist('dim2_1','dim2_2','dim2_3','dim2_4')
	)='dim1_1',
	Sum('dim1_1'),
IF(
	IF(vVar_1=1,
	  Valuelist('dim1_1','dim1_2'),
	  Valuelist('dim2_1','dim2_2','dim2_3','dim2_4')
	)='dim1_2',
	Sum('dim1_2'),
IF(
	IF(vVar_1=1,
	  Valuelist('dim1_1','dim1_2'),
	  Valuelist('dim2_1','dim2_2','dim2_3','dim2_4')
	)='dim2_1',
	Sum('dim2_1'),
IF(
	IF(vVar_1=1,
	  Valuelist('dim1_1','dim1_2'),
	  Valuelist('dim2_1','dim2_2','dim2_3','dim2_4')
	)='dim2_2',
	Sum('dim2_2'),
IF(
	IF(vVar_1=1,
	  Valuelist('dim1_1','dim1_2'),
	  Valuelist('dim2_1','dim2_2','dim2_3','dim2_4')
	)='dim2_3',
	Sum('dim2_3'),
IF(
	IF(vVar_1=1,
	  Valuelist('dim1_1','dim1_2'),
	  Valuelist('dim2_1','dim2_2','dim2_3','dim2_4')
	)='dim2_4',
	Sum('dim2_4')
))))))

[employe4_2]

Sadly, for that part  it's relative to the user, so no it isn't fixed.

But anyway, i'll limit the user to a fix number of dimension,

this will be easier for process,

Thanks anyway !