Add "select all" option to dynamic value in Variable input

[Michielcool]

Hi guys,

I have a variable input filter that shows all the different incident types. Based on this, the user can filter on incident type. To achieve this, I used the following code: = Concat(Distinct[Incident_type], '|'). This works fine.

Now I also want to give the user the option to select all the incident types. To achieve this, I tried the following code: = Concat(Distinct[Incident_type], '|') & '|*~Select all'. 

Unfortunately, the "select all" option returns zero values, so it seems that the asterisk is not working as I expect it to be.

Does someone know the right solution?

Thanks in advance!