3 Replies Latest reply: Feb 21, 2013 6:57 AM by Jagan Vijayakumar

# function equal to inline

Hi all,

I have the following data

 Date A B C 1 1 16 31 2 2 17 32 3 3 18 33 4 4 19 34 5 5 20 35 6 6 21 36 7 7 22 37 8 8 23 38 9 9 24 39 10 10 25 40 11 11 26 41 12 12 27 42 13 13 28 43 14 14 29 44 15 15 30 45

I want to create a chart like the one shown below

I used an Inline function to create the column FY in the chart.

* INLINE [
F1
Rev
Vol
eVol
]

;

expression used in column name 1 in the chart was

.

IF(F1='Rev',Sum({< Date={1}>} A),

IF(F1='Vol',Sum({< Date={1}>} B),

IF(F1='eVol',Sum({< Date={1}>}C)

)))

I want to know the equivalent function for the inline function at the ui side inorder to create a dummy values for a column that can be used in charts.

I have also attached the file.

• ###### Re: function equal to inline

I want to know the equivalent function for the inline function at the ui side inorder to create a dummy values for a row at Dimension side that can be used in charts.

• ###### Re: function equal to inline

The valuelist function is what you're looking for I think. You can create a calculated dimension with dummy values using valuelist: valuelist('dummy1','dummy2','dummy3'). You'll have to use it in expressions too:

if(valuelist('dummy1','dummy2','dummy3')='dummy1', expr1,

if(valuelist('dummy1','dummy2','dummy3')='dummy2', expr2,

if(valuelist('dummy1','dummy2','dummy3')='dummy3', expr3)))

• ###### Re: function equal to inline

Thanks a lot for the answer.

Just FYI... It can also be done like this.