Hit rate calculation

[#1]

Hello ,

I am new in the use of qlikview. So it is not easy for me to figure out a way there are lots of ideas coming in my mind and none of them working. I have some information in diferents stage gate. i would like to calculate a hit rate. here is the problem how can i select the data at stage won/lost then get the count in order to be able to perform the ratio. Where can i perform these kind of operations.

thanks for your help

[krishnacbe]

Hi,

If you want to show as a KPI, you can use either Textbox or Gauge charts.

even simple bar/Pie chart is fine.

Can you explain in detail or share the expression/ provide sample input and output you need to help you more.

[#3]

Hello

Thanks for your answer:

As you can see in the screen below  i would like to perform a formula on :

count (closed -won)/count (closed -won)+ count (closed - lost).

thanks for your support,

regards,

[krishnacbe]

Hope below expression helps

count({<Stage={"Closed-Won"}>}[Stage Duration])/(count({<Stage={"Closed-Won"}>}[Stage Duration]) + count({<Stage={"Closed-Lost"}>}[Stage Duration]))

May be correct the Cases & spaces I have used in above expression

[#5]

thanks for your answer.

where is this expression put ?

2017-01-11 18:02 GMT+01:00 Krishnapriya Arumugam <qcwebmaster@qlikview.com>:

[johnw]

Or since A/(A+B) = 1/(1+B/A):

1/(1+count({<Stage={'Closed - Lost'}>} [Stage Duration])/count({<Stage={'Closed - Won'}>} [Stage Duration]))

Arguably less clear, I suppose, even if more concise.

Edit: Oh, clearer and nearly as concise if we just do the + as a union:

count({<Stage={'Closed - Won'}>} [Stage Duration])/count({<Stage={'Closed - Won','Closed - Lost'}>} [Stage Duration])

[johnw]

Set analysis as shown above is fine, or you could move the complexity to the script with 1/null counter fields:

if(Stage='Closed - Won',1) as [Closed Won],
if(match(Stage,'Closed - Won','Closed - Lost'),1) as [Closed Won Or Lost],

And have a simpler chart expression:

sum([Closed Won])/sum([Closed Won Or Lost])

[#8]

I have to put this expression on the scripting or? Somewhere else?

2017-01-11 18:22 GMT+01:00 John Witherspoon <qcwebmaster@qlikview.com>:

[johnw]

As an expression in whatever chart or other object you want to see the resulting percentage in.

[krishnacbe]

You need to put the expression in Text box or Chart.