Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

How do I count the amount of number of individual references? (See Thread)

I am trying to work out an expression that would count the amount of times a reference appears in a table. An example is shown:

List

HELLO

HELLO

GOODBYE

GOODBYE

GOODBYE

HELLO

GOODBYE

Desired Outcome: Hello: x3    Goodbye: x4

The expressions I have tried are incredibly basic and I'm sure this post may seem borederline stupid for some seasoned devs however I have tried the COUNT and SUM function, as well as the COUNTIF function, but I cannot seem to get the desired outcome.

Thanks and best regards,

Alex BG.

1 Solution

Accepted Solutions
Highlighted

Re: How do I count the amount of number of individual references? (See Thread)

You need this in a text box object or table? For table, you can try this

Dimension

List

Expression

Count(List)

For Text Box, you are try this

=Concat(Aggr(List & ': x' & Count(List), List), Chr(10))

Capture.PNG

View solution in original post

5 Replies
Highlighted

Re: How do I count the amount of number of individual references? (See Thread)

1.Add list as dimension

2.Expression

Count(List)

This should work

Highlighted

Re: How do I count the amount of number of individual references? (See Thread)

You need this in a text box object or table? For table, you can try this

Dimension

List

Expression

Count(List)

For Text Box, you are try this

=Concat(Aggr(List & ': x' & Count(List), List), Chr(10))

Capture.PNG

View solution in original post

Highlighted
Contributor III
Contributor III

Re: How do I count the amount of number of individual references?  (See Thread)

Hi Sunny,

Thank you very much for your feedback!

This worked fine!

Best regards,

Alex.

Highlighted
Contributor III
Contributor III

Re: How do I count the amount of number of individual references?  (See Thread)

Thanks Avinash

Best regards,

Alex.

Highlighted

Re: How do I count the amount of number of individual references?  (See Thread)

Mark the helpful and correct answers and close this thread