Relations between two tables with parameters from another table

[Anonymous]

Hello!

in the table Movement I have IdUbicacionConsumo and IdUbicacionEntrega. Now, from the table Product I have to make a conditional from the field %KEY_product_type: if the value is 1 or 3 then from the table Movement the field IdUbicacionConsumo has to be linked to %KEY_location. Then if %KEY_product_type is different from 1 or 3, IdUbicacionEntrega has to be linked to %KEY_location.

I attach an image.

Is very very urgent!!!

Thanks a lot!!!

[Oleg_Troyansky]

create a new field and assign the value to it conditionally: if product category is 1 or 3, then assign one key value to the new key, otherwise assign the other value to the key.

Since your condition depends on a field from a different table, you need to use a MAP and the ApplyMap() function to fetch the Product Category.

[Anonymous]

Thanks we solved it with this instructions:

http://community.qlik.com/message/215704#215704