Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You didn't create a variable as I suggested. you also need to alter the expression to reference the ValueList().
See attached.
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
Note: 'amp' was added by my phone when posting this! Ignore them!
thanks for your help but that doesn't work...
other idea ?
thanks.
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
Jason, your soluce are true in an object text but not in a dimension
there are not a solution more simple ?
kind : DimCountry + 'Miami'
I have used this successfully in a dimension. If you can post a sample of your app I can take a look.
for example :
Thanks.
You didn't create a variable as I suggested. you also need to alter the expression to reference the ValueList().
See attached.
Yes i try this but I don't arrive to write this in the script
Thanks a lot you are my rescuer