Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get count of similar values from multiple columns?

Hi,

Scenario

customers may place more then 1 order in a day for same products


Question

I want to know the count of those orders which contains same product and same customer name and same date.

Data Model (is not normalised) contains following fields :

  • OrderID
  • CustomerID
  • ProductID
  • OrderDate

I hope I have explained the scenario properly.

Thanks

2 Replies
Digvijay_Singh

Not sure though, may be like this -

Dimension - Date, Customer Name, Product

Expression - If(Count(OrderID>1,Count(OrderID))

Not applicable
Author

Thanks.. I will update you on how it goes.