how to set a value list as a dimensional in script

[Anonymous]

Hi friends,

Alreday  I have used the calculated dimensional  in a bar chart by using value list method

=ValueList('Occupied','Partially Occupied','Available')

and expression is  if(ValueList('Occupied','Partially Occupied','Available')='Occupied',vOccupied,if(ValueList('Occupied','Partially Occupied','Available')='Partially Occupied',vPartiallyOccupied,if(ValueList('Occupied','Partially Occupied','Available')='Available',vAvailable)))

But  i need to bring the calculated dimensional value list method  =ValueList('Occupied','Partially Occupied','Available') in script wise as a dimensional

How can I bring the value list in script wise to set as dimensional

Regards,

Vijay.M

[avinashelite]

Simple create a inline table

LOAD *

[

Dim1

Occupied

Partially Occupied

Available

];

[Anonymous]

Why cant we use an inline table like

Load Status, <Your expression> as 'value' inline

[

Status

Occupied

Partially Occupied

Available

];

[Anil_Babu_Samineni]

Or it is easy to get

LOAD *

[

Parameters, SNO

Occupied, 1

Partially Occupied, 2

Available, 3

];

And then front-end should be

Dim as Parameters

and expression should this

if(sNO=1,vOccupied,if(SNO=2,vPartiallyOccupied,if(SNO=3,vAvailable)))