Get all field values

[#1]

Hi,

I need to concatenate all field values inside a straight table, disregarding the selections made in this field.

Example:

Category     ProductNr

-------------     ---------------

A               1

A               2

B               1

B               4

C               1

C               5

C               6

D               7

D               8

A selection is made in field ProductNr, Value 1.

The straight table with dimension Category and concatenation over ProductNr. displays:

A               1

B               1

C               1

But what I need is every value given for the selected ProductNr. and the associated Category:

A               1,2

B               1,4

C               1,5,6

Are there any possibilities via set analysis? I have tried some, but nothing worked...

Thanks in advance!

[#2]

You can use the expression concat( {1} distinct ProductNr ', ') in combination with a straigth or pivot table (chart object)

[sudeepkm]

Please take a look at the example attached.

[Greg_Williams]

Will this work for you?

-Greg

[#5]

Hi,

thank you all for your replies!

The challenge for me is to show only the values of Category associated with the selection in ProductNr., so when making the selection ProductNr "1", Category D should not be shown inside the straight table...

Any further hints?

[tresesco · Accepted solution]

Expression: =concat( {1<Category=p({<ProductNr=p(ProductNr)>}Category)>} distinct ProductNr ,', ')

See attachment

[anbu1984]

Try this

[#8]

Thank you - this is it 🙂

[#9]

Would work, but would require additional effort inside the datamodel - thank you anyway!