Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Error in count registers

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.

1 Solution

Accepted Solutions
jonbrough
Valued Contributor

Re: Error in count registers

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

Jonathan

2 Replies
jonbrough
Valued Contributor

Re: Error in count registers

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

Jonathan

Not applicable

Re: Error in count registers

Thank you very much. All ok.

Community Browser