topic Re: Concat for only possible value in QlikView

Concat for only possible value

nboccassini — Fri, 26 Jan 2018 10:06:47 GMT

Hi,

I have 2 fields not connected cointain same data (B is a field of a large table )

A
1
2

I need a concat function to show values from A that are in possible value in B.

For ex. I select y and z in field C, the possible values of B are 2 and 3 --> The concat function will be retrieve 2

Thanks

Gabriele

pradosh_thakur — Fri, 26 Jan 2018 10:47:20 GMT

=concat({<A=P(B)>}A,',')

nboccassini — Fri, 26 Jan 2018 11:19:56 GMT

It doesn't works if a make a seleciton on A.

I've tried this and now works:

=Concat({$*$<A=p({<B=>}B)>}Distinct A,'"|"')

pradosh_thakur — Fri, 26 Jan 2018 12:01:53 GMT

great!! I thought you only want selection in B which is the only thing you mentioned in the question. Cheers.. :):)

evandroaps — Fri, 09 Mar 2018 12:40:16 GMT

perfect! thanks