topic set analysis expr checking in QlikView

set analysis expr checking

Sat, 16 Apr 2016 10:01:22 GMT

hi,

pls check, not showing data.

sum(

{<Set_ID = {1}>}

IF(GetSelectedCount(QuarterFlag)>0,MonthOpenFlag,Count({<WeekNo={">=$(=Max(WeekNo)-12)<=$(=Max(WeekNo))"}>}WeekOpenFlag)))

Regards,

Sub2u444

Re: set analysis expr checking

Chanty4u — Sat, 16 Apr 2016 10:11:33 GMT

any errors?

try

sum(

{<Set_ID = {'1'}>}

IF(GetSelectedCount(QuarterFlag)>0,MonthOpenFlag,Count({<WeekNo={">=$(=Max(WeekNo)-12)<=$(=Max(WeekNo))"}>}WeekOpenFlag)))

Re: set analysis expr checking

swuehl — Sat, 16 Apr 2016 10:11:42 GMT

That's because your embedding an aggregation function into another aggregation function, so in general, you would need to use advanced aggregation aggr() function if you want to do this.

But maybe you want to do it like

IF(GetSelectedCount(QuarterFlag)>0,

sum({<Set_ID = {1}>} MonthOpenFlag),

Count({<WeekNo={">=$(=Max(WeekNo)-12)<=$(=Max(WeekNo))"}>}WeekOpenFlag)

)