Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
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

View solution in original post

3 Replies
Highlighted
MVP & Luminary
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
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted

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

View solution in original post