QlikView Expression to calculate the remaining percentage

[#1]

Hello Friends,

I have been trying to calculate a quite complicated expression to calculate the remaining percentage.

For example - the success cases are 97 % however I want to calculate the remaining cases which has to be 3% using the below expression in QV.

However, I have made the expression a bit complicated with no results.

Any pointers are highly appreciated.

Thank you!

[sunny_talwar · Accepted solution]

So you did end up using Avg([Ship Out Performance on time]) (in reference to this thread:QlikView Expression to multiply count with a field). So is that thread resolved then? Please take time to close that thread if that is resolved.

Back to this thread, is this giving you want you wanted?

[#3]

yes..indeed..using the avg function helps..Thanks for the help...

[#4]

Hi Sunny, this is a further extension to calculate additional results.

Unfortunately this does not work. Any idea where do I go wrong ?

[sunny_talwar]

So when you say it doesn't work, does it give you an incorrect number or does it give you an error?

[#6]

It gives incorrect figures.