Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

need help in understanding a code

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!

1 Solution

Accepted Solutions
sunny_talwar

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)

Capture.PNG

Step2: Click on Enable Transformation Steps

Capture.PNG

Step3: Transform your data as you like

Capture.PNG

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

View solution in original post

2 Replies
sunny_talwar

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)

Capture.PNG

Step2: Click on Enable Transformation Steps

Capture.PNG

Step3: Transform your data as you like

Capture.PNG

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

Not applicable
Author

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