Pull 1st, 2nd Dimension Value to fill Variable and use in Set Analysis

[chriys1337]

Hi Community,

is there a way to put first, second, third dimension value etc. in a Variable and use this Variable than in Set Analysis

to get "just" the performance per each dimension value in a gauge?

Thanks a lot,

chriys 

[kaushiknsolanki]

Hi,

Can you give an example of what exactly you want to achieve.

Regards,

Kaushik Solanki

[chriys1337]

Hi Kaushik,

yes sure:

Dim:
Load * Inline
[
Dimension,
Canada,
Germany,
Austria,
England,
USA
];

I am having a dimension with Country Names and I would like to use these Countrys in Set Analysis (but without typing them manually):

My idea was to fill e.g. Variable1 to Variable5 with the Values from this Dimension. It must still react on my selection, e.g. just three from the five countrys are selected, than I just want to fill Variable1 to Variable3.

Is this possible?

Best Regards,

chriys

[kaushiknsolanki]

Hi,

Its not possible to dynamically create variable and then assign value.

But you can use single variable to hold all the values of your field using the concat() function.

And then use that single variable in your set analysis.

Your  variable(Variable1) expression will be.

=Concat(Country,'","')

and your set expression will be.

Sum({<Country = {"$(Variable1)"}>}Sales)

Regards,

Kaushik Solanki

[chriys1337]

Thank you for sharing, I have used concat and the subfield function to get 1st,2nd. etc value.