[sense] how to get another table field's value to calculate what if?

[Anonymous]

I have 2 tables,

table1 is event and store count

table 2 item, $ sales per store, forecast

My request is, when end user picks an event, the corresponding store count could be passed to table 2 for forecast calculation,

the function is forecast= $ sales per store * store count.

How to do it? qvf and raw excel files attached. thanks.

[Oleg_Troyansky]

In your data model, the two tables are not associated, which is not ideal... Preferably, you'd like to associate your events with the participating stores, etc...

Within your structure, I'd suggest to use the ONLY() function for the store count. This technique, however, requires that one and only one event (or, technically speaking one single store count) is selected in order to enable the calculation. See attached file.

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

[Anonymous]

Thanks. it works. but I found another problem.

The store count in my sample was static, which is fine with your solution.

But in real world, the value is calculated value. I attached a further sample.

In this updated sample, I got error saying bad field name.

Can you help me out again? thanks again.