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]

You need to create a Text box in your Sheet and put the expression.

ex:

1. Right Click on Sheet -> New Sheet Object -> Text Object

2. Type in the expression in the Text area. Prefix your expression with = sign

[#3]

Hello ,

First of all, i would like to thank you for your support on my last

question.

Here i my new concerne, i have this set of data :

For each number in column 1, i have lots of item on the other columns

I would like to perform de carculation column 4*column 5 for ieach item of

colum 1 .

then have this item in a table.

my proble id to perform select the item in column 1?

Thanks for your support regards.

Cordialement,

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

[#4]

thanks for your answer