GetSelectedCount() workaround for alternate states

Thu, 08 May 2014 20:36:11 GMT

I have a trigger that does a "Select in Field" based on another field using Search String:

= if ( GetSelectedCount( blob ) = 0, '', blob)

This meet my requirements were selections are copied if:

1) a single value is selected

2) multiple values are selected

3) no values are selected

So, now I introduce states and I am not longer able to use GetSelectedCount() and must use other function in order to specify the State. So, I currently have:

= '(' & Concat( {StateA}blob, '|' ) & ')'

This meets the first two requirements (single and multiple selections) but if no values are selected it ends up selecting all of them. I was working on doing something like below, but none of these worked:

= if ( '(' & Concat( {StateA}blob, '|' ) & ')' = '()', // if the concat function returns nothing

'', // select nothing

'(' & Concat( {StateA}blob, '|' ) & ')' ) // else select the selections

So, what does Concat return when nothing is set for {StateA} blob???

Re: GetSelectedCount() workaround for alternate states

Thu, 08 May 2014 21:19:29 GMT

This does it:

= if ( Concat({StateA} GetFieldSelections(blob)) = '' ,

'',

'(' & Concat( {StateA}blob, '|' ) & ')' )

topic Re: GetSelectedCount() workaround for alternate states in QlikView

GetSelectedCount() workaround for alternate states

Re: GetSelectedCount() workaround for alternate states