topic Re: Set analysis for choosing a rank in QlikView

Set analysis for choosing a rank

adnan_rafiq — Tue, 24 Oct 2017 03:56:17 GMT

Hi QV Champions.

I am stuck in a situation where I need to make charts based on a particular ranking object. The Chart I have made is as follows

Here I have products and Net Sales, Gross margin and Pocket margin. I have rank expression is : Rank(Total sum(Gross Margin Actual),1).

I want to make 10 charts : the first for the product that is rank 1,another for product that is rank 2 and so on until 10.

All suggestions welcome, especially if we can use a set analysis based on rank.

Cheers

Re: Set analysis for choosing a rank

devarasu07 — Tue, 24 Oct 2017 04:16:52 GMT

Hi,

You can write like this,

Rank 1:

=only(aggr(if(rank(sum(Gross Margin Actual)),4)=1, [Product Name]), [Product Name]))

Rank 2:

=only(aggr(if(rank(sum(Gross Margin Actual)),4)=2, [Product Name]), [Product Name]))

FYI,

Mock app,

Worst Selling 5 Products?

Re: Set analysis for choosing a rank

adnan_rafiq — Tue, 24 Oct 2017 04:27:07 GMT

Thanks for reply devarasu07

My idea is I should one chart which only has one product coke 375 ml, another chart only having MLKC6 DBL

Re: Set analysis for choosing a rank

devarasu07 — Tue, 24 Oct 2017 04:30:30 GMT

Hi,

Yes it should work. give a try and let us know if still have issue send us the mock app with source and expected output in excel will try to help you. tks

Regards,

Deva

Re: Set analysis for choosing a rank

adnan_rafiq — Tue, 24 Oct 2017 06:42:43 GMT

Will this method also produce charts like this?