topic GetFieldSelections more than one value in QlikView

GetFieldSelections more than one value

Thu, 15 May 2014 15:34:37 GMT

i can't figure out the syntax for using more than one value with the GetFieldSelections function

GetFieldSelections(SECTOR)='CROSSOVER' AND GetFieldSelections(SECTOR)='CROSSOVER UPFRONTS'

i tried this but it doesn't work

any ideas?

Re: GetFieldSelections more than one value

MK_QSL — Thu, 15 May 2014 15:44:58 GMT

TRY

=IF(GetFieldSelections(SECTOR)='CROSSOVER,CROSSOVER UPFRONTS',

Condition for True,

Condition for False)

Re: GetFieldSelections more than one value

Thu, 15 May 2014 15:52:28 GMT

Try:

if(SubStringCount(GetFieldSelections(SECTOR,', ',5000),'CROSSOVER')>0 or SubStringCount(GetFieldSelections(SECTOR,', ',5000),'CROSSOVER UPFRONTS')>0,1,0)

With 5000 as your max values (change as needed).