topic GetFieldSelections in QlikView

GetFieldSelections

Tue, 20 Oct 2015 13:03:32 GMT

I Have a listbox with entry's

Cars

Porsche

Volkswagen

Opel

Then i have a table with in the Windowname:

=GetFieldSelections(CARS,', ')

When i select all Cars, the Windowname is called "ALL".

When i select only Porsche and Opel, the window name is called NOT Volkswagen.

I want the window name with the entries i selected!

Instead of all Porsche, Volkswagen, Opel

Instead of NOT Volkswagen Porsche, Opel

sunny_talwar — Tue, 20 Oct 2015 13:04:43 GMT

Try this:

=GetFieldSelections(CARS,', ', 9999999)

rubenmarin — Tue, 20 Oct 2015 13:11:58 GMT

Or:

If(GetSelectedCount(CARS), Concat(Distinct CARS, ', '))