Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
Thank you for the detailed explanation, Sunny! I understood now.