I would like to know how to calculate a repeated number in a column. For example:
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.
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.
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 ?
Are you using personal edition?
if so, please try like this
Dimension : 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