Need help on the setanalysis expression!

Fri, 29 May 2015 07:03:01 GMT

Hi All,

I have an expression to give the count of units that are opened for grater than or equal to 15 days for the maximum period , maximum year, however I tried the same expression for the all periods up to the selected period.[ For YTD]

my expressions are like below:

For Period

Count({<[UNIT]= {"=aggr(Sum({<Period={$(=max(Period))},YEAR={$(=max(YEAR))}>} [Net Sales] ),[UNIT])>=15"}>}[UNIT])

For Up to The Selected Period

Count({<[UNIT]= {"=aggr(Sum({<Period={"<=$(=max(Period))"},YEAR={$(=max(YEAR))}>} [Net Sales] ),[UNIT])>=15"}>}[UNIT])

In the above Formulas Period formula is returning count but Second formula not working can any one guide me where I gone wrong.

Regards

John

Re: Expression

Fri, 29 May 2015 07:10:18 GMT

Try this:

Count({<[UNIT]= {"=aggr(Sum({<Period<={$(=max(Period))},YEAR={$(=max(YEAR))}>} [Net Sales] ),[UNIT])>=15"}>}[UNIT])

Re: Expression

Fri, 29 May 2015 07:12:44 GMT

No Its Not Working

topic Need help on the setanalysis expression! in QlikView

Need help on the setanalysis expression!

Re: Expression

Re: Expression