topic Re: Show multiple values in one cell (like current selections object) in QlikView

Show multiple values in one cell (like current selections object)

pepe2209 — Thu, 06 Feb 2014 10:29:58 GMT

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

Re: Show multiple values in one cell (like current selections object)

martinpohl — Thu, 06 Feb 2014 10:35:25 GMT

see attached

hope that's it

Regards

Re: Show multiple values in one cell (like current selections object)

dirk_konings — Thu, 06 Feb 2014 10:49:05 GMT

you could use the Concat function

Dirk

Re: Show multiple values in one cell (like current selections object)

Thu, 06 Feb 2014 10:51:30 GMT

try this

=CONCAT({<Value1=>} DISTINCT Value1,',')

similarly

=CONCAT({<Value=>} DISTINCT Value,',')

Re: Show multiple values in one cell (like current selections object)

Thu, 06 Feb 2014 10:53:49 GMT

concat(Distinct value,',')

Re: Show multiple values in one cell (like current selections object)

jagan — Thu, 06 Feb 2014 10:57:22 GMT

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.

Re: Show multiple values in one cell (like current selections object)

er_mohit — Thu, 06 Feb 2014 10:59:21 GMT

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,

Resident T1

Group by ID;

DROP Table T1;

Reload it

hope it helps

Re: Show multiple values in one cell (like current selections object)

ashwanin — Thu, 06 Feb 2014 11:07:25 GMT

Concat (DISTINCT Value1 ,',') in expression 1

and Concat (DISTINCT Value ,',') in Expression 2