topic Re: how display top two projects in QlikView

how display top two projects

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

Hi all,

I have Four fields,say

Required o/p:

thanks in advance.

tresB — Fri, 28 Sep 2018 06:02:38 GMT

Try:

Aggr(If(Rank(Max(Hours))<3,Max(Hours)), Year, Project)

jyothish8807 — Fri, 28 Sep 2018 06:09:37 GMT

Hi Praveen,

Try like this:

if(Aggr(rank(sum(Hours)),Year,Project)<= 2,Aggr(sum(Hours),Year,Project))

For year 2018 i am getting different out put check the sample.

Br,

jyothish8807 — Fri, 28 Sep 2018 06:11:54 GMT

I missed the max part

chinnuchinni — Fri, 28 Sep 2018 06:27:32 GMT

Hi,

instead of sum ,if we use max it will give proper output

Thanks You

chinnuchinni — Fri, 28 Sep 2018 06:28:00 GMT

Thank you Tresesco