topic Combine Count function with a selection and a IF statement in App Development

Combine Count function with a selection and a IF statement

andymanu — Fri, 02 Apr 2021 07:47:19 GMT

Hi All,

Could someone please help me to combine the below specified functions into a one.

I got a function with "COUNT" as, "=Count({<PASID={'*'}>}UNIQUE_SCHEDULES)"

Also I want to filter the above data using a flag which is, "FLAG_Prof_Carer_Type".

I tried as , "Count(IF(FLAG_Prof_Carer_Type=1,Count({<PASID={'*'}>}UNIQUE_SCHEDULES)))" but it is not giving me the results,

Note

field "UNIQUE_SCHEDULES" is a combined field use to filter unique set of data rows. Also, I am using the combined function in a Gauge to represent a percentage.

Appreciate your valuable feedback.

Kind regards,

Andy

Re: Combine Count function with a selection and a IF statement

vishsaggi — Tue, 12 Feb 2019 04:00:14 GMT

May be you want to write like this?

= Count({< FLAG_Prof_Carer_Type = {1}, PASID={"*"} >} UNIQUE_SCHEDULES)

Re: Combine Count function with a selection and a IF statement

andymanu — Tue, 12 Feb 2019 04:15:52 GMT

Hi Vishsaggi,
Thank you very much. It's working.
However, when I merge it to the Gauge, it's not showing the expected results.
I'll add detail data shortly may be with the QVF file.
Kind regards,
Andy