topic Re: Group orders by customers order count in QlikView

Group orders by customers order count

Wed, 19 Sep 2012 11:16:55 GMT

I have a table with orders which contains OrderDate, OrderNumber and CustomerNr

I want a chart similar to the image. The first column should group customers order count. Meaning the first row, 1, should show every customers first order. 2 should show only "2nd orders".

The expression i have used so far, as a dimension, is: Aggr(RowNo(), CustomerNr, OrderDate)

However, I cant get it right. As you see, the order isnt correct if you look at the dates. Customer 001015534 have made two orders. The order made 2010-12-10 should be the 1st and the order 2012-05-24 the 2nd. Now its the other way around.

How can I fix this? Is it better to solve in the script and how?

Thanks

Re: Group orders by customers order count

whiteline — Wed, 19 Sep 2012 11:25:19 GMT

Hi.

I guess that Aggr() function uses LoadOrder for sorting.

Try to order your data by OrderDate in script.

Re: Group orders by customers order count

Wed, 19 Sep 2012 11:42:52 GMT

Hi whiteline

I tried this but still the same results.

Re: Group orders by customers order count

Thu, 20 Sep 2012 07:12:01 GMT

Any way to solve this in the script instead?