topic Re: Subtrating 2 formulas in QlikView

Subtrating 2 formulas

sweens78 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys I've two formulas below I want to subtract 1 from the other but I think I'm getting the brackets wrong hence wrong answer?

Any ideas of what I might be doing wrong?

Formula 1

count({<NOK_Carer_ID={2}>} NEWKEYID)-count({<NOK_Carer_ID={2}>} PatientsNotAssessed_ID)+count({<NOK_Carer_ID={1}>} NEWKEYID)-count({<NOK_Carer_ID={1}>} PatientsNotAssessed_ID)

Formula 2

count({<NOK_Carer_ID={3}>} NEWKEYID)-count({<NOK_Carer_ID={3}>} PatientsNotAssessed_ID)+count({<NOK_Carer_ID={4}>} NEWKEYID)-count({<NOK_Carer_ID={4}>} PatientsNotAssessed_ID)

Trying to Subtract?

count({<NOK_Carer_ID={2}>} NEWKEYID)-count({<NOK_Carer_ID={2}>} PatientsNotAssessed_ID)+count({<NOK_Carer_ID={1}>} NEWKEYID)-count({<NOK_Carer_ID={1}>} PatientsNotAssessed_ID) -count({<NOK_Carer_ID={3}>} NEWKEYID)-count({<NOK_Carer_ID={3}>} PatientsNotAssessed_ID)+count({<NOK_Carer_ID={4}>} NEWKEYID)-count({<NOK_Carer_ID={4}>} PatientsNotAssessed_ID)

Re: Subtrating 2 formulas

Anonymous — Tue, 25 Sep 2018 15:01:09 GMT

use additional brackets around each formula

(formula1) - (formula2)

Re: Subtrating 2 formulas

sweens78 — Tue, 25 Sep 2018 15:11:27 GMT

Great stuff Rudolf, knew I was missing something thank you

Re: Subtrating 2 formulas

dplr-rn — Tue, 25 Sep 2018 15:17:07 GMT

brackets looks ok. couple of questions

- whats the issue with the results?

- is formula 1 and 2 giving right results?

Re: Subtrating 2 formulas

sweens78 — Tue, 25 Sep 2018 15:19:02 GMT

Hi Dilip I was missing two brackets I had to put around each formula, is now working

Thanks for response