Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

QSense
Contributor II

Selection from listbox

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

1 Solution

Accepted Solutions

Re: Selection from listbox

See updated attached example.


talk is cheap, supply exceeds demand
5 Replies

Re: Selection from listbox

See updated attached example.


talk is cheap, supply exceeds demand
QSense
Contributor II

Re: Selection from listbox

As I said in other discussion

It does not get field's values

QSense
Contributor II

Re: Selection from listbox

Hi Gysbert ,

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

What would you offer

These are non technical skills

Re: Selection from listbox

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.


talk is cheap, supply exceeds demand
QSense
Contributor II

Re: Selection from listbox

Thanks a lot

Community Browser