topic Re: Multiple select box in QlikView

Multiple select box

Wed, 23 Apr 2014 16:20:22 GMT

Hi;

How I can make a multiple select box from this LOAD:

sites:

LOAD

if(WildMatch5(NAME, '*NAME1*'), 'Brand1') as [Brand1],

if(WildMatch5(NAME, '*NAME2*'), 'Brand2') as [Brand2],

if(WildMatch5(NAME, '*NAME3*'), 'Brand3') as [Brand3],

if(WildMatch5(NAME, '*NAME4*'), 'Brand4') as [Brand4],

if(WildMatch5(NAME, '*NAME4*'), 'Brand5') as [Brand5],

if(WildMatch5(NAME, '*NAME5*'), 'Brand6') as [Brand6]

FROM

C:\sites.qvd(qvd)

MK_QSL — Wed, 23 Apr 2014 16:33:02 GMT

LOAD

Pick(WildMatch(NAME,'*NAME1*','*NAME2*','*NAME3*','*NAME4*','*NAME5*'), [Brand1],[Brand2],[Brand3],[Brand4],[Brand5]) as FieldName

From

C:\sites.qvd(qvd);

UPDATE : I have updated Pick instead of IF

Wed, 23 Apr 2014 16:57:18 GMT

Manish Kachhia
How I can solve this issue?

Error in expression:

If takes 2-3 parameters

sites:

LOAD SITE_ID,

NAME,

IF(WildMatch(NAME,'*NAME1*','*NAME2*','*NAME3*','*NAME4*','*NAME5*'), [Brand1],[Brand2],[Brand3],[Brand4],[Brand5]) as FieldName

MK_QSL — Wed, 23 Apr 2014 16:58:06 GMT

I have updated....

Use Pick Instead of If

PICK(WildMatch(NAME,'*NAME1*','*NAME2*','*NAME3*','*NAME4*','*NAME5*'), [Brand1],[Brand2],[Brand3],[Brand4],[Brand5]) as FieldName

Wed, 23 Apr 2014 17:05:29 GMT

Perfect Manish Kachhia, thank for your help...

This is the final sentence:

Pick(WildMatch(NAME,'*NAME1*','*NAME2*','*NAME3*','*NAME4*','*NAME5*'), 'Brand1','Brand2','Brand3','Brand4','Brand5') as FieldName