Dear:
Good day. I'm having a problem getting a result in QlikView.
Basically I have a table with the naphtha cargo records of cars from different branches. According to the passage of time, a car can change branches.
I need to generate a list with the number of mobiles that there is per branch taking into account the branch that had the cell in the last date of load.
For example, if the mobile "A" charged on 10/11/2015 naphtha and at that time said mobile corresponded to BRANCH B
Then on 12/12/2015 the mobile "A" cargo naphtha again and corresponds to the SUCURSAL C.
If I want to know how many mobiles there are for branch C, I should allocate a unit to branch C in this case.
I attach an excel file that has two flaps. The first tab is the database and in the second, the result I want to get.
