topic Re: Calculate ratio with measurements on multiple rows in QlikView

Calculate ratio with measurements on multiple rows

Wed, 11 May 2016 14:56:19 GMT

Hi everyone,

I'm very new on QlikSense but already loving it !

I think I have missed something in the way of building expressions, or maybe what I want to do is not possible, but I can't find a way to do calculate my percentage. Here is an example :

Task	Status	Count
task1	ok	123
task1	failed	5
task2	ok	45
task2	failed	20
task3	ok	68
task3	failed	2
task4	ok	147
task4	failed	33

As you can see, each task can have 2 statuses which can be "failed" or "ok".

I want to get the success rate of each task by calculating the ratio of successful vs failed tasks.

Thanks in advance for any help !

Re: Calculate ratio with measurements on multiple rows

sunny_talwar — Wed, 11 May 2016 16:03:55 GMT

successful vs failed or successful vs overall?

Successful vs failed:

Sum({<Status = {'ok'}>}Count)/Sum({<Status = {'failed'}>}Count)

Successful vs overall:

Sum({<Status = {'ok'}>}Count)/Sum(Count)

Re: Calculate ratio with measurements on multiple rows

ramoncova06 — Wed, 11 May 2016 17:18:10 GMT

Sunny already provided an answer

Re: Calculate ratio with measurements on multiple rows

Wed, 11 May 2016 18:33:49 GMT

Hi,

Thanks for your fast answer !

I tryed your expression, adding a measure to my simple table, but only the total ration is calculated. All the other rows have 0 value, and I need this ratio for each task.

Re: Calculate ratio with measurements on multiple rows

sunny_talwar — Wed, 11 May 2016 18:50:15 GMT

Is this what you want?

Re: Calculate ratio with measurements on multiple rows

Wed, 11 May 2016 18:58:45 GMT

Yes perfect ! Sorry I did not understand that I needed to make an other table.

Now I understand far better how it works !

Thank you for your amazing help !

Re: Calculate ratio with measurements on multiple rows

sunny_talwar — Wed, 11 May 2016 20:04:06 GMT

No problem at all

Re: Calculate ratio with measurements on multiple rows

Tue, 10 Oct 2017 19:11:56 GMT

is there a way to get ratio as non %?

Re: Calculate ratio with measurements on multiple rows

sunny_talwar — Wed, 11 Oct 2017 08:45:41 GMT

Not sure if I understand your question?

Re: Calculate ratio with measurements on multiple rows

Thu, 12 Oct 2017 21:17:25 GMT

for ex:

if i want the ratio from start to finish .

start: finish

3 6

5 10

20 100

i know how to use expression to get % but i want to show as 3:6 which simplifies to 1:3, and 5:10 will be 1:5 and 20:100 will be 5:25

thanks

Re: Calculate ratio with measurements on multiple rows

sunny_talwar — Thu, 12 Oct 2017 23:43:36 GMT

You will need GCD here... there is no inbuilt function, but you can write your own function... check here:

How to calculate the GCD(Greatest Common divisor)