Aggr and Rank funciton

Wed, 11 Sep 2013 07:56:22 GMT

Hi guys,

this is the dimension for two of my pivot table.

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

2) =if(vselect='Channel' and (cdate >= vStartdate AND cdate <= vEnddate) ,channel)

both the pivot tables have similar expressions (6 of them)

(2) works fine. It displays the channel and aggregates the expressions for data betweeen vStartdate and vEnddate

But (1) is not showing data betweeen vStartdate and vEnddate. It only shows the data for the last date, ie vEnddate.

i cannot figure out why this expression is not functioning since the only difference is the aggr() and rank() functions.

Pls help me out.

With Regards,

Arjun

topic Aggr and Rank funciton in QlikView