variabilisation of dimension!

RileyDylan — Mon, 20 Dec 2021 21:08:46 GMT

Hello, I have some dimensions : Product1, Product2, Product3, ...I'm using those dimensions in set analysis I have a filter to select the numero of the product (1, 2, 3 ...) Is it possible to set a variable to determine the dimension ? Equivalent to : if(getfieldselection(value) = 1, sum({} measure), if(getfieldselection(value) = 2, sum({} measure), if(getfieldselection(value) = 3, sum({} measure), )))) I would like something like : myvariable = 'Product'&getfieldselection(value) to do sum({} measure),

Re: variabilisation of dimension!

jyothish8807 — Mon, 04 Jan 2021 08:19:01 GMT

Hi RileyDylan ,

Your approach above seems to be correct 🙂

i would do like this:

Backend:

Create a inline table:

Load * Inline [

Value

];

Use "value" as a drop down filter and set as only one value selected.

Create 2 variable:

vDimension = 'Product'&Getfieldselections(value) //Assuming your all dimensions start with "Product" prefix

vMeasure = Sum({<$(vDimension)={'any value'}>}Measure) //use variable vMeasure in your charts

topic Re: variabilisation of dimension! in App Development

variabilisation of dimension!

Re: variabilisation of dimension!