topic Re: GetSelectedCount and alternative state in QlikView

GetSelectedCount and alternative state

Wed, 12 Aug 2015 07:59:24 GMT

Hi!

Can I use "GetSelectedCount" with alternative state?

I am trying to create a conditional for my expression: sum({[Simulation State]}if([Project type] ='Back up project', Hours)) so that it would do the calculation only if there is at least one value selected in a field "Back up projects".

When I try if(GetSelectedCount( {[Simulation State]} [Back up projects])<>0, ....) it shows error line for the Alt State first curly bracket.. Is it a syntax problem? If I add only() between getselectedcount and alt state it says expression OK but it doesn't make it work as I want.

Thank you community already advanced!

Regards,

Heidi

Re: GetSelectedCount and alternative state

sunny_talwar — Wed, 12 Aug 2015 08:14:31 GMT

Have a look here: Re: GetSelectedCount and Alternative State

Re: GetSelectedCount and alternative state

maxgro — Wed, 12 Aug 2015 08:21:59 GMT

state is the 3rd parameter, field the 1st

this is from Qlik help

getselectedcount (FieldName [, IncludeExcluded [, State]])

Returns the current number of selected values in a field. It is possible to query an alternate state.

If IncludeExcluded is true the count will include selected values, which are currently excluded by selections in other fields. If false or omitted these values will not be included.

State is the alternate state to query.

Examples

getselectedcount ( Year )

getselectedcount ( Year, true( ) )

Re: GetSelectedCount and alternative state

swuehl — Wed, 12 Aug 2015 08:25:34 GMT

=GetSelectedCount( [Back up projects], False(), 'Simulation State')

Re: GetSelectedCount and alternative state

Wed, 12 Aug 2015 10:14:52 GMT

It shows an error after the false and without the false() it doesn't work either?

Re: GetSelectedCount and alternative state

sunny_talwar — Wed, 12 Aug 2015 10:19:58 GMT

If you are using a version older than 11.2 SR8, the above won't work. This is because it got introduced in SR 8.

HTH

Best,

Sunny

Re: GetSelectedCount and alternative state

sunny_talwar — Wed, 12 Aug 2015 10:21:03 GMT

Link for SR8 Beta Release which talks about this new added functionality in SR8: QlikView 11.20 Service Release 8 Beta is now available

Re: GetSelectedCount and alternative state

Thu, 13 Aug 2015 08:10:40 GMT

Hi!

Thank you Sunny and swuehl! I updated to the SR12 version and now everything works as they should (:

Regards,

Heidi

Re: GetSelectedCount and alternative state

sunny_talwar — Thu, 13 Aug 2015 08:15:41 GMT

Awesome

I am glad we were able to help.

Best,

Sunny