Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I am trying to make my own 'current selections' overview with standard table graph (I don't want to use the standard current selections object)
please look at example
Data:
ID | Value1 | Value |
---|---|---|
123 | 3 | A |
123 | 3 | B |
123 | 4 | C |
123 | 4 | D |
And I want this 'current selections' table:
ID('s) | Value1('s) | Value2('s) |
---|---|---|
123 | 3,4 | A, B, C, D |
It's easy when after selection only one value remains but is it also possible to show multiple values separated with comma?
your help would be much appreciated.
Regards Peter
see attached
hope that's it
Regards
you could use the Concat function
Dirk
try this
=CONCAT({<Value1=>} DISTINCT Value1,',')
similarly
=CONCAT({<Value=>} DISTINCT Value,',')
concat(Distinct value,',')
Hi,
Try like this
In Straight table take ID as Dimension
Use Concat(DISTINCT Value1) as expression1
and
Use Concat(DISTINCT Value2) as expression2
Hope this helps you.
Regards,
Jagan.
Dim ID
Try in expression side
concat( distinct Value1,', ') //for Value1
add 2nd expression
concat( distinct Value2,', ') //for Value2
or you can try this on script also copy and paste this code
T1:
LOAD * Inline [
ID, Value1, Value2
123, 3, A
123, 3, B
123, 4, C
123, 4, D
];
LOAD Concat(DISTINCT Value1,',') as New1,
Concat(DISTINCT Value2,',') as New2,
ID
Resident T1
Group by ID;
DROP Table T1;
Reload it
hope it helps
Concat (DISTINCT Value1 ,',') in expression 1
and Concat (DISTINCT Value ,',') in Expression 2