Discussion Board for collaboration related to QlikView App Development.
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() ?
Or this
Count({AS}DISTINCT if(Right(fieldname,2)=3, left(fieldname,4))) = 1
Not sure, I understand your rek. But, Normally it can be done like below
If(GetSelectedCount(FieldName) = 1, Only({AlterNateState<......>} FieldName1)
The problem is that there is no fieldname, Because it is a calculated value.
For instance : if(Right(fieldname,2)=3, left(fieldname,4))
May be this
=GetSelectedCount(fieldname, False(), 'AS') = 1
Or this
Count({AS}DISTINCT if(Right(fieldname,2)=3, left(fieldname,4))) = 1
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
Thank you. This works