topic Re: How to show only relevant fields in list boxes ? in QlikView

How to show only relevant fields in list boxes ?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have two list boxes - PeriodType and PeriodKey. I would like to show only relevant list in the PeriodKey listbox based on the PeriodType selection.

In the below example, I have selected 'Year' as my period type. I want to list only the white coloured items in the PeriodKey listbox ?

I used the below expression for the PeriodKey list box. But it still showing the grey items.

=aggr(only({<PeriodKey=P(PeriodKey)>}PeriodKey),PeriodKey)

Appreciate any thoughts on this one.

Thank you

Re: How to show only relevant fields in list boxes ?

ahaahaaha — Sat, 25 Feb 2017 16:50:11 GMT

Hi,

Set "Hide Excluded" flag in the list of properties solve your problem?

Regards,

Andrey

Re: How to show only relevant fields in list boxes ?

Anonymous — Sat, 25 Feb 2017 17:07:45 GMT

Hi ahaahaaha,

Thanks for the reply. The problem with 'Hide excluded' option is as soon as I select one of the option in the PeriodKey list box, only the selected value shows in the list box. Other possible values are hidden.

I would like to see the possible values as well. Any other thoughts?

Thank you,

Re: How to show only relevant fields in list boxes ?

marcus_sommer — Sat, 25 Feb 2017 17:26:39 GMT

You could use for this an listbox-expression like the following one:

aggr(PeroidKey, PeroidKey)

- Marcus