topic Relations between two tables with parameters from another table in QlikView

Relations between two tables with parameters from another table

Anonymous — Wed, 02 May 2012 20:53:52 GMT

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!!!

Relations between two tables with parameters from another table

Oleg_Troyansky — Thu, 03 May 2012 04:43:26 GMT

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.

Relations between two tables with parameters from another table

Anonymous — Fri, 04 May 2012 14:28:35 GMT

Thanks we solved it with this instructions:

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