topic Source and Destination Movement in QlikView

Source and Destination Movement

Wed, 15 May 2013 14:39:39 GMT

Hi community!!!!

Considering that I have to model movements between two Factories and that each Factory can be the source or destination of the movements, I built the following model, using a Link table that indentifies the Source and Destination of the Movement:

Now I am facing some difficulties building a table like:

I am using a Pivot Tabble with two dimensions and one expression:

1. Destination - Calculated dimension using: if ( MovType = 'Destination', Name )

2. Value - sum (value)

The question is how do build the second dimension (Source) using a calculated expression, because I have the Souce Factory name in the same table as Destination Factory?

Many thanks,

João

Re: Source and Destination Movement

jvitantonio — Wed, 15 May 2013 16:50:10 GMT

Hi, please check the file attached.

Re: Source and Destination Movement

Wed, 15 May 2013 17:54:12 GMT

Hello qlikuser14,

Thanks for your reply. Unfortunately the example you sent does not answer our problem. We need to generate a table similar to what we posted initially, a column for Destination and another one for the Source that adds all the values between them (the aggregate value). Thanks again !