topic Re: getselectedcount() is not working QV11 in QlikView

getselectedcount() is not working QV11

vipingarg23 — Wed, 16 Aug 2017 10:27:03 GMT

Hi Team,

I am using below calculated condition in my straight table with alternate state

=GetSelectedCount(Year,False(),'Alternate State Name')

This condition is working fine in QV12 but it is not working in QV11.

Can anyone suggest me on the same?

Re: getselectedcount() is not working QV11

vipingarg23 — Wed, 16 Aug 2017 10:29:34 GMT

In QV11, it is giving me syntax error.

Re: getselectedcount() is not working QV11

antoniotiman — Wed, 16 Aug 2017 10:33:24 GMT

It is available in QV Version >= 11.20 SR8

Regards,

Antonio

Re: getselectedcount() is not working QV11

vipingarg23 — Wed, 16 Aug 2017 10:36:48 GMT

So, there is no other alternative if I am using other version. I can't change the version.

Re: getselectedcount() is not working QV11

antoniotiman — Wed, 16 Aug 2017 10:49:11 GMT

I'm sorry, as far as I know no.

Re: getselectedcount() is not working QV11

antoniotiman — Wed, 16 Aug 2017 10:53:28 GMT

However You can try to use Count({State1} Distinct Field .. instead.

Re: getselectedcount() is not working QV11

Anonymous — Wed, 16 Aug 2017 11:01:56 GMT

but then the problem is that you can't distinguish between nothing selected and all selected or am I wrong?

Re: getselectedcount() is not working QV11

vipingarg23 — Wed, 16 Aug 2017 11:06:40 GMT

I just want to check the condition if any value is selected by user from

the field or not and I am using alternate state also. This syntax is not

working in QV11 but working in 12

On Wed, Aug 16, 2017 at 4:32 PM, Robin Hausdörfer <qcwebmaster@qlikview.com>

Re: getselectedcount() is not working QV11

Anonymous — Wed, 16 Aug 2017 11:11:14 GMT

... and that's why you can't use the idea of Antonio... because that is similar to getpossiblecount().

I think you need to update ...

Re: getselectedcount() is not working QV11

vipingarg23 — Wed, 16 Aug 2017 11:18:01 GMT

No..It is not working as I am not able to use Alternate state with this function.

Re: getselectedcount() is not working QV11

antoniotiman — Wed, 16 Aug 2017 12:13:03 GMT

A workaround.

Create variable like vGetCount

Set Trigger like this

and check vGetCount as GetSelectedCount with set Alternate State.

See Attachment

Re: getselectedcount() is not working QV11

vipingarg23 — Fri, 18 Aug 2017 13:20:34 GMT

Sorry for late reply. But it is not working. I found other alternate solution with Only() function. Thanks for your help.