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.

karunpreet
Not applicable

Search a Word in the column and load only the data which is below it

Hi everyone,

I have an excel sheet with many rows and columns.

Supposingly I have a world called Group in my first column. I want to search that word and delete all the data which is above it, including the data of Group and load only that data which is below that word Group. And, this I need to do while fetching the data.

Is it possible in qlikview ? I yes, then please help me with this

thanks and regards

1 Solution

Accepted Solutions
MK_QSL
Not applicable

Re: Search a Word in the column and load only the data which is below it

Like this?

3 Replies
MK_QSL
Not applicable

Re: Search a Word in the column and load only the data which is below it

Like this?

karunpreet
Not applicable

Re: Search a Word in the column and load only the data which is below it

ya like this

MK_QSL
Not applicable

Re: Search a Word in the column and load only the data which is below it

Please close the thread by selecting correct/helpful answer so that others can also take advantage it.

Thanks...