Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Fellow Qlikers,
I need help with getting ranks for my data, the issue is that when a dimension value is having a same rank i.e 4-5, I need to sort that value based on another field, I have tried doing it but it seems to be not working as I am getting 1 as the same rank for all the values.
Basically the data currently looks like this.
Expression in Rank 1:
Aggr
I want to sort the rank 4-5 into 4 & 5 giving [# 175 - Polymer Wax Polish 250 ml] as 4th rank and [# 170 - Wax Shampoo 250 ml] as 5 th rank.
Meaning that I want them to be sorted on lift if the ranking is coming out to be same and want to show it in the Simple KPI rather than the chart.
Do let me know if anything further can be provided for understanding the issue.
@deepanshuSh try below
=aggr(rank(sum({<Recommendation_type={'Single'}>}[Recommendation Confidence])*1e10 + [Recommendation Lift]),[Product Recommendation])
or
=aggr(rank(sum({<Recommendation_type={'Single'}>}[Recommendation Confidence])*1e10 + sum(distinct {<Recommendation_type={'Single'}>}[Recommendation Lift])),[Product Recommendation])
@deepanshuSh Is recommendation lift dimension or measure? How recommendation lift value derived for Product Recommendation? Is it sum(Recommendation Lift)?
Thanku for the response,
Recommendation lift is a dimension. Each product recommendation is linked to a concatenated product name and each product recommendation has their own specific lift value.
@deepanshuSh try below
=aggr(rank(sum({<Recommendation_type={'Single'}>}[Recommendation Confidence])*1e10 + [Recommendation Lift]),[Product Recommendation])
or
=aggr(rank(sum({<Recommendation_type={'Single'}>}[Recommendation Confidence])*1e10 + sum(distinct {<Recommendation_type={'Single'}>}[Recommendation Lift])),[Product Recommendation])
Hi @Kushal_Chawda , thanku for the response.
What does this 1e10 Represent here?
@deepanshuSh It's representation of Number 10000000000.
Hi, Thanku Kushal for the help. This partly solves my problem along with another workaround.
Apologies, I could not respond earlier, due to some issues with my laptop, Thanks for the help.