Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Highlighted
andymanu
Contributor

Combine Count function with a selection and a IF statement

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

1 Solution

Accepted Solutions
vishsaggi
Esteemed Contributor III

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

May be you want to write like this?

= Count({< FLAG_Prof_Carer_Type = {1}, PASID={"*"} >} UNIQUE_SCHEDULES)
2 Replies
vishsaggi
Esteemed Contributor III

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

May be you want to write like this?

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

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

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