topic Error in my Set Analysis syntax, in QlikView

Error in my Set Analysis syntax,

Thu, 07 Nov 2013 09:03:07 GMT

hi i am experiencing problems with the following

count({$<(inLeveransDatum -Lev_Leveranstid)> Villkor_inlev>} %InLevNr)

it seems to be a syntax error.

what i am trying to do is find the value between two dates (inLeveransDatum - Lev_Leveranstid and then do a check if they are greater than the actual condition so example 5 days 1 day or 3 days and then count the amount of i

Re: Error in my Set Analysis syntax,

tresB — Thu, 07 Nov 2013 09:14:32 GMT

Try like:

=Count({<Lev_Leveranstid={"=(inLeveransDatum-Lev_Leveranstid)>Villkor_inlev"}>} DISTINCT Lev_Leveranstid)

Note: DISTINCT you might or might not need.

Re: Error in my Set Analysis syntax,

salto — Thu, 07 Nov 2013 09:17:45 GMT

Hi,

I am afraid that unfortunately you cannot set that calculation directly in the set analysis. You need to save it before (in a field in the script) and use the field in the set analysis expression:

inLeveransDatum -Lev_Leveranstid as NewField;

count({$<NewField= {">= Villkor_inlev"}>} %InLevNr)

Hope this helps.

Re: Error in my Set Analysis syntax,

jagan — Thu, 07 Nov 2013 09:18:27 GMT

Hi,

Try this expression

=Sum(Aggr(If((inLeveransDatum - Lev_Leveranstid)> Villkor_inlev, 1, 0), [%InLevNr]))

Regards,

Jagan.

Re: Error in my Set Analysis syntax,

Vegar — Thu, 07 Nov 2013 09:22:57 GMT

Are you sure you want to do SET? there are alternative ways of solving it. I attach a solution with sum(aggr())

-sum(aggr( ($(vL.Delay)<=(inLeveransDatum-Lev_Leveranstid)),%InLevNr))

-sum(aggr( only(Villkor_inlev)<=(inLeveransDatum-Lev_Leveranstid)),%InLevNr))

Edit: Missed the Villkor_inlev.