# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Highlighted
Valued Contributor

## how to use the counting function to see the times they re repeated?

How the counting function is used? Data looks like below.

ref_Number               Value

Raccc125                  500

Raccc125                 500

Raccc126                  300

Raccc127                  250

Raccc128                  150

1 Solution

Accepted Solutions
Highlighted
Honored Contributor

## Re: how to use the counting function to see the times they re repeated?

Hi,

try this straight table with dimension ref_Number:

ref_Number count(ref_Number)-1
Raccc1251

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.

ref_Number Value count(ref_Number)-1
Raccc1255001

Cheers

Andrew

3 Replies
Highlighted
MVP & Luminary

## Re: how to use the counting function to see the times they re repeated?

Hi,

You can use the count() function to count a value in a field.

Like

Count(Ref_Number) this will count all values (Not the distinct)

For distinct count

Count(Distinct Ref_Number)

Regards,

Kaushik Solanki

Regards,
Kaushik
Highlighted
MVP

## Re: how to use the counting function to see the times they re repeated?

What is they here? ref_Number repetitions or ref_Number and Value repetitions?

Highlighted
Honored Contributor

## Re: how to use the counting function to see the times they re repeated?

Hi,

try this straight table with dimension ref_Number:

ref_Number count(ref_Number)-1
Raccc1251

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.

ref_Number Value count(ref_Number)-1
Raccc1255001

Cheers

Andrew