topic Re: Use set analysis to link table values in QlikView

Use set analysis to link table values

p_verkooijen — Fri, 21 Oct 2011 14:34:35 GMT

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) .

Re: Use set analysis to link table values

chriscammers — Fri, 21 Oct 2011 15:38:53 GMT

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]))}>}

Re: Use set analysis to link table values

p_verkooijen — Fri, 21 Oct 2011 16:36:08 GMT

Hi chris Changed the definition but still all values stay 0