Help Needed Creating a Points Value against a Number

Fri, 08 May 2015 13:18:41 GMT

Good Morning,

I am using QlikSense to display my sales teams engagement in using the Salesforce.com application and I have created some metrics that I am observe however I have been asked by the sales leadership to produce a stack ranking of the Account Managers based on a points system...

For example I have a field that measures and visualizes the total number of opportunities that have been created, this is displayed as a percentage against a target goal.

For example if an Account Manager creates 8 opportunities and the goal is 10 then they have 8 points. What I would like to do is create a measure that would only have a maximum of 10 so that someone that creates 20 opportunities does not change the over all results because they are using only one section of the program when in fact they need to be using all 5 area;s of the program.

This is my original formula to figure out the average number of opportunities against the target goal. I just need to learn how to make the result a maximum of 10

Avg([New Opportunitites (Last Month)] / 15)

Thank you all for your help

Barry

Re: Help Needed Creating a Points Value against a Number

Gysbert_Wassenaar — Fri, 08 May 2015 17:30:17 GMT

rangemin(10,Avg([New Opportunitites (Last Month)] / 15))

Re: Help Needed Creating a Points Value against a Number

Fri, 08 May 2015 17:47:08 GMT

Gysbert,

Thank you so much this worked perfect.

topic Help Needed Creating a Points Value against a Number in QlikView

Help Needed Creating a Points Value against a Number

Re: Help Needed Creating a Points Value against a Number

Re: Help Needed Creating a Points Value against a Number