Dynamically hiding values of a Listbox

[googel84]

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.

[sudeepkm]

Can you please post sample qvw?

[simsondevadoss]

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

Try this.

[googel84 · Accepted solution]

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