topic Re: Dynamically hiding values of a Listbox in QlikView

Dynamically hiding values of a Listbox

googel84 — Thu, 27 Mar 2014 12:23:33 GMT

Hi community, I have got a problem with a listbox.

This listbox (Indicators) normally shows values loaded from an in line table and is used to dynamically select which measure to show in a pivot.

Now the requirement is to restrict its values based on the selection made on an other listbox (Company). The logic is something like:

if Company = 'COMPANY1' then

show all indicators in Indicators

else

show only a few of them

I tried a number of expressions (both based on aggr and on if) but none of them did the job.

Thanks in advance for any help.

Re: Dynamically hiding values of a Listbox

sudeepkm — Thu, 27 Mar 2014 12:35:49 GMT

Can you please post sample qvw?

Re: Dynamically hiding values of a Listbox

simsondevadoss — Thu, 27 Mar 2014 12:42:21 GMT

=Aggr(Only( {< field_name = p(field_name ) >}field_name ),field_name )

Try this.

Re: Dynamically hiding values of a Listbox

googel84 — Thu, 27 Mar 2014 13:08:16 GMT

Thanks for your time.

Your formula actually did not do the job but it made me think that I should have linked Indicators and Company, so I added a new inline table and this was sufficient to achieve the goal (even though, I have to say, without your formula, I still see the excluded values, but it is fair enough to me).

Thanks again