topic Re: aggr() function with selected dates in QlikView

aggr() function with selected dates

Wed, 11 Sep 2013 11:13:39 GMT

I have apivot table with the following dimension,

=if(vselect='sector' and (cdate >= vStartdate AND cdate <= vEnddate) , aggr(if(rank(count(sector))<=50,sector),sector))

but i am not getting the result for the range of dates chosen,

instead, it just aggregates the data for the maximum value of the date chosen, ie vEnddate

Please help me out. I cant figure out the issue.

Wed, 11 Sep 2013 11:19:30 GMT

try this

=if(vselect='sector' and cdate >= vStartdate AND cdate <= vEnddate , aggr(if(rank(count(sector))<=50,sector),sector))

er_mohit — Wed, 11 Sep 2013 11:28:31 GMT

Try this in dimension side

aggr(if(rank(TOTAL count(sector))<=50,sector),sector)

OR TRY THIS

aggr(if(rank(TOTAL count(sector))<=50 AND vselect='sector' and cdate >= vStartdate AND cdate <= vEnddate

,sector),sector)