topic Re: List box values selection query in QlikView

List box values selection query

Fri, 20 Nov 2020 18:02:30 GMT

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.

Khushboo

Re: List box values selection query

jonathandienst — Fri, 03 Jul 2015 06:27:04 GMT

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.

Re: List box values selection query

Fri, 03 Jul 2015 07:01:02 GMT

This is as per the requirement.