topic Re: Text box - if else in QlikView

Text box - if else

Mon, 14 Oct 2013 13:06:04 GMT

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 — Mon, 14 Oct 2013 13:10:50 GMT

Hi Chanel,

Try : If(getSelectedCount(Region)>0,

Concat(Region, ' - '),

'blablabla'

)

Regards,

Aurélien

Mon, 14 Oct 2013 13:17:48 GMT

use Qlikview function "getfieldselections"

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

extrapolate

good luck.

Mon, 14 Oct 2013 13:18:06 GMT

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

Mon, 14 Oct 2013 13:27:19 GMT

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

Mon, 14 Oct 2013 13:36:24 GMT

try this:

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