Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cmorri1988
Contributor

Rank Issue

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!

Tags (1)
6 Replies
MVP
MVP

Re: Rank Issue

Have you tried different mode and fmt for Rank?

Rank - chart function ‒ Qlik Sense

Capture.PNG

MVP
MVP

Re: Rank Issue

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
Contributor

Re: Rank Issue

Thanks!

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

Thanks again

cmorri1988
Contributor

Re: Rank Issue

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

Thanks in Advance

cmorri1988
Contributor

Re: Rank Issue

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))

MVP
MVP

Re: Rank Issue

That is super