Top 1 SAL

[qlikviewwizard]

Hi All,

I want to show the Top 1 SAL of the Employee details for each JOB and each LOC and for each Year,Quarter as shown below.

Thanks in advance.

EMPNO	ENAME	JOB	MGR	LOC	DNAME	SAL
7902	FORD	ANALYST	7566	IN	ACCOUNTING	50400
7698	BLAKE	MANAGER	7839	US	RESEARCH	24200
7839	KING	PRESIDENT	NULL	UK	SALES	23200

[jagan · Accepted solution]

Hi,

Try this expression

Aggr(If(Rank(sum(Sales), 1, 1) = 1, Rank(Sum(Sales),1,1)), JOB, Region, YEAR, QUARTER, EMPNO)

Regards,

Jagan.

[#3]

Hi,

The easy way to show the top sales is,

goto-> dimension limit tab