Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

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

Highlighted
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)

Highlighted
Partner
Partner

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

Highlighted
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,