Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Nope, didn't work.
It does for me. See attached example.
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 ?
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 a lot ! Now it worked ! 🙂