Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

To read specific row in xls file.

hi,

I'm very new to Qlikview, I need to load multiple xls files in that need to read a specific row, could anyone of help me on this please.

thanks,

Hema

14 Replies
Clever_Anjos
Employee
Employee

What do you mean by "specific row"?

3rd one for example?

Or

where A column = a value?

Not applicable
Author

Thanks for the reply

Yes, In the file, row has data’s in row 1 row2 and row 3, in that I need only row 3 data’s in the Dashboard, I’m not much familiar in scripting so seeking for help.

balrajahlawat
Champion
Champion

Use where condition while reading the file like this?

Load

Name,

Address,

Mobile

From ExcelFile

where

Name like 'Hema*'

or

Name like '*Hema*'

or

Name like '*Hema';


Hope this will help!!

Digvijay_Singh

Use Where clause to filter specific rows, you need to know the filter criteria to be put in where clause.

jagan
MVP
MVP

Hi,

While posting the question in community prepare sample data and attach it, so that it would be easier to understand and provide you the solution. This way you will get the answers quickly.  Please check below link for getting successful answers

Qlik Community Tip: Posting Successful Discussion Threads

You can use where condition to filter the rows, or you can use RowNo() or RecNo() in the where condition.

WHERE  RowNo() = 5;

Hope this helps you.

Regards,

Jagan.

vsudhakar
Creator III
Creator III

load the excel file and give the as it follows

where column name ='Hema'

jagan
MVP
MVP

HI

Try this where condition

LOAD

*

FROM ExcelFile

WHERE  RowNo() <= 3;

balrajahlawat
Champion
Champion

Its seems you want to load only one column, is it?

I am assuming you are having excel file like this?

Row1, Row2, Row3

1          a          aa

2          b          vv

3          v          bb

Now you want to load Row3 which is a column only?

Then simply write

Load

Row3

from YourExcelFile;

tamilarasu
Champion
Champion

If I understood you correctly, you want to load row no 3.?  If so,

Load *

From

[Test.xlsx]

(ooxml, embedded labels, table is Sheet1) where RecNo()=3 ;