need help in understanding a code

[#1]

Hi,

I am trying to understand an already developed qlikview application and there are some excel filters that has been applied. Can someone please explain what the below filters and functions mean? i tried googling each function but still have some difficulty in understanding it.

LOAD Right(@1,2) as Data

FROM

[sourcedata.xls]

(biff, no labels, header is 2 lines, table is [XYZ], filters(

Remove(Row, RowCnd(Interval, Pos(Top, 2), Pos(Bottom, 1), Select(1, 0))),

Remove(Col, Pos(Top, 1))

TIA!

[sunny_talwar · Accepted solution]

This might be typed in, but I know the QlikView provide a way to do this in the script's UI.

Step 1: Load your data and click 'Next >' (DONOT click Finish)

Step2: Click on Enable Transformation Steps

Step3: Transform your data as you like

From the code you have given it seems that Some rows are getting conditionally deleted between row 2 and last row

Remove(Row, RowCnd(Interval, Pos(Top, 2), Pos(Bottom, 1), Select(1, 0))),

and column 1 is deleted

Remove(Col, Pos(Top, 1) -> The easier way to do this would be to not bring that column in your script part.

I hope this will help.

Best,

Sunny

[#3]

Thank you for the detailed explanation, Sunny! I understood now.