Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Tags (1)
4 Replies
vijay_iitkgp
Not applicable

How to select specific range in excel

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

How to select specific range in excel

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
Not applicable

Can Any one one help, its a bit urgent

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

How to select specific range in excel

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,