Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for
Did you mean:
Partner - Creator

## 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.

1 Solution

Accepted Solutions

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)))

talk is cheap, supply exceeds demand
3 Replies
Partner - Creator
Author

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.

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)))

talk is cheap, supply exceeds demand
Partner - Creator
Author

Thanks a lot for the answer.

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

Community Browser