topic Re: Regarding the Rank in QlikView

Regarding the Rank

Sunilkumar3 — Thu, 26 Jan 2023 07:07:14 GMT

Hi I have Region, country and Molecule. in the Data. I want to show Region, country and Molecule Sales and their Rank. in a Table. Below are the Sample Data.

Region,    Country, Molecule,    Sales
R1, C1, M1,    100
R1,    C1, M1,    20
R1,    C1, M1,    30
R1,    C2, M1,    200
R1,    C3, M1,    300
R1,    C3, M1,    30
R1,    C2, M1,    20
R1,    C2 M2,    50
R1,    C1, M2,    100

R1, C2, M2, 150
];

If I Select any Region, country and Molecule then Show its Actual Rank Based on the Sales

Re: Regarding the Rank

MayilVahanan — Thu, 26 Jan 2023 08:59:55 GMT

Try like below

Aggr(Rank(Sum({1}Sales)), Region, Country, Molecule)

Re: Regarding the Rank

Sunilkumar3 — Wed, 01 Feb 2023 04:09:23 GMT

Hi thanks for providing the solution

Re: Regarding the Rank

Sunilkumar3 — Thu, 23 Feb 2023 06:24:02 GMT

Hi Team,

I have Created a Adhoc Report and I have multiple dimensions and Measure. Below are the Example.

If I Select Jan-2023 then Result should be Below. Means I want the result in Single Row . Can any one guide how write the expression. for that

Month_year	CY Sales	LY sale
Jan-23	10	15