Selection from listbox

[QSense]

Hello ,

I have 33 columns that names are

One,Two,three...................thirtythree

and they includes such values 'G','VG','S'

for example

One          Two           Threee

G               S                 G  

G               VG               G

VG             G                 VG

I want to do a listvox in order to select one of 33 columns

and in chart sum values of 'G','VG','S'

For example When I selected 32 , I want to see total count of 'VG' values in chart

[Gysbert_Wassenaar · Accepted solution]

See updated attached example.

[QSense]

As I said in other discussion

It does not get field's values

[QSense]

Hi Gysbert ,

if my columns name were A1,A2,A3,A4

What would you offer

These are non technical skills

[Gysbert_Wassenaar]

Copy the listbox for Technical Skills and change the expression to:

=if(len([$Field])=2 and IsText(left([$Field],1)) and IsNum(right([$Field],1)) ,[$Field])

If you want to show the technical and non-technical skills independently from each other you'll have to use alternate states (not available in QV10). See attached example.

[QSense]

Thanks a lot