topic Re: Who can explain a QV load statement filter? in QlikView

Who can explain a QV load statement filter?

michael_klix — Thu, 11 Jan 2018 13:55:58 GMT

While reverse-engineering an inherited script from another programmer, I hit into the following filter of a load script:

....(ooxml, embedded labels, header is 1 lines, table is Sheet1, filters(

Remove(Row, Pos(Top, 2)),

Remove(Row, RowCnd(CellValue, 8, StrCnd(contain, 'N')))

Can someonte tell me what these two filters do?

Thanks a lot

- keep Qliking -

Michael

Re: Who can explain a QV load statement filter?

sunny_talwar — Thu, 11 Jan 2018 13:59:40 GMT

This part of the script is auto generated by QlikView when you load the data using File Wizard and do some transformations. Never tried to understand what they do... but you can see about them here

File Wizard: Transform ‒ QlikView

where is File Wizard : Transform?

Re: Who can explain a QV load statement filter?

sunny_talwar — Thu, 11 Jan 2018 14:01:28 GMT

For what I understand

Remove(Row, Pos(Top, 2)), -> Removing top two rows

Remove(Row, RowCnd(CellValue, 8, StrCnd(contain, 'N'))) -> Conditionally removing rows for some condition

Re: Who can explain a QV load statement filter?

marcus_sommer — Thu, 11 Jan 2018 14:09:54 GMT

Like Sunny I went never deeper in this logic because I do all needed transformations with the "normal" syntax. Nevertheless I think it's probably quite self-explanatory:

Remove(Row, Pos(Top, 2))

will delete the second record and is probably the same like where rowno() <> 2

Remove(Row, RowCnd(CellValue, 8, StrCnd(contain, 'N'))

will delete the records where the values of the 8 column = 'N' also in etwa:

where Column8 <> 'N' or maybe where not wildmatch(Column8, '*N*') because I'm not really sure about the key-word "contain".

- Marcus