Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
Specialist

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
effinty2112
Master
Master

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
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
sunny_talwar

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

effinty2112
Master
Master

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