Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

Column analysis - hard limit of 10 on number of rows output

I'm running a pattern analysis - I want to discover all distinct patterns in a particular column in my dataset. The dataset has over 130,000 rows. Running manually coded SQL, I can see that the column data exhibits 118 distinct patterns. Running the column analysis in Data Studio only shows 10 result rows - 10 distinct patterns.
How can I get down to all of the discernible patterns? Adjusting the "First n rows" limit from 50 to 999 doesn't seem to affect anything. Being able to assess all of the data in my application is key to my choice of TOS for my DQ purposes. Showing only 10 results out of a possible 118 isn't useful.
Thanks for any help that you can offer,

Phil
Labels (2)
3 Replies
Sebastiao_Qlik
Employee
Employee

Hi Phil,

there are options in the indicator to display more than the top 10 patterns. Double click on the indicator.
There is also an indicator to show the bottom 10 patterns. That's useful for finding erroneous patterns (which usually don't appear often).
_AnonymousUser
Specialist III
Specialist III
Author

Hi  scorreia,


My apologies, but I searched long and hard for such a setting before posting to ask for help. I have done as you asked, but I cannot see any such setting, either related to a built-in indicator or to the UDI that I built to further investigate this issue.
Please could you clarify further,perhaps by supplying a screenshot?

Many thanks,

Phil

PS Every time I log in with my registered username and then try to post, the forum software loses my log-in and won't allow me to enter my username in this dialog
_AnonymousUser
Specialist III
Specialist III
Author

It took me a while to correctly interpret your answer. Now that I've done so, I have what I need. Apologies - now resolved. 

Thank you for taking the trouble to answer my initial question.

Phil (aka "barikman" - my Talend username)