topic Re: Documentation about remove() function in QlikView

Documentation about remove() function

Anonymous — Fri, 03 Nov 2017 11:56:40 GMT

Hi.

I can't find anywhere a documentation on the remove() function that we can use during a LOAD statement, into the files parameters.

i.e. :

LOAD *

FROM [data.xlsx]

(ooxml, embedded labels, table is [Sheet 1], filters(

Remove(Row, Pos(Top, 1)),

Remove(Row, RowCnd(CellValue, 1, StrCnd(null)))

));

Is anyone have got some informations about this ?

Thanks.

Re: Documentation about remove() function

el_aprendiz111 — Fri, 03 Nov 2017 21:43:50 GMT

Hi,

https://www.tutorialspoint.com/qlikview/qlikview_tutorial.pdf

Re: Documentation about remove() function

petter — Sat, 04 Nov 2017 07:05:01 GMT

Hi David,

Unfortunately Qlik never bothered (AFAIK) to document the filters-syntax part of the format-spec. So the only way is to use the dialogbox/wizard when loading from a file and see what is generated and possibly guessing the syntax from the resulting code.

-Petter

Re: Documentation about remove() function

Anonymous — Mon, 06 Nov 2017 09:35:19 GMT

Thanks for the link;

But, unfortunately, this type of document just present the "file loading wizard", and, by this way, the possibility to filter (remove) some rows.

There's no documention that explain how to use/write directly the remove() function into the script page.

Re: Documentation about remove() function

Anonymous — Mon, 06 Nov 2017 09:38:11 GMT

Thank you.

I've hoped that the community has already written some posts on this subject.

What a pity !

Re: Documentation about remove() function

Peter_Cammaert — Mon, 06 Nov 2017 10:38:37 GMT

Yeah, it is a pity...