topic Re: Sum IF with Distinct in QlikView

Sum IF with Distinct

Fri, 11 Dec 2015 21:16:35 GMT

I have the following columns of data:

1) Customer_ID

2) Service_Date

3) Service_Count

4) Location_Code

5) Service_ID

I need to add the Service_Count for Customer_IDs with DISTINCT Customer_ID & Service_Date, IF the Location_Code is 23.

How can I write an expression for this?

I originally had

Sum( If( Location_Code = '23', Service_Count, ))

Obviously this is incorrect, but did not know how to add the DISTINCT clause.

Any help is greatly appreciated.

sunny_talwar — Fri, 11 Dec 2015 21:36:05 GMT

May be try this:

Sum({<Location_Code = {23}>} Aggr(Sum(DISTINCT {<Location_Code = {23}>} Service_Count), Customer_ID, Service_Date))

Fri, 11 Dec 2015 21:42:08 GMT

THank you, this worked perfectly.

sunny_talwar — Fri, 11 Dec 2015 22:42:15 GMT

Awesome