Limit rows in Visual but need to export all records in Excel Qlik sense

[UserID2626]

Hi,

My question is suppose i have 3 lakhs records in straight table, i need to show only 1 lakh record in qlik dashboard.

Limitation of records is possible with dimension limits or condition calculation.

Even it shows only 1 lakh record in visual while exporting need to export all 3 lakhs.

Is it possible in Qlik sense?

How to acheive this!!!!