topic Re: Normal Formula instead of set analysis in QlikView

Normal Formula instead of set analysis

sweens78 — Fri, 25 Jan 2019 17:22:30 GMT

Hi Guys,

In the formula below , I just want to use a normal formula instead of Set analysis any ideas?

NUM((count({<MentalHealthHistory_ID={'2','3'}>} NEWKEYID))/(Count(NEWKEYID)-Count(PatientsNotAssessed_ID)),'##.##%')

Martin

trdandamudi — Fri, 25 Jan 2019 18:54:47 GMT

May be as below:

Num(If(MentalHealthHistory_ID='2' OR MentalHealthHistory_ID='3',Count(NEWKEYID)/Count(NEWKEYID) - Count(PatientsNotAssessed_ID),'##.##%')

sweens78 — Fri, 25 Jan 2019 20:28:13 GMT

thank you trdandamudi

Should there be a 'count' before the' if 'some where seem to be getting an error with a bracket?