Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
michaelsikora
Contributor III
Contributor III

Re: Display the name of dimension, at a certain rank

Vishwarath,

Thank you.

I should have used the actual expression that I am using. I am trying to rank based on the count. Rather than Sum(NetSales), I am using the following expression:

RANK(

Count(DISTINCT {<%Order={"=QtyOrd=QtyShip AND ShipDate<=PromiseDate"}>} OrderNumber)

/

Count(DISTINCT OrderNumber))

Any idea how to get Whse_name for this? Currently this is returning a number rank.

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

May be this?

= FirstSortedValue(Whse_Name, -Aggr(Count(DISTINCT {<%Order={"=QtyOrd=QtyShip AND ShipDate<=PromiseDate"}>} OrderNumber)/Count(DISTINCT OrderNumber), OrderNumber))

View solution in original post

1 Reply
vishsaggi
Champion III
Champion III

May be this?

= FirstSortedValue(Whse_Name, -Aggr(Count(DISTINCT {<%Order={"=QtyOrd=QtyShip AND ShipDate<=PromiseDate"}>} OrderNumber)/Count(DISTINCT OrderNumber), OrderNumber))

View solution in original post