Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Count in QlikView

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.

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Create a straight table

DImension

Customer


Expression

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

View solution in original post

2 Replies
MK_QSL
MVP
MVP

Create a straight table

DImension

Customer


Expression

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

Anonymous
Not applicable
Author

Thank you so much!