Rank Issue

[cmorri1988]

Hi,

I am having issues ranking the below, with the attached table image and application for the BINDING DIFFERENCE measure.....

Applying rank() ranks the resulting number as 1 for all results within the table.

Only({1<ID = p({<Genre =  (p(Genre)), [Sub Genre] = (p([Sub Genre])),

Literal3 = (p(Literal3)),

[Price] = {">=$(vMinCTPrice)<=$(vMaxCTPrice)"},

[Pub Date Num] = {">=$(vMinCTPubDate)<=$(vMaxCTPubDate)"},

ID = e(ID),Author = , Title =, ISBN =>})>}-Binding_Prioritisation

+

Sum({$<Genre = (p(Genre)) , [Sub Genre] = (p([Sub Genre])), Literal3 = (p(Literal3))>}TOTAL Binding_Prioritisation))

Any help would be greatly appreciated.

Thank you!

[sunny_talwar]

Have you tried different mode and fmt for Rank?

Rank - chart function ‒ Qlik Sense

[sunny_talwar]

May be this

Num(Rank(TOTAL Only({1<ID = p({<Genre =  (p(Genre)), [Sub Genre] = (p([Sub Genre])),

Literal3 = (p(Literal3)),

[Price] = {">=$(vMinCTPrice)<=$(vMaxCTPrice)"},

[Pub Date Num] = {">=$(vMinCTPubDate)<=$(vMaxCTPubDate)"},

ID = e(ID),Author = , Title =, ISBN =>})>}-Binding_Prioritisation

+

Sum({$<Genre = (p(Genre)) , [Sub Genre] = (p([Sub Genre])), Literal3 = (p(Literal3))>}TOTAL Binding_Prioritisation)), 4))

[cmorri1988]

Thanks!

Seems to rank by smallest SELECTED ISBN BINDING so far, and not the difference.

Thanks again

[cmorri1988]

Does anyone have any ideas on how to rank the oiginal expression?

Thanks in Advance

[cmorri1988]

Hi Sunny, I just had to make the difference a positive, and your ranking suggestion worked, thanks again!!

=Num(Rank(TOTAL (fabs(Only({1<ID = p({<Genre =  (p(Genre)), [Sub Genre] = (p([Sub Genre])),

Literal3 = (p(Literal3)),

[Price] = {">=$(vMinCTPrice)<=$(vMaxCTPrice)"},

[Pub Date Num] = {">=$(vMinCTPubDate)<=$(vMaxCTPubDate)"},

ID = e(ID),Author = , Title =, ISBN =>})>}-Binding_Prioritisation

+

Sum({$<Genre = (p(Genre)) , [Sub Genre] = (p([Sub Genre])), Literal3 = (p(Literal3))>}TOTAL Binding_Prioritisation)))), 4))

[sunny_talwar]

That is super