Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Expression: =concat( {1<Category=p({<ProductNr=p(ProductNr)>}Category)>} distinct ProductNr ,', ')
See attachment
You can use the expression concat( {1} distinct ProductNr ', ') in combination with a straigth or pivot table (chart object)
Please take a look at the example attached.
Will this work for you?
-Greg
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?
Expression: =concat( {1<Category=p({<ProductNr=p(ProductNr)>}Category)>} distinct ProductNr ,', ')
See attachment
Try this
Thank you - this is it 🙂
Would work, but would require additional effort inside the datamodel - thank you anyway!