get selected count for the multiple selectors in the list box

[venkat1]

Hi friends,

i have a category list box  with values G,P,C,D...  in it

By selecting either G,P fields from the list box another list box should visible , 

i had used this condition in the another list box  =GetFieldSelections(CATEGORY)='D' in the layout , where it was working fine  for the G selection , now i want use for the P also.

how to write an expression for it ?

[Vegar]

Try this in your list box conditional show:

SubStringCount( Concat( DISTINCT '|' & CATEGORY & '|'), '|G|') = 1

and this

SubStringCount( Concat( DISTINCT '|' & CATEGORY & '|'), '|P|') = 1

BR
Vegar

[venkat1]

thanks for the reply , i tried and it was not working .

[Vegar]

What happens if you put this expression into a textbox and then select the category P? What happens if you select P and D?

SubStringCount( Concat( DISTINCT '|' & CATEGORY & '|'), '|P|') 

[venkat1]

can you please show how to do this i had attached qvw file

my scenario was,if i select A,B,C,D,G  or only A then quarter should display .

[Vegar · Accepted solution]

[venkat1]

but without no selections in the category list box then quarter list box should be disabled , but here it was not  like that .

[Vegar · Accepted solution]

Adjust the conditional show to this:

SubStringCount( Concat( DISTINCT '|' & Categoty & '|'), '|A|') *AND*
*GetSelectedCount (Categoty) > 0*