This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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: