Use set analysis to link table values

[p_verkooijen]

In creating a new chart based on an existing application, I've made a small version to explain my problem.I want to show the stock by store in a table where the store info is not directly linked to the stock info (See attached jpg and qvw). But I just can't manage to display the corresponding stock_quantity. In the example i've tried this definition : sum ({<stock_store = {$(=only($(store))) }>} stock_quantity) .

[chriscammers]

You are using Dollar sign expansion where you should just provide a field.

Try This: Note I eliminated dollar sign expansion on $(store)

Sum({<stock_store = {$(=only([store]))}>}

[p_verkooijen]

Hi chris Changed the definition but still all values stay 0