Discussion board where members can get started with QlikView.
I am trying to count distinct number of events per year based on a date, but there is a problem when it is used the regular count ( Distinct "dimension") in expression chart.
Below is the fact table:
So, in this case, when I use the expression Count ( distinct ID), having the dimension year(Date) and Event, the result is:
A = 1
B = 1
C = 1
But the desirable result is:
A = 2
B = 2
Does anyone have an idea of what can be done?
Thanks in advance.
Try count(distinct Date) as expression with ID as dimension
Dim = ID
Exp1 = count(aggr( ID,Date))
I forgot to include that the result will be shown in a chart like this: