topic Re: adding a second condition to expression in QlikView

adding a second condition to expression

Fri, 06 Jun 2014 00:02:24 GMT

Hi,

I've the following condition to calculate the the rolling avg.

sum({<MonthYear ={">=$(=Date(addmonths(Max(MonthYear), -13), 'MMM-YY')) <=$(=Date(addmonths(Max(MonthYear), -1), 'MMM-YY'))"} >} STBEL)

Now I want to add so it only do this calculation if order type equals "2" ( STOTYP=2 )

I'm not sure where the first calculation starts and stops (new to Qlikview)

Can someone please help me to add this condition to the calculation.

Many Thanks

eduardo_sommer — Fri, 06 Jun 2014 00:14:50 GMT

Before the last angle bracket (>), include ,STOTYP={2}

This will add the second condition. Don't forget the comma to separate the conditions.

Eduardo

shawn-qv — Fri, 06 Jun 2014 00:16:09 GMT

sum({<MonthYear ={">=$(=Date(addmonths(Max(MonthYear), -13), 'MMM-YY')) <=$(=Date(addmonths(Max(MonthYear), -1), 'MMM-YY'))"}, STOTYP = {2}>} STBEL)

Essentially, you can place it before or after the MonthYear = {} condition.

The QlikView's Help file is a good place to help you understand Set Analysis a little better.

Fri, 06 Jun 2014 00:17:29 GMT

Can't you simply add

<STOTYP={2} at the start of the set analysis

Fri, 06 Jun 2014 00:26:50 GMT

Thanks Shawn