topic Count in QlikView in QlikView

Count in QlikView

Anonymous — Fri, 22 Aug 2014 15:51:57 GMT

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 — Fri, 22 Aug 2014 15:55:06 GMT

Create a straight table

DImension

Customer

Expression

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

Anonymous — Fri, 22 Aug 2014 19:15:15 GMT

Thank you so much!