topic Re: What is use of comment table and comment field statements? in QlikView

What is use of comment table and comment field statements?

Sun, 12 Jan 2014 09:30:03 GMT

Hi,

Please tell me what is use of comment table and comment field statements.

I read the qlikview reference manual for this,but not getting exactly what the concept is.

Re: What is use of comment table and comment field statements?

qlikpahadi07 — Sun, 12 Jan 2014 10:01:57 GMT

Hi,

there is no such statement actually it's a code which you have commented which will not execute.

so, in qlikview reference manual if Whole Table is commented then it might be written as "Commented Table" so that you can address clearly and same with Commented Field.

Might be helpful

Re: What is use of comment table and comment field statements?

stevedark — Sun, 12 Jan 2014 10:50:11 GMT

Hi Angha,

In recent versions of QlikView there are many points in which you can store meta data about your document. In the UI you can do this frequently (eg. in the Properties for a chart you can do it for Dimensions and Expressions). For tables and fields that are created at load time you need to add these comments in script. Hence the COMMENT statement.

You can create applications without providing any meta data - and in most documents I've seen this is the case.

The COMMENT statement is not to be confused with commenting your code, but starting a line with // or encapsulating code in /* and */ . This is an unrelated use of the word Comment.

Hope that helps,

Steve

Re: What is use of comment table and comment field statements?

Colin-Albert — Sun, 12 Jan 2014 11:23:18 GMT

This item has more info on QlikView metadata including comment tags.

Metadata

Re: What is use of comment table and comment field statements?

luciancotea — Sun, 12 Jan 2014 12:18:33 GMT

Field comments shows in table/pivot charts when you hover the mouse over the field title

Re: What is use of comment table and comment field statements?

jolivares — Fri, 13 May 2016 16:34:36 GMT

Hi Lucian, can I recover the comment that is put inside the script via "comment" command, in order to use it in the application into a list box or whatever?

Did you know if it is possible?

Re: What is use of comment table and comment field statements?

luciancotea — Sat, 14 May 2016 22:46:13 GMT

No, it's metadata.

But I don't see why don't you just load the comments as data if you want to show them in a listbox.