topic Re: GetSelectedCount() in another Alternate State in QlikView

GetSelectedCount() in another Alternate State

Anonymous — Wed, 13 Aug 2014 10:09:53 GMT

Hi,

I have a situation where I need GetSelectedCount(Field) into a Text Box in "Inherited State".

"Field" in Alternate State - "State A".

The following expression does not give the count for the "Field" in State "State A", but returns the count of the same Field in Inherited State instead.

=max({State A} GetSelectedCount(Field))

Please note: My requirement is to achieve this without changing the state of the text object to "State A".

Please assist.

Thanks,

Vijit

Re: GetSelectedCount() in another Alternate State

amit_saini — Wed, 13 Aug 2014 10:14:50 GMT

Try this:

='Test'&chr(32)&if(GetSelectedCount(Your_Field)>0,'- '&GetFieldSelections(Your_Field))

Thanks,
AS

Re: GetSelectedCount() in another Alternate State

tresB — Wed, 13 Aug 2014 10:21:41 GMT

I am afraid that this would not be possible.

Re: GetSelectedCount() in another Alternate State

jagan — Wed, 13 Aug 2014 10:22:14 GMT

Hi Vijit,

I think it is not possible, because you don't have any parameters apart from FieldName for GetSelectedCount() and GetFieldSelections().

Regards,

Jagan.

Re: GetSelectedCount() in another Alternate State

Anonymous — Wed, 13 Aug 2014 10:57:35 GMT

Have you tried something like :

=count ( distinct {State A} Field )

Re: GetSelectedCount() in another Alternate State

jagan — Wed, 13 Aug 2014 15:17:13 GMT

Hi Bill,

=count ( distinct {State A} Field )

This will return possible values not selected values.

Regards,

Jagan.