topic Re: Alternate State variable calls GetSelectedCount([_ROWS]) does not work in QlikView

Alternate State variable calls GetSelectedCount([_ROWS]) does not work

wynnjimbbt — Mon, 26 Jan 2026 18:19:17 GMT

upgrading from QV11.2 SR7 to QV12.1 SR5

variables that call functions like GetSelectedCount([_ROWS]) do not calculate correctly within Alternate State. I cannot find the correct syntax to define the Alternate State in the Variable definition??

vClientFieldSelected: below, how do I define the Alternate State = 'PortView_Model' ??

=If(GetSelectedCount([_ROWS]) > 0,1,0)

Re: Alternate State variable calls GetSelectedCount([_ROWS]) does not work

Nicole-Smith — Mon, 06 Nov 2017 16:39:30 GMT

You can specify which state to use in your GetSelectedCount() function like so:

=If(GetSelectedCount([_ROWS], False(), 'PortView_Model') > 0, 1, 0)

Re: Alternate State variable calls GetSelectedCount([_ROWS]) does not work

wynnjimbbt — Mon, 06 Nov 2017 18:36:49 GMT

Thank you!

Jim Wynn

BB&T | Financial Technology Services

IT Systems Consultant

7701 Airport Center Drive

Greensboro, NC 27409

Jim.Wynn@bbandt.com

T: 336-455-9269 | C: 336-404-1221

Re: Alternate State variable calls GetSelectedCount([_ROWS]) does not work

wynnjimbbt — Mon, 06 Nov 2017 21:22:15 GMT

Thanks Nicole!
That fixed my GetSelected variables

so I have:

vBeginMnth and vBaseMnth defined in the Dashboard load script

vBeginMonth is defined as =
If( [Report Month] = vBeginMnth , vBaseMnth, vBeginMnth)

the if stmt works in a textbox but the variable vBeginMonth does not work correctly

can you help?

Re: Alternate State variable calls GetSelectedCount([_ROWS]) does not work

Nicole-Smith — Mon, 06 Nov 2017 22:47:02 GMT

I can't give you an exact answer without seeing what you're trying to do with it, but have you tried wrapping it in dollar sign expansion?

Dollar-sign expansion using a variable ‒ QlikView