topic Re: Count If with multiple deminsions in QlikView

Count If with multiple deminsions

Wed, 25 Nov 2020 16:16:04 GMT

Thanks in advance.

I need to count distinct deminsions where if one of three deminsions occur - then it would count as one..and in the chart the total would also sum.

This is giving me the correct totals, however it's not summing at the top of the chart (table)

=count (DISTINCT HCP_Weekly_Writer or HUB_HCPID or if(ProgType__CNE,'Patient',HCPID__CNE))

Need to get a count of anyone that EITHER Was a Weekly Writer, had one or more HUB submissions, or had a Prog with a "Patient"

Thanks in advance!

Anil_Babu_Samineni — Thu, 31 Aug 2017 04:02:17 GMT

When you talk about multiple dimensions used then i always prefer to use Flag. and then use simple flag for that?

Fri, 01 Sep 2017 00:42:48 GMT

ok cool...haven't created flags in the past...do you do it on the load or how would you create this one?

Thank you!