topic what is different between getpossiblecount and count functions in QlikView

what is different between getpossiblecount and count functions

qvhjenvo — Thu, 28 Nov 2013 11:21:51 GMT

Hi,

Somebody can tell What is different between getpossiblecount() and Count() functions?

Regards

Loi

Re: what is different between getpossiblecount and count functions

israrkhan — Thu, 28 Nov 2013 11:28:34 GMT

Hi,

Count is normal aggr function, where you can count ant field, like

Count(EmployeeId) it will give you number of employees.

where getpossiblecount() works with selection, when you select a field, you see possible values for that field,

let say you select Department in list box, and on selection of Department you can see how many employees are in selected department, so you can use getpossiblecount() for the counting purpose. it will give you all employee for that selected department.

Hope it helps...

Re: what is different between getpossiblecount and count functions

Thu, 28 Nov 2013 11:30:02 GMT

Hi Loi,

GetPossibleCount works more like a distinct count. It gets the count of possible values of the field.

check the attached QVW for an example.

Re: what is different between getpossiblecount and count functions

hic — Thu, 28 Nov 2013 19:16:41 GMT

GetPossibleCount() is exactly the same as Count(distinct total ...). Note the total qualifier - this means that the function isn't sensitive to the dimensional scope. See more on http://community.qlik.com/blogs/qlikviewdesignblog/2013/09/09/aggregation-scope

The GetPossibleCount exists as a "sister" function to GetSelectedCount and GetExcludedCount.

HIC

Re: what is different between getpossiblecount and count functions

federerman — Fri, 20 Mar 2020 22:21:49 GMT

Thanks for your comment Henric.

I was struggling to understand the difference between these two functions as I was designing a calculation condition on one of my charts. I was trying to understand which is the best practice if there was in fact a difference between these two functions.

As always, your posts help bring clarity when I'm a bit confused on something Qlik related. Have a nice weekend!

-Ken Krehbiel