How to add new Value in existing field in Qlik sense?

[ABP2021]

Hello friends,

Can anybody tell me how to add new value to existing field.

Ex- Suppose i have field like Division and i want to add new value in that Division as ALL where ALL is selection of all the divisions i.e. ALL=A,B,C,D

Division

A

B

C

D

ALL

[GaryGiles]

One approach that you could try:

If you start with a table containing:

Division

A

B

C

D

Add the following to your load script:

DivisionGrp:

Load Division as DivisionGrp,

          Division

Resident Division;

Load 'All' as DivisionGrp,

         Division

Resident Division;

Then use DivisionGrp in your filter pane.  When you select "All", it will include all of the Divisions.