Loop to Rows and update the field value

[erric3210]

Hi All,

I'm trying to get the solution for one of my requirement.

I've tried with loops, peek, previous, iterno, if conditions but not geeting the result.

I've prepared the sample data.

Please let me know if this is possible in qlikview/qliksense or not.

Use this Data:

Remarks
Entry: 7 6 Cars, 1 faulty oil filter
10010/AUD-PHIZXG54
6
10061.2
Order to Warehouse
6 Audi
4
10061.2
Warehouse to Showroom
4 Audi
2
10061.1
Showroom to delivery
2 Audi

@sunny_talwar @Peter_Cammaert @swuehl

Regards,

Eric

[erric3210]

Did any one have ever work on such requirement.

[Kushal_Chawda]

@erric3210  how did you arrive at 10062 for first two records?

[erric3210]

Hi Kush,

It's the tracker under which this record is entered. Basically, it's the Round of 10061.2

Regards,

Eric

[Kushal_Chawda]

@erric3210  logic is quite not clear..

[erric3210]

Hi Kush,

I'm tracking the occurrences of the event. For every event, there comes a new number.

I've added more line items in the data & line items to provide more clarity. For each event, there is an event occurrence number from which we are tracking the Cars. so, 10062.2 falls under 10062 category and 10061.2 falls under 10061 category. Hope I'm clear this time.

Remarks
Entry: 10 8 Cars, 2 break-down
10060/AUD-PHIFYK86
8
10062.2
Ship to Location
8 Audi
5
10062.2
Location to Site
5 Audi
3
10062.1
Site to Storage
3 Audi
Entry: 7 6 Cars, 1 faulty oil filter
10010/AUD-PHIZXG54
6
10061.2
Order to Warehouse
6 Audi
4
10061.2
Warehouse to Showroom
4 Audi
2
10061.1
Showroom to delivery
2 Audi

Regards,

Eric