topic Re: I require an inverted % in QlikView

I require an inverted %

helen_pip — Tue, 23 Apr 2013 14:01:28 GMT

Hello

I have a % calculation which returns the value of 12.91%

num

((Count({<YEAR = {$(=Max(YEAR))}>}LOCAL_PATIENT_IDENTIFIER)/Count({<YEAR = {$(=Max(YEAR)-1)

However what I want to achieve is 100% - 12.91% so I get the value of 87.09%

Can anyone tell me how I can achieve this?

Thanks

Helen

CELAMBARASAN — Tue, 23 Apr 2013 14:06:17 GMT

use

1 - num([Your Expression])

helen_pip — Tue, 23 Apr 2013 14:09:15 GMT

Hello

Thank you for your response

I get a null value - when I tried this:

Have I written it correctly?

num((Count({<YEAR = {$(=Max(YEAR))}>}LOCAL_PATIENT_IDENTIFIER)/Count({<YEAR = {$(=Max(YEAR)-1)

Thanks

Helen

CELAMBARASAN — Tue, 23 Apr 2013 17:35:40 GMT

I hope this might be your need.

num((Count({<YEAR = {$(=Max(YEAR))}>}LOCAL_PATIENT_IDENTIFIER)/Count({<YEAR = {$(=Max(YEAR)-1)}>}LOCAL_PATIENT_IDENTIFIER)

helen_pip — Wed, 24 Apr 2013 11:25:19 GMT

Thank you

This works for me

Helen