topic Re: Rank Question in QlikView

Rank Question

vikasmahajan — Tue, 18 Aug 2015 08:13:11 GMT

Hii,

I have following expression to calculate Top nos group1 wise

IF(Aggr(Rank(sum([Amt]),4),[Group1])<=vTopNos,[Group1]))

Now I want to calculate top nos using monthname it is linked to calendar

How to calculate rank with 2 dimensions.

Vikas

sasiparupudi1 — Tue, 18 Aug 2015 08:22:13 GMT

this?

IF(rank(Aggr(sum([Amt]),[Group1],[Month]),4)<=vTopNos,[Group1]))

MK_QSL — Tue, 18 Aug 2015 09:06:54 GMT

Dimension

Field1

Field2

Expression

SUM(Aggr(IF(Rank(SUM(FieldName),4)<=vTopNos,SUM(FieldName),Field1,Field2))

Kushal_Chawda — Tue, 18 Aug 2015 09:11:52 GMT

Dimensions

1) MonthName

2) Aggr(IF(Rank(SUM([Amt]),4)<=vTopNos,[Group1],MonthName,[Group1])

Expression

=sum([Amt])

vikasmahajan — Tue, 18 Aug 2015 10:26:02 GMT

Thanks for reply I have resolved it by storing top nos ids in variable and used same in set analysis.

V_VAL:

=CONCAT(IF(Aggr(Rank(sum([Amount]),4),[Group1])<=vTopNos,[Group1]),',')

used in set analysis like Sum({< Amount = {'XYZ'},[Group1]={$(=V_VAL)} >} Amount)

Vikas