topic Re: How to use COUNT with multiple selections in QlikView

How to use COUNT with multiple selections

Wed, 06 Jul 2016 09:54:08 GMT

HI All,

I want to count the number of records ( HCCurrent.Sr. No) and it does good by using the below expression.

count({< HCCurrent.Eligible = { '$(=GetFieldSelections(Eligible))'},

HCCurrent.OU = { '$(=GetFieldSelections(OU))'}>}[HCCurrent.Sr. No])

however if I do not select anything in OU then it returns zero.

How can I use count such that it outputs the dynamic count of a particular field as I add or reduce filter conditions.

Thanks in advance.

Re: How to use COUNT with multiple selections

Wed, 06 Jul 2016 11:52:40 GMT

GetFieldSelections only work with a selected field. Perhaps you can ensure that your list box properties has "always one value selected" checked.

Cheers,

Pravesh

Re: How to use COUNT with multiple selections

hic — Wed, 06 Jul 2016 12:16:45 GMT

If you just use

Count( [HCCurrent.Sr. No] )

this will automatically show the dynamic count based on your filter conditions (your selections). But this is not what you want do ... or? So, you want something different - but I am not sure I understand what.

Re: How to use COUNT with multiple selections

Wed, 06 Jul 2016 12:42:50 GMT

Hi Henric

I can use simply count ([HCCurrent.Sr. No] ) because i want to use the values from the selection.

I did not highlight earlier that i have 2 different tables involved. What i select will be from Table1 ( without the qualifier)

and I want the count with these selection from Table2( with qualifier HCCurrent )

Hope I am able to explain this .

count({< HCCurrent.Eligible = { '$(=GetFieldSelections(Eligible))'},

HCCurrent.OU = { '$(=GetFieldSelections(OU))'}>}[HCCurrent.Sr. No])

Thanks & regards

Rohit

Re: How to use COUNT with multiple selections

hic — Thu, 07 Jul 2016 15:51:33 GMT

If you have a link between the two tables - a key field - this will work automatically. There is no need to program it. From what you have said so far, a standard

Count( [HCCurrent.Sr. No] )

should do the trick. That is - if your data model hast this link between the two tables.

HIC

Re: How to use COUNT with multiple selections

rwunderlich — Thu, 07 Jul 2016 16:01:53 GMT

Can you post a screenshot of your data model from the Table Viewer?

-Rob

Re: How to use COUNT with multiple selections

Fri, 08 Jul 2016 03:01:05 GMT

Thanks Henric & Rob,

I may not be able to share the screenshot due to security issues.

But the Table2( with qualifier HCCurrent ) is an independent table.

I have intentionally kept it independent and not linked it into the data model because I want to count the data from this table as it is the current snapshot.

Thanks to point me to the Data Model, i will consider to re-design it.

Thanks for all the help so far. Will surely come to you again in case I have challenges.

Regards

ROhit