Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

List box values selection query

Hi All,

I have a dimension having age group. I has multiple values say 18-49,50-64,65+,overall.

Now if a select overall from listbox or in the pivot table i should not be allowed to select 18-49,50-64,65+.

if i select 18-49 i should be able to select 50-64,65+. Age Group IN (’18-49’, ‘Overall’) is invalid

Thanks in advance for the help.


2 Replies

It is usually unnecessary and even inadvisable to do this in QV. Selecting nothing is equivalent to 'overall' (with the possible exception of null values), and you can select all possible values easily by clicking on the list box and typing *.

The logic that you propose could potentially confuse the user - lets say they select overall, and then want to drill into 18-49. The selection will be ignored. In addition, you will need a triggers and macros to do this, adding  to the complexity without adding to the value.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

This is as per the requirement.