Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

how to select few column names from a Listbox

I have table A (person, address, state, country) and my listbox can display those column names if I use $field.

But I would only like to display Person and Address and exclude the others.

Was wondering how do I write the expression in the Conditional display:

>>> if not wildmatch($field,'State') and not wildmatch($field,'country'), $field)

and once I am able to achieve the above:

how can I chart it (pass the field selected as a dimension)

its just a bar chart with $field against Count(..)

Would really appreciate your input.

Thanks.

Community Browser