topic Re: Selection from listbox in QlikView

Selection from listbox

QSense — Wed, 28 Nov 2012 18:54:44 GMT

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

Re: Selection from listbox

Gysbert_Wassenaar — Wed, 28 Nov 2012 19:25:56 GMT

See updated attached example.

Re: Selection from listbox

QSense — Wed, 28 Nov 2012 19:47:20 GMT

As I said in other discussion

It does not get field's values

Re: Selection from listbox

QSense — Thu, 29 Nov 2012 13:10:28 GMT

Hi Gysbert ,

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

What would you offer

These are non technical skills

Re: Selection from listbox

Gysbert_Wassenaar — Sat, 01 Dec 2012 20:02:15 GMT

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.

Re: Selection from listbox

QSense — Mon, 03 Dec 2012 09:01:11 GMT

Thanks a lot