Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

p_verkooijen
Valued Contributor

Use set analysis to link table values

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) .
Tags (1)
2 Replies
chriscammers
Contributor III

Re: Use set analysis to link table values

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
Valued Contributor

Re: Use set analysis to link table values

Hi chris Changed the definition but still all values stay 0

Community Browser