Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Breezy
Creator
Creator

GetFieldSelection, different name if all are selected?

Hi,

For my example below, I selected all options (Region 1, Region 2, etc.). My KPI lists them all. However, IF ALL of the options are selected I would like this to change to saying "National" (instead of Region 1, Region 2..)

I was using:

GetFieldSelections ([Region],';',10)

 

Qlik_Region_Dropdown.JPG

Labels (1)
1 Solution

Accepted Solutions
rdelagarde
Contributor II
Contributor II

Hi,

GetFieldSelections() returns 'ALL' when all fields are selected.

You can try:

If(GetFieldSelections([Region],';') = 'ALL', 
   'National', 
   GetFieldSelections([Region],';')
)

View solution in original post

2 Replies
rdelagarde
Contributor II
Contributor II

Hi,

GetFieldSelections() returns 'ALL' when all fields are selected.

You can try:

If(GetFieldSelections([Region],';') = 'ALL', 
   'National', 
   GetFieldSelections([Region],';')
)

View solution in original post

Breezy
Creator
Creator
Author

Thanks! Appreciated.