topic Re: Getselectedcount listbox with calculated values in QlikView

Getselectedcount listbox with calculated values

curiousfellow — Wed, 11 Oct 2017 08:28:35 GMT

I created a listbox with calculated values, this listbox is connected to an alternate state.

For a chart I want force that one item from that listbox is chosen.

How do I refer to this listbox in the function getselectedcount() ?

Anil_Babu_Samineni — Wed, 11 Oct 2017 09:40:45 GMT

Not sure, I understand your rek. But, Normally it can be done like below

If(GetSelectedCount(FieldName) = 1, Only({AlterNateState<......>} FieldName1)

curiousfellow — Wed, 11 Oct 2017 11:36:06 GMT

The problem is that there is no fieldname, Because it is a calculated value.

For instance : if(Right(fieldname,2)=3, left(fieldname,4))

sunny_talwar — Wed, 11 Oct 2017 11:41:37 GMT

May be this

=GetSelectedCount(fieldname, False(), 'AS') = 1

sunny_talwar — Wed, 11 Oct 2017 11:42:17 GMT

Or this

Count({AS}DISTINCT if(Right(fieldname,2)=3, left(fieldname,4))) = 1

Anil_Babu_Samineni — Wed, 11 Oct 2017 11:46:13 GMT

Means,, You don't have Field using the same in script.. If so, Create one field in script for that and then use as i mentioned

curiousfellow — Wed, 11 Oct 2017 13:36:11 GMT

Thank you. This works