Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
January 14th - Discover the Trends Shaping AI in 2026: Register Here!
cancel
Showing results for 
Search instead for 
Did you mean: 
rlmagidson
Contributor
Contributor

How to set number of rows for View Values and View Rows

Hello 
Using TOS_DQ 6.2.1.20160704_1411, on the Analysis Results tab - Simple Statistics.
Right-clicking on a Distinct, Unique, or Duplicate Count and selecting View Values/Rows, only 50 are being returned. The only place I see to set row limits is on the Analysis Settings tab (which effects the preview) and in Window -> Preferences -> Talend (also preview).
My question is where do I set the number to be above 50 in order to view and export all of the Distinct/Unique/Duplicate data?
Many thanks for the help
- Russell
Labels (2)
5 Replies
Anonymous
Not applicable

Hi,
Do you want to increase the number of displayed values in Data Quality analysis?
Best regards
Sabrina
rlmagidson
Contributor
Contributor
Author

Hello Sabrina - I need to view and/or export all of the data, not just 50 rows. I just don't see how to change the value of 50.
Thank you
- Russell
rlmagidson
Contributor
Contributor
Author

I see that there is a difference between using delimited files and sql tables... with the sql table I have a "limit rows" option when viewing data, while no such option exists when viewing data from files.
- rlm
Anonymous
Not applicable

I'm able to change the limit for the number of rows to export and I'm using a delimited file. However, the limit can only be 3 digits, so the max is 999.
You change it on the data preview settings when you first go to run your analysis.
0683p000009MAwY.png
-Matt
Anonymous
Not applicable

Sorry, ignore my last post. That is just for the preview. You can change the amount of rows to export by going into the analysis parameters and changing the 'max number of row kept per indicator'.
0683p000009MBG7.png