Discussion board where members can get started with QlikView.
How the counting function is used? Data looks like below.
try this straight table with dimension ref_Number:
This shows that the only ref_Number that repeated was Raccc125 which repeated once.
To see how many repeats of ref_Number and Value add Value as a dimension. Normally Values we treat as the basis for an expression but in this case it makes sense to treat as a dimension.
View solution in original post
You can use the count() function to count a value in a field.
Count(Ref_Number) this will count all values (Not the distinct)
For distinct count
What is they here? ref_Number repetitions or ref_Number and Value repetitions?