Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QlikView Expression to calculate the remaining percentage

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!

1 Solution

Accepted Solutions
sunny_talwar

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?


View solution in original post

5 Replies
sunny_talwar

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?


Not applicable
Author

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

Not applicable
Author

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?

Not applicable
Author

It gives incorrect figures.