topic how do i rank this? in QlikView

how do i rank this?

amien — Tue, 13 Sep 2011 12:58:55 GMT

rank(

sum( {$< Month = {"<= $(=Max(Month))"}>} (((value1*value2)/vale3)/10))/Max(Month)

)

this works when i only have material_ID as dimension. When i put both material_ID and material_descriptions as dimensions, all values of the above expression will be 1 .. how can is solve this? i need two dimensions

how do i rank this?

swuehl — Tue, 13 Sep 2011 13:21:09 GMT

Hi Amien,

probably your dimensions result in a single record per combination of dimensions?

Try using the TOTAL qualifier, maybe

rank( TOTAL

sum( {$< Month = {"<= $(=Max(Month))"}>} (((value1*value2)/vale3)/10))/Max(Month)

)

Regards,

Stefan

how do i rank this?

tmumaw — Tue, 13 Sep 2011 13:26:29 GMT

Create a concatinate key with your material and description and rank on that.