Discussion Board for collaboration on QlikView Layout & Visualizations.
I have 33 columns that names are
and they includes such values 'G','VG','S'
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
Go to Solution.
See updated attached example.
As I said in other discussion
It does not get field's values
Hi Gysbert ,
if my columns name were A1,A2,A3,A4
What would you offer
These are non technical skills
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.
Thanks a lot