topic Re: Count fields in script in QlikView

Count fields in script

Tue, 19 Nov 2013 14:56:14 GMT

In the load script how to count the number of Fields on a table with name (so headers, not content) started by "abc" for example?

Re: Count fields in script

datanibbler — Tue, 19 Nov 2013 14:58:29 GMT

Use a WHERE clause - if the searched-for letters are always the first ones in the string - nothing easier. Use a LEFT() function.

HTH

Best regards,

DataNibbler

Re: Count fields in script

Tue, 19 Nov 2013 15:01:14 GMT

But I want to count the number of columns named something, not the contents as I explained before.

Thanks,

Miguel

Re: Count fields in script

datanibbler — Tue, 19 Nov 2013 15:19:48 GMT

Hi Miguel,

that is also possible. I'm not quite sure how, but there are the so-called "table functions" (look for them in the help file) that can be used in the script to get information about the currently loaded table. You can go from there (NoOfFields is probably the right one, combined with a WHERE_clause)

Re: Count fields in script

rustyfishbones — Tue, 19 Nov 2013 15:24:52 GMT

Add a text object with

Re: Count fields in script

sivarajs — Tue, 19 Nov 2013 15:25:17 GMT

You can try this

LET vnew=NoOfFields('Tablename'); //you should use after the table is loaded.