Calculate ratio with measurements on multiple rows

[#1]

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 !

[sunny_talwar]

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)