Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to calculate a repeated number ?

I would like to know how to calculate a repeated number in a column. For example:

Column      A

                 5

                 5

                 5

                 5

                 5

                 7

                 5

                 5

                 9

                 5

                 5

                 3

                 5

                 5

Just by looking in this case it is easy to tell that "number 5" is the most repeated number in "column A". How can I calculate that using Qlikview ? I would like to know the top ten repeated numbers in a column.

6 Replies
Gysbert_Wassenaar

Create a straight table chart with A as dimension and count(A) as expression. If you're using QV11 you can set the dimension limit to 10 largest so the table show the top 10.


talk is cheap, supply exceeds demand
Not applicable
Author

Nope, didn't work.

Gysbert_Wassenaar

It does for me. See attached example.


talk is cheap, supply exceeds demand
Not applicable
Author

File didn't open 😞

In fact I want to calculate the most repeated number in 4 clumns in a same row. The "count" expression didn't work for me .

I'm a beginner at Qlikview,maybe I am doing some stupid mistake 😞

I have read and practiced the whole Free Tutorial from Qliktech, I did everything just fine. But now I am having trouble with a simple operation 😞

I am studying the Brazilian Lotto in Qlikview, that's why I need to know the most repeated numbers in a column. Which is the best object for me to check this information ?

MayilVahanan

HI

PFA

Are you using personal edition?

if so, please try like this

Dimension : A

Exp: Count(A)

Dimensional limit :

Select Limit check box:

Show only option:

Largest in drop down, value : 10

Mr.Gysbert Wassenaar mention like this only

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Thanks a lot ! Now it worked !  🙂