Assign multiple values to variable in chart

[rathorep]

Hello All,

I am creating a new variable in chart directly and want to assign multiple values like 

V_Username= 'cat','Bat','dog','tat'

how i can do this. kindly help!

[eds_fb17]

Hello you can use function ValueList:
v_Username=ValueList('cat','Bat','dog','tat')

[Ksrinivasan]

hi,

instead of variables you can try with set

Sum({$<Category={'CAT','BAT','DOG','TAT'}>}[Delivery Qty])

Regards,

ksrinivasan

[Ksrinivasan]

hi,

1. you can Set in before script starting below:

Set vDefaultCat = 'cat','Bat','dog','tat';

2. Use this defaultcat at chat expression like:

Sum({$<aaaaa={$(vDefaultCat )}>}ddddd)

result will be from Default category list.

Ksrinivasan.