Peer Rank expression for selected value over all values in a dimension.

Michael_Reese — Sat, 03 Aug 2013 16:50:39 GMT

Hello,

I have a chart that has rank, peer rank, procedure code and net paid.

The expectation is that when a providerid is selected, the rank will show that provider's products by net paid in descending order. The rank field accurately reflects that.

The problem is with peer rank. With a providerid selected, I need the peer rank field to show that selected providerid's ranking for that procedure over the enter universe of providers.

See below. One provider is selected. Rank shows the ranking of products for that provider. Peer Rank should show his rank compared to all providers.

I've tried all of these expressions and none work.

// aggr(Rank(sum(total <ProcedureCode> NetAmountPaid)), ProcedureCode)

//aggr(Rank(sum(total <ProcedureCode, ProviderID> NetAmountPaid)), ProcedureCode)

//aggr(Rank(sum({<ProviderID=>} total <ProcedureCode, ProviderID> NetAmountPaid)), ProcedureCode)

//aggr(Rank(sum({<ProviderID=>} total <ProcedureCode> NetAmountPaid)), ProviderID)

//aggr(Rank(sum(total <ProcedureCode> NetAmountPaid)), ProviderID)

//aggr(Rank(sum(total <ProcedureCode> NetAmountPaid)), ProcedureCode)

//aggr(Rank(sum(total <ProviderID> NetAmountPaid)), ProcedureCode)

//aggr(Rank(sum({<ProviderID=>} total <ProviderID> NetAmountPaid)), ProcedureCode)

//aggr(Rank(sum(total ProcedureCode> NetAmountPaid)), ProviderID)

//aggr(Rank(sum(total <ProviderID> NetAmountPaid)), ProcedureCode)

//rank(aggr(sum({<ProviderID=>} total <ProcedureCode, ProviderID> NetAmountPaid), ProviderID), ProviderID)

//rank(sum({<ProviderID=>} total <ProcedureCode, ProviderID> NetAmountPaid), ProviderID)

//rank(aggr(sum({<ProviderID=>} total <ProcedureCode, ProviderID> NetAmountPaid), ProviderID))

//rank(aggr(sum({<ProviderID=>} total <ProcedureCode> NetAmountPaid), ProviderID))

//rank(aggr(sum({<ProviderID=>} total <ProcedureCode> NetAmountPaid), ProcedureCode))

//rank(aggr(sum({<ProviderID=>} <ProcedureCode> NetAmountPaid), ProcedureCode) )

//rank(aggr(sum({<ProviderID=>} NetAmountPaid), Specialty, ProcedureCode) )

//rank(aggr(sum(NetAmountPaid), ProviderID, ProcedureCode))

//rank(sum(aggr(sum(NetAmountPaid), ProviderID, ProcedureCode)))

//rank(sum(aggr(sum(NetAmountPaid), ProviderID)))

//rank(aggr(sum(NetAmountPaid), ProviderID))

//rank(aggr(sum({<ProviderID=>} NetAmountPaid), ProviderID))

//rank(aggr(sum({<ProviderID=>} NetAmountPaid), ProcedureCode))

rank(sum({<ProviderID=>} NetAmountPaid) )

//rank( sum(aggr(sum(<ProviderID> NetAmountPaid), ProviderID)))

Re: Peer Rank expression for selected value over all values in a dimension.

swuehl — Sun, 04 Aug 2013 14:45:40 GMT

Mike,

maybe this solution I posted to another thread might help.

If not, please post a small sample file.

topic Peer Rank expression for selected value over all values in a dimension. in QlikView

Peer Rank expression for selected value over all values in a dimension.

Re: Peer Rank expression for selected value over all values in a dimension.