Count in QlikView

[Anonymous]

I a column called customer and a column called type and one with a timestamp.

In the column type there is ether "Order" or "Search"

There can be multiple rows with the same customer number.  I am trying to get a count of how many "Orders" per customers there is.

I am new to QlikView and just new to all of this in general so I have no clue what I need to do.  Please help.

[MK_QSL · Accepted solution]

Create a straight table

DImension

Customer

Expression

COUNT({<Type = {'Order'}>}Type)

[Anonymous]

Thank you so much!