Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

GetSelectedCount() in another Alternate State

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

Tags (2)
5 Replies
Highlighted
Master III
Master III

Re: GetSelectedCount() in another Alternate State

Try this:

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

Thanks,
AS

Highlighted
MVP
MVP

Re: GetSelectedCount() in another Alternate State

I am afraid that this would not be possible.

Highlighted
MVP & Luminary
MVP & Luminary

Re: GetSelectedCount() in another Alternate State

Hi Vijit,

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

Regards,

Jagan.

Highlighted

Re: GetSelectedCount() in another Alternate State

Have you tried something like :

          =count (  distinct {State A} Field )

Highlighted
MVP & Luminary
MVP & Luminary

Re: GetSelectedCount() in another Alternate State

Hi Bill,

=count (  distinct {State A} Field )

This will return possible values not selected values.

Regards,

Jagan.