Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Create a straight table
DImension
Customer
Expression
COUNT({<Type = {'Order'}>}Type)
Create a straight table
DImension
Customer
Expression
COUNT({<Type = {'Order'}>}Type)
Thank you so much!