Error in count registers

Mon, 24 Jun 2013 21:15:09 GMT

Hi. please help me with this problem. I have this organization.

Manager

Seller 1

Customer 1.1

Order 1.1.1

Order 1.1.2

Order 1.1.n

Customer 1.2

Order 1.2.1

Order 1.2.2

Order 1.2.n

Customer 1.n

Order 1.n.1

Order 1.n.2

Order 1.n.n

Seller 2

Customer 2.1

Order 2.1.1

Order 2.1.2

Order 2.1.n

Customer 2.2

Order 2.2.1

Order 2.2.2

Order 2.2.n

Customer 2.n

Order 2.n.1

Order 2.n.2

Order 2.n.n

Seller n

Customer n.1

Order n.1.1

Order n.1.2

Order n.1.n

Customer n.2

Order n.2.1

Order n.2.2

Order n.2.n

Customer n.n

Order n.n.1

Order n.n.2

Order n.n.n

Each Customer has data for State, City and a CustomerCode too.

The CUSTOMERS have (1 to n) orders, if the time in days between the last 2 orders in greater than 15 days, I must count the Customer (called Recovered). The format output format must be:

Manager - Seller - State - City - Recovered

But Recovered don't works, only works when I use this output format:

Manager - Seller - State - City - CustomerCode - Recovered

Please check the attachment.

Thanks for your help.

Re: Error in count registers

Anonymous — Tue, 25 Jun 2013 07:45:43 GMT

Please find attached. Using Aggr() functions you can resolve the max calulations at the CustomerCode level of granularity.

Jonathan

Re: Error in count registers

Tue, 25 Jun 2013 16:37:51 GMT

Thank you very much. All ok.

topic Re: Error in count registers in QlikView

Error in count registers

Re: Error in count registers

Re: Error in count registers