Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Partner
Partner

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

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.

Tags (3)
1 Solution

Accepted Solutions

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

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

View solution in original post

2 Replies

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

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

View solution in original post

Partner
Partner

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

Thank you Sunny , the second one worked for me.

Thanks

Raja