Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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
Honored Contributor III

Re: How to get count of similar values from multiple columns?

Not sure though, may be like this -

Dimension - Date, Customer Name, Product

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

Not applicable

Re: How to get count of similar values from multiple columns?

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