topic Counting order rows in QlikView

Counting order rows

Thu, 16 Dec 2010 13:39:31 GMT

Hi.

I need to know how many orderlines is in one order.

I have a table with orderlines. and need to know on each line how many lines there is in total in that order. regardless if just one orderline is selected.

My table has theese fields:

ordernumber, orderline number, totalorderfreight, linesum, quantity, etc.

I tried to aggregate over ordernumber and count ordernumber, but that does not work.

( aggr(count(orderline), ordernr) )

any ideas?

Counting order rows

Thu, 16 Dec 2010 14:22:44 GMT

Hi. Try this:

count(all <OrderNo> OrderLine)

It will not be affected from a selection of a single order line. (However, it will be affected from the selection of an Order No, and will show of the number of rows of the selected Order)

Bye,

Montal.

Counting order rows

Thu, 16 Dec 2010 15:02:59 GMT

Try this

count({1<OrderNo = {$(=only(OrderNo))}>} total OrderLine)

Anders