topic Re: need help in understanding a code in QlikView

need help in understanding a code

Tue, 24 Nov 2015 14:17:30 GMT

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!

Re: need help in understanding a code

sunny_talwar — Tue, 24 Nov 2015 18:42:08 GMT

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

Re: need help in understanding a code

Wed, 25 Nov 2015 01:53:52 GMT

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