topic Re: Rank multiple dimensions? in QlikView

Rank multiple dimensions?

devarasu07 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Tried like below expression as Calculated dimension and it's giving correct. do you have any idea to resolve it? Thanks

=aggr(rank(sum(SoldQty),4),Launch_No,CurrentSellingPrice,ArticleNo)

tresB — Fri, 07 Apr 2017 07:08:39 GMT

Could you explain more on expected output?

devarasu07 — Fri, 07 Apr 2017 07:27:04 GMT

Hi,

The report is to allows store to ensure all stocks are display as per the sequence;

1) Launch_No, (Is number (one launch can have many article with selling price)

2) current Selling Price (desc order) ---> Is the Price value from dimension

3) Sold Qty (high to low) by ArticleNo

Note:

1) Sub total of every article sold

2) Rank with one dimension is working fine but we need to show the report based on the above order sequence.

I've tried below expressions,

=aggr(NODISTINCT rank(TOTAL sum(SoldQty),4) Launch_No,CurrentSellingPrice, ArticleNo)

//=aggr(Rank(sum(SoldQty),4),Launch_No,Original_Selling_price,ArticleNo)

//=Max( aggr ( sum(SoldQty) , CurrentSellingPrice, ArticleNo ) )

//=aggr(rank(sum(SoldQty),4),ArticleNo,CurrentSellingPrice)

Thanks,

Deva

sunny_talwar — Fri, 07 Apr 2017 08:15:15 GMT

What are the numbers you are expecting to see?