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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to restrict the number of rows that are exported to excel from a table?

Hi

I need to restrict the number of rows while exporting the table into an excel sheet. Is there a function or document setting that will help me achieve? appreciate your assistance on it.

15 Replies
Anonymous
Not applicable
Author

Attaching the screenshot after i click on the custome cell format. I dont get any option to modify the rows count

Anonymous
Not applicable
Author

After clicking on custom cell format i dont get further options to modify the row count. Its only for adding borders.

Anonymous
Not applicable
Author

This doesn't seem to work. When I put the condition to count my tickets to be lesser than 1000 the table becomes blank

settu_periasamy
Master III
Master III

Hi,

Sample Attached.

You need give the proper field name within the count

Anonymous
Not applicable
Author

Hi.. I am using personal edition so will not be able to open the qvw file. will it be possible to share the script or sceenshots of the file

settu_periasamy
Master III
Master III

Can you share the sample?