topic Re: Aggr() Rank Buckets in Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Aggr-Rank-Buckets-in-Pivot-Table/m-p/1009685#M342701 <HTML><HEAD></HEAD><BODY><P>Whoever can answer this will be my hero! This is the last step I have to creating an efficient app. Right now I have a solution but it uses ~100 nested if statements!</P></BODY></HTML> Tue, 06 Oct 2015 22:58:33 GMT 2015-10-06T22:58:33Z Aggr() Rank Buckets in Pivot Table https://community.qlik.com/t5/QlikView/Aggr-Rank-Buckets-in-Pivot-Table/m-p/1009684#M342700 <HTML><HEAD></HEAD><BODY><P>Hi Qlik Community</P><P></P><P>I am currently endevouring to solve the following:</P><P></P><P>I would like to create a 4x4 matrix (pivot table) with, in one dimension, the rank according to one score, and on another the rank according to another score WITHIN the buckets in the first dimension. I need this because the scores are highly correlated, and I would like to have 16 equal sized buckets. I figured that the pivot table would take take of this, but it takes the rank according to the entire population in the second dimension. Is there a way to restrict the ranking to only the bucket defined in the first dimension? I've provided an example QVW below. </P></BODY></HTML> Tue, 06 Oct 2015 17:15:41 GMT https://community.qlik.com/t5/QlikView/Aggr-Rank-Buckets-in-Pivot-Table/m-p/1009684#M342700 2015-10-06T17:15:41Z Re: Aggr() Rank Buckets in Pivot Table https://community.qlik.com/t5/QlikView/Aggr-Rank-Buckets-in-Pivot-Table/m-p/1009685#M342701 <HTML><HEAD></HEAD><BODY><P>Whoever can answer this will be my hero! This is the last step I have to creating an efficient app. Right now I have a solution but it uses ~100 nested if statements!</P></BODY></HTML> Tue, 06 Oct 2015 22:58:33 GMT https://community.qlik.com/t5/QlikView/Aggr-Rank-Buckets-in-Pivot-Table/m-p/1009685#M342701 2015-10-06T22:58:33Z