convert result from value to dimension

Sat, 22 Oct 2011 14:16:13 GMT

Hi I have text box which shows max value of price/cost according to product dimension. I want to show product name in text box.

Re: convert result from value to dimension

Miguel_Angel_Baeyens — Sat, 22 Oct 2011 16:29:42 GMT

Hi,

I already answered in your previous post, but here we go

=Only({1} 
If(
Aggr(
Rank( 
Sum({1< Employee = {'Jae Pak', 'Tsvi Reiter'} >} UnitPrice) / Sum({1< Employee = {'Jae Pak', 'Tsvi Reiter'} >} TotalProductCost), 4, 1)
, Product) = 1
, Product)
)

Kind of cumbersome because of the selection, that you want to ignore, hence all those {1}.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

topic convert result from value to dimension in QlikView

convert result from value to dimension

Re: convert result from value to dimension