topic Re: If Syntax in QlikView

If Syntax

Anonymous — Fri, 28 Mar 2014 14:07:44 GMT

Hello,

If I am trying to determine whether a SKU falls into an Event labeled by Flyer during a particular week, should I do this as an if statement or a set analysis?

I can determine whether or not the SKU is part of a flyer event with the following:

if([Event] like '*Flyer*','Yes')

However, how do I incorporate a particular week that is dynamic into that expression? I am specifically trying to find whether or not the SKU is part of a flyer event between max([PO Rec Date]) and max([PO Rec Date])+6

Thanks!

Re: If Syntax

alexandros17 — Fri, 28 Mar 2014 14:16:17 GMT

wildmatch([Event], $(myWeek))

where myWeek is a variable

Hope it helps

Re: If Syntax

Anonymous — Fri, 28 Mar 2014 14:40:05 GMT

I think that might work!. How would I define the variable to include my range be

>=max([PO Rec Date])<=max([PO Rec Date]+6

Re: If Syntax

alexandros17 — Fri, 28 Mar 2014 14:47:51 GMT

You need a range not a single value:

at this point, if you need that condition in an expression, you can do something like:

Sum({$ <Event={'>=max([PO Rec Date])<=max([PO Rec Date]+6'}>} myValue)

Re: If Syntax

MarcoWedel — Fri, 28 Mar 2014 17:52:39 GMT

Sum({$ <Event={"*Flyer*"}, week={'>=max([PO Rec Date])<=max([PO Rec Date]+6'}>} myValue)