topic Distint count in QlikView

Distint count

Tue, 03 Apr 2012 11:07:26 GMT

Hi All,

I have following requirement.

I have field name Customer. when I select three month Jan, Feb, Mar I want to list down the customers common in three months and count for the same.

i.e customer common in all selected three month

Distint count

Jason_Michaelides — Tue, 03 Apr 2012 11:12:07 GMT

Just create a listbox for customer which will show the common customers in white when you select the months. To show a count add an expression to the listbox (v10 and later) with COUNT(DISTINCT CustomerID). Bear in mind that Distinct Counts are pretty inefficient so if you have a very large dataset you may notice performance issues.

Hope this helps,

Jason

Distint count

Tue, 03 Apr 2012 11:32:15 GMT

Hi Jason,

I know that but this will give me count off all the customer..

I want count of only common..i.e suppose there is customer A which is present in all selected months.. so my count should be 1 i.e A