topic How to select particular data from xls file in QlikView

How to select particular data from xls file

rohit214 — Fri, 13 Jan 2012 05:30:23 GMT

Hi all
my problen is to select data from an xls file

i want to select data from column A &B

from row no11 to row no18

only Green colour data i want

thanks &regards

Rohit

Re: How to select particular data from xls file

CELAMBARASAN — Fri, 13 Jan 2012 05:46:53 GMT

Hi,

I'm assuming that u need selection on load script.

Based on that here is the code.

LOAD @1 as Field1, 
     @2 as Field2
FROM
Test_SBC - Copy.xls
(biff, no labels, table is [Reporting 1 - Dealer (Month)$], filters(
Remove(Row, Pos(Top, 10)),
Remove(Row, Pos(Top, 9)),
Remove(Row, Pos(Top, 8)),
Remove(Row, Pos(Top, 7)),
Remove(Row, Pos(Top, 6)),
Remove(Row, Pos(Top, 5)),
Remove(Row, Pos(Top, 4)),
Remove(Row, Pos(Top, 3)),
Remove(Row, Pos(Top, 2)),
Remove(Row, Pos(Top, 1)),
Remove(Row, Pos(Top, 35)),
Remove(Row, Pos(Top, 34)),
Remove(Row, Pos(Top, 33)),
Remove(Row, Pos(Top, 32)),
Remove(Row, Pos(Top, 31)),
Remove(Row, Pos(Top, 30)),
Remove(Row, Pos(Top, 29)),
Remove(Row, Pos(Top, 28)),
Remove(Row, Pos(Top, 27)),
Remove(Row, Pos(Top, 26)),
Remove(Row, Pos(Top, 25)),
Remove(Row, Pos(Top, 24)),
Remove(Row, Pos(Top, 23)),
Remove(Row, Pos(Top, 22)),
Remove(Row, Pos(Top, 21)),
Remove(Row, Pos(Top, 20)),
Remove(Row, Pos(Top, 19)),
Remove(Row, Pos(Top, 18)),
Remove(Row, Pos(Top, 17)),
Remove(Row, Pos(Top, 16)),
Remove(Row, Pos(Top, 15)),
Remove(Row, Pos(Top, 14)),
Remove(Row, Pos(Top, 13)),
Remove(Row, Pos(Top, 12)),
Remove(Row, Pos(Top, 11)),
Remove(Row, Pos(Top, 10)),
Remove(Row, Pos(Top, 9)),
));

Celambarasan

How to select particular data from xls file

rohit214 — Fri, 13 Jan 2012 05:54:16 GMT

hi Celambarasan

thanks for your reply

but the problem is my data is not constant it may varies all time means more no. of customeretc..

and second thing i want only data column A&B

thanks&regards

rohit

How to select particular data from xls file

rohit214 — Fri, 13 Jan 2012 06:38:52 GMT

please help me it is very urgent

any other idea

thanks

rohit

How to select particular data from xls file

Fri, 13 Jan 2012 06:49:59 GMT

hi Rohit,

For adding More customer you have to load again by filtering as above Celam said,or for more customer u can concatenate xl file with new customer.

How to select particular data from xls file

CELAMBARASAN — Fri, 13 Jan 2012 06:53:18 GMT

Hi,

Can you explain me What is unique feature in your excel file for selection?

Celambarasan

How to select particular data from xls file

rohit214 — Fri, 13 Jan 2012 07:00:27 GMT

HI Ketan

Thanks for your reply

actuually senario is i have more than 100 file with the same fields but in every file customer no. varies

so the datails about customer is also varies .and i want to load all files at a time means i donn't want to reload

again and again.as celam suggest me is a hardcore script ...suppose if i am using hardcore script so i want only

greem cover part data only

Hope you understood my problem

thanks

rohit

How to select particular data from xls file

CELAMBARASAN — Fri, 13 Jan 2012 07:10:37 GMT

Hi,

I think its not possible because my understanding is qlkview doesn't know about the background colour it access only data from the excel file in table format.Based on my understanding we cann't implement based on the background color.

Celambarasan.

How to select particular data from xls file

rohit214 — Fri, 13 Jan 2012 07:29:10 GMT

It is not based on coloured background i made it for understanding means i want to fetch only thar data

that is not in my database.

thanlks

rohit

How to select particular data from xls file

vijay_iitkgp — Fri, 13 Jan 2012 07:49:00 GMT

Hi Rohit,

If you want to get data from Excel Sheets that is not in your database then why dont you use where not Exists()condition while loading excelsheet.

Regards

Vijay

How to select particular data from xls file

Fri, 13 Jan 2012 08:11:08 GMT

hi Rohit,

As i uderstood,First time you have to load all files by applying filter form file wizard which is shown at loading time of file. You have to use concatenate between fiile , after that whenever You reload the application it will take the data what You want.

How to select particular data from xls file

rohit214 — Fri, 13 Jan 2012 08:52:50 GMT

hi vijay

i think you are getting me wrong

just go through my xls file my data is in that format only

thanks

rohit

How to select particular data from xls file

rohit214 — Fri, 13 Jan 2012 08:53:35 GMT

hey Ketan

can you send my a example file

thanks

rohit

Re: How to select particular data from xls file

Fri, 13 Jan 2012 19:08:26 GMT

If i understand you, maybe this can help you

Regards