topic 2 LIKEs in a function and a get field expression in QlikView

2 LIKEs in a function and a get field expression

tinkerz1 — Tue, 16 Jun 2015 08:29:52 GMT

Hi,

Where am i going wrong? I want to set up an expression to capture fields selection in ABC, I know using a LIKE the OHL and RED are unique, but I cant see how to get the LIKE function working

Sum({$<[ABC]=({$<[{getfieldselections([ABC]) LIKE '*OHL*,*RED*'}>]data)

plus how do I paste code, the insert>plain does not seem to be working???

Is there a tutorial?

Thanks,

Neil.

Re: 2 LIKEs in a function and a get field expression

PrashantSangle — Tue, 16 Jun 2015 08:44:27 GMT

Hi,

try this

Sum(if(wildmatch(getfieldselections([ABC]),'*OHL*,*RED*'),data))

Regards

Re: 2 LIKEs in a function and a get field expression

maxgro — Tue, 16 Jun 2015 08:46:03 GMT

try

Sum({$ <[ABC]={"*OHL*", "*RED*"}>} data)

Re: 2 LIKEs in a function and a get field expression

tinkerz1 — Tue, 16 Jun 2015 09:27:02 GMT

Hi,

When I call the field with the full name this works

sum({$<[ABC]={[Red Threshold (OHL)]}>}Data)

but not with the Like function

Sum({$ <[ABC]={"*OHL*", "*Red*"}>} data)

Any ideas

Neil

Re: 2 LIKEs in a function and a get field expression

maxgro — Tue, 16 Jun 2015 11:18:41 GMT

I understood you want to sum data when ABC like OHL or Red

data and ABC are fields

OHL Red values of ABC field

Re: 2 LIKEs in a function and a get field expression

awhitfield — Tue, 16 Jun 2015 11:41:55 GMT

Hi Neil,

see the attached simple example, =Sum({$ <[ABC]={ "*ohl*","*red*"}>} data)
works fine in this case.

HTH - Regards,

Andy

Re: 2 LIKEs in a function and a get field expression

tinkerz1 — Tue, 16 Jun 2015 11:54:32 GMT

What I would like is to sum when OHL and RED in the same filed.

The above statement will sum all reds regardless of OHL in the field.

Re: 2 LIKEs in a function and a get field expression

petter — Tue, 16 Jun 2015 12:01:43 GMT

Yes - the above statement is an OR not an AND.

If you need an AND logic you will have to use intersection between record sets and not the element sets.

Something like this might work for you:

=Sum( { $<[ABC]={"*ohl*"}> * $<[ABC]={"*red*"}> } data )

Re: 2 LIKEs in a function and a get field expression

maxgro — Tue, 16 Jun 2015 12:02:06 GMT

try with intersection

sum( {$ <ABC={"*RED*"}*{"*OHL*"}>} data)

Re: 2 LIKEs in a function and a get field expression

awhitfield — Tue, 16 Jun 2015 12:03:14 GMT

Gotcha,

you mean =Sum({$ <[ABC]={ "*RED*OHL*"}>} data)

HTH Andy

Re: 2 LIKEs in a function and a get field expression

tinkerz1 — Tue, 16 Jun 2015 12:13:06 GMT

Thanks, I am sure i tried that, but it works.

Thanks,

Neil.