Text box - if else

[#1]

Dear community,

I want to display the region name if the field in region is selected, if none of them is selected, it will show "blabla".

There are 7 items in the field, if 2 of them are selected, the text box will show 2 items.

However, expression below seems like not working:

Kindly help.

Thanks and best regards,

Chanel

[Aurelien_Martinez]

Hi Chanel,

Try : If(getSelectedCount(Region)>0,

         Concat(Region, ' - '),

         'blablabla'

        )

Regards,

Aurélien

[#3]

use Qlikview function "getfieldselections"

=if(GetFieldSelections(SUBSCRIBER_KEY_NUM)=27,'blabla','NO!')

extrapolate

good luck.

[#4]

Hi Aurélien,

Thanks for your fast response!

it is working well when nothing is selected:

but when i selected something from the field:

Example: Australia/NZ

Thanks and best regards,

Chanel

[#5 · Accepted solution]

Dear Aurélien,

It is working after i added "distinct". Thanks for your awesome idea!

=If(getSelectedCount(Region)>0,

         Concat(distinct Region, ' - '),

         'blabla'

        )

Thanks and best regards,

Chanel

[#6]

try this:

=if(isnull(GetFieldSelections(SUBSCRIBER_KEY_NUM)),'blabla',GetFieldSelections(SUBSCRIBER_KEY_NUM,'; ' , 10))