topic Re: Count Distinct per Dimension in QlikView

Count Distinct per Dimension

Tue, 29 Apr 2014 14:09:28 GMT

Hi All,

I have a straight table which has dimensions week day and date. I have an expression "Count(DISTINCT([Grower No.]))", which counts the distinct number of growers in the least.

How do I tweak this expression so that it shows distinct number of growers per date? At the moment it has the same value for each date which is the distinct number of growers in the whole subset.

Thank you

Herbiec

Re: Count Distinct per Dimension

alexandros17 — Tue, 29 Apr 2014 14:10:46 GMT

Count(DISTINCT(Aggr([Grower No.],myDate)))

Re: Count Distinct per Dimension

jonathandienst — Tue, 29 Apr 2014 14:13:10 GMT

The problem most probably lies in your data model, where the date is not properly associated with the table containing Grower No. I suggest that you upload a sample of your model (click 'Use advanced editor' at the top left of the reply entry screen). or at least provide a lot more information about your model.

HTH

Jonathan

Re: Count Distinct per Dimension

tresB — Tue, 29 Apr 2014 14:14:20 GMT

If you use weekday as dim1 and date as dim2, your expression should give you what you want.

Re: Count Distinct per Dimension

Tue, 29 Apr 2014 14:28:10 GMT

Spot on Jonathan,

My associations were a bit of, once I had them realigned, it worked perfectly.

Much appreciated.