topic Re: Count if on button in QlikView

Count if on button

venkatg6759 — Wed, 25 Jun 2014 15:15:26 GMT

Hello all,

i am trying to get this expression by using button.

=aggr(Count([Security Name]),[% GUID]) Where i need only 1 to be selected

if(Count(SecurityName)=1,SecurityName)

i need 1 to be selected on click of button.

I tried using select in field but unable to get the answer.

Any helpful ideas?

Thanks in Advance,

Venkata

alexandros17 — Wed, 25 Jun 2014 15:17:57 GMT

Use this function:

=GetSelectedCount(MyField)

let me know

venkatg6759 — Wed, 25 Jun 2014 15:23:14 GMT

That doesn't work!

i need number, individual security to be selected

suppose if count gives you 1,2,3,4

i need 1 to be selected from the count .

Wed, 25 Jun 2014 15:24:23 GMT

Try:

If(GetSelectedCount(SecurityName) = 1, aggr(Count([Security Name]), [% GUID]))

alexandros17 — Wed, 25 Jun 2014 15:27:09 GMT

=If(GetSelectedCount(SecurityName)=1, SecurityName)

venkatg6759 — Wed, 25 Jun 2014 15:30:02 GMT

I tried but it doesn't ,

I created a listbox expression by

aggr(Count([Security Name]), [% GUID]))

which gave me 1 ,2,3 .........

i don't want to go that list box and select 1 ,instead i want to click the button and select 1