Add a value on a dimension in a bar chart.

[#1]

Hi,

I want to add a value on my dimension in a bar chart, not in the script.

For exemple : I want add 1 country on my dimension so i try :

=ValueList('Miami',DimCountry)

but that doesn,'t work.

How have to I make ?

Thanks.

[Jason_Michaelides]

Hi,

ValueList() is very picky about what it receives. You need to create a variable, vCountry and set it to (with the equals sign):

='ValueList(' & Chr(39) & 'Miami,' & Chr(39) & Concat(Distinct DimCountry,Chr(39) & ',' & Chr(39)) & ',)'

Then, in the dimension use =$(vCountry)

Hope this helps,

Jason

[Jason_Michaelides]

Note: 'amp' was added by my phone when posting this! Ignore them!

[#4]

thanks for your help but that doesn't work...

other idea ?

thanks.

[Jason_Michaelides]

I was on a train when I wrote that and got the syntax wrong!  Sorry...try:

='ValueList(' & Chr(39) & Concat(DISTINCT DimCountry,Chr(39)&Chr(44)&Chr(39)) & Chr(39) & ',' & Chr(39) & 'Miami' & Chr(39) & ')'

Jason

[#6]

Jason, your soluce are true in an object text but not in a dimension

there are not a solution more simple ?

kind : DimCountry + 'Miami'

[Jason_Michaelides]

I have used this successfully in a dimension.  If you can post a sample of your app I can take a look.

[#8]

for example :

Thanks.

[Jason_Michaelides · Accepted solution]

You didn't create a variable as I suggested.  you also need to alter the expression to reference the ValueList().

See attached.

[#10]

Yes i try this but I don't arrive to write this in the script

Thanks a lot you are my rescuer