Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
sanjyotpatkar
Creator III
Creator III

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
MindaugasBacius
Partner
Partner

How do you exporting data to excel via macro function or by just Send to excel functionality?

Please come up with more detailed description.

sanjyotpatkar
Creator III
Creator III
Author

I am using Send to Excel functionality

MindaugasBacius
Partner
Partner

Well than you need just to prepare the straight or pivot table whatever you're exporting to that you wish to see in excel.

ajsjoshua
Specialist
Specialist

sanjyotpatkar
Creator III
Creator III
Author

where does the 'Keep Source Format' box appear after i right click on the properties of the table box in QV?

MindaugasBacius
Partner
Partner

Screenshot_1.jpg

sanjyotpatkar
Creator III
Creator III
Author

By Converting it to Straight table i can maintain a limit of only 100 rows but I need to export around 1000 rows only

ajsjoshua
Specialist
Specialist

Hi,

Select View -> View-Grid View  ->  right click your straight table select -> Custom Format Cell

and format as per your requirement


settu_periasamy

May be you can try with 'calculated Conditon' in the Table Box -> General Tab..

like

=count(ID)<100

Then apply the error message 'More than 100 Lines'

Capture.JPG