Passing parameters to set analysis expression called by FirstSortedValue function.
Hello community. I need help passing parameters to set analysis expression called by FirstSortedValue function. Here is my scenario:
I have an island table:
%Measure_Nbr
%Measure_Formula
1
Sum({<$1, $2>} DOLLARS)
2
Sum({<$1, $2>} UNITS)
3
Sum({<$1, $2>} DOLLARS)/Sum({<$1, $2>} UNITS)
%Measure_Formula has parameter ( $1), ($2) for different set analysis that I will pass as variables. For example:
saProductJuice = [Product] = {‘Juice’}
saCountryUSA = [Country] = {‘USA}
When I pass one of those variables as parameters, result should be different variations of measures and set analysis. Something like this :
Sum({<[Product] = {‘Juice’}>} DOLLARS)
or Sum({<[Product] = {‘Juice’}, [Country] = {‘USA}>} UNITS)
In my chart, I use following variable to call measure:
vExpression = FirstSortedValue({1} %Measure_Formula, %Measure_Nbr,$1) – Where $1 is another parameter specifying measure I want.
So here is a problem I need help with:
Result of $(vExpression(1)) returns Sum({<$1, $2>} DOLLARS)
But I can’t pass more parameters for my set analysis inside of expression. I need something like Sum({<[Product] = {‘Juice’}>} DOLLARS) when I execute FirstSortedValue.
