topic Re: Alternate state question in QlikView

Alternate state question

Thu, 08 May 2014 07:01:17 GMT

I have an alternate state 'State1', assigned to a list box entity. and my expression =GetSelectedCount((State1) * Entity) returns a '-'.

I have selected a single value there and was expecting '1'. why doesn't it work?

Thanks,

Ram

alexandros17 — Thu, 08 May 2014 07:04:42 GMT

Because State1 assigned to an object, allow the object to work separately respect to the others, State1 is not a variable or a field

Thu, 08 May 2014 07:06:02 GMT

Thanks Alessandro. I agree to all that, but I need the count of selections of the list box that has the alternate state 'State1'.

its_anandrjs — Thu, 08 May 2014 07:08:41 GMT

Try like

=GetSelectedCount(State1) * Entity

alexandros17 — Thu, 08 May 2014 07:09:57 GMT

The object in which you need to do getselectedcount(myField) must have the same state1 of the list box ...

tresB — Thu, 08 May 2014 07:10:51 GMT

GetSelectedCount() - does NOT work with alternate state. Rather try like:

Count({State1} Distinct YourField)

Thu, 08 May 2014 07:14:40 GMT

Thanks tresesco. I will try that.

Sent from my iPhone

Tue, 13 May 2014 00:53:51 GMT

it works, but if nothing is selected it gives the total count, I expect it to be zero.