Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Can you please post sample qvw?
=Aggr(Only( {< field_name = p(field_name ) >}field_name ),field_name )
Try this.
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