Finding max value in a dimension

[amr_qlik]

Hi,

I have a dimension showing the summation of prices aggregated by category.  I also have a second dimension showing the total number of offers each category received.  

The end goal is display a single metric (percentage) to show how good each category is.  It's a simple weighted system, so for example, .60*price/max price between all categories + .4*# of offers/max # of offers between all categories.   A filter would be used to select the category of interest and then a variety of details would be displayed, with this score being of particular interest.  The problem I am having is how to write this function on the sheet so that it can access the selected category price and number of offers and determine the max price and max # of offers so that the percentage can be calculated.

Thanks

[rubenmarin]

Hi, you can try with an expression like this to count Offers:

=Max({1}TOTAL Aggr({1}Count([OfferId]), Category))

If this weight is somewhat static, not affected by selections or only some selections like Year, it would be better to have it precalculated in script.