Hi Qlikview community,
I am new to Qlikview and I have 2 questions:
1. I have Table, Transfer that contains the quantity transferred between factories.
The source factory has a CODUSN and the Destination factory has code CODUSNSRC_DST. These two field are in the same table in addirion to the quantity transferred.
The code Qlikview I wrote, but I'am not sure if it is correct:
CODUSN AS CODUSNSRC_DST,
CODREG AS CODREGTRANSF,
SIGUSN AS LIB_USNSRCDST
My question is, is this coorect?
2. I want to display the quantity transferred between the regions using a third table named REGION as follow:
SIGREG AS SIGREGTRANSF
But the result is not correct. It shows me only the transfers Inside each region and not between the regions.
Attached the result of the pivot table.
Thank you very much in advance,
what is your table structure ?
to be able to see the Quantity movement between regions, you must have something like this (as data strcuture):
Quantity | the region from which comes the quantity | the region to which the quantity is going
The Table containing the quantity doesn't has source/destination régions but only source/destination factories (CODUSN and CODUSNSRC_DST). The factory code is connected to the region in the Table REGION.
- So I have factory Table connected at the same time to the region table and to the table containing the quantity of the transfert.
- I am trying to display the transfers between region in pivot Table (one dimention region source and the other one destination region.
No problem, if your table have the source/destination factories and the factories are connected to the regions, just put the source region and destination region as dimensions and the Quantity as a Measure.
try to attach sample data or sample app to take a look at the data structure
Thank you I fixed the problem.
I duplicated the factory and the region tables and renamed their fields names for the destination (destination factory table and destination region table).
Thank you very much.
Thanks to all.