Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can Any one one help, its a bit urgent

hi, in my excel there is huge amount of data, in that i want to select only few rows and upload it in the QV, i tried uploading the excel but i have to deleted all the others rows by using delete function and is there any way that i upload only specific range in the excel, any help will be appreciated

4 Replies
vijay_iitkgp
Partner - Specialist
Partner - Specialist

Hi,

Can you please clarify more what exactly you need.

If you want rows on certain condition then you can use where clause .

Regards

Vijay

Not applicable
Author

Actually in my sheet i have data till 233 rows and i need to upload only last 10 rows, if i delete rows the code is becoming vary large, so what i want is instit of deleting all the rows i want to select particular range, example (D242:I246)

raghavsurya
Partner - Specialist
Partner - Specialist

Hi Mohammed,

Put a flag against those line items as "Y" in excel and give a condition in your script to pick those lines alone.

Regards,

Raghav

Not applicable
Author

Thanks you ur reply, that a good idea, but i have many charts so each data set i have insert flag that will be a problem,