topic How to avoid ALL / NOT when multiple fields are selected ? in QlikView

How to avoid ALL / NOT when multiple fields are selected ?

arasaraja_cts — Thu, 27 Oct 2016 10:55:43 GMT

In the attached image ,

=Concat(Alpha,'|') give all the selected alphabets separated by delimiter, whereas

this =Concat(GetFieldSelections(Alpha),'|') give different result, can I avoid this ALL & NOT behaviour.

sunny_talwar — Thu, 27 Oct 2016 16:06:59 GMT

May be this:

=Concat(DISTINCT Alpha,'|')

or this:

GetFieldSelections(Alpha, '|', 10000000)

Make sure that 1000000 is greater than distinct possible values within the field Alpha

arasaraja_cts — Fri, 28 Oct 2016 09:08:55 GMT

Thank you Sunny , the second one worked for me.

Thanks

Raja