Help - Inquiry Amount per last date

Mon, 29 May 2017 16:16:04 GMT

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.

Re: Help - Inquiry Amount per last date

felipedl — Mon, 29 May 2017 19:23:04 GMT

Hi Martin,

I made a QVW with the table you have posted.

Regards,

Felipe.

topic Re: Help - Inquiry Amount per last date in QlikView

Help - Inquiry Amount per last date

Re: Help - Inquiry Amount per last date