topic Re: Comment - Limit in QlikView

Comment - Limit

denwo2010 — Fri, 05 Apr 2013 11:41:45 GMT

Hi,

Does anyone know what the comment limit is on a expression? And any ideas on how to extend this?

Thanks

Re: Comment - Limit

alexandros17 — Fri, 05 Apr 2013 11:46:54 GMT

If you mean REM:

// for only a line

/* ....

...

for more lines

Re: Comment - Limit

sushil353 — Fri, 05 Apr 2013 11:47:11 GMT

Have u encountered any comment limits???

Re: Comment - Limit

denwo2010 — Fri, 05 Apr 2013 13:03:55 GMT

If you look at the attached document, and hover over the value field it looks like it will only show 255 characters.

Thanks

Re: Comment - Limit

Fri, 05 Apr 2013 13:33:14 GMT

Hi,

Perhaps that is below the text HELP to help you.

Comment Field

Provides a way of displaying the field comments (metadata) from databases and spreadsheets. Field names not present in the document will be ignored. If multiple occurrences of a field name are found, the last value is used.

The keyword can be used to read comments from a data source using the following syntax:

comment *fieldlist using mapname

*fieldlist is a comma separated list of the fields to be commented. Using * as field list indicates all fields. The wildcard characters * and ? are allowed in field names. Quoting of field names may be necessary when wildcards are used.
mapname is the name of a mapping table previously read in a mapping load or mapping select statement (see Mapping).

The map table used should have two columns, the first containing field names and the second the comments.

To set individual comments the following syntax is used:

comment fieldname with comment

fieldname is the name of the field that should be commented.
comment is the comment that should be added to the field.

Example 1:

commentmap:

mapping load * inline [

a,b

Alpha,This field contains text values

Num,This field contains numeric values

];

comment fields using commentmap;

Example 2:

comment field Alpha with AFieldContainingCharacters;

comment field Num with A field containing numbers’;

comment Gamma with 'Mickey Mouse field';

Comment Table

Provides a way of displaying the table comments (metadata) from databases or spreadsheets. Table names not present in the document are ignored. If multiple occurrences of a table name is found, the last value is used.

The keyword can be used to read comments from a data source using the syntax:

comment tables tablelist using mapname

where

tablelist := (table{,table})
mapname is the name of a mapping table previously read in a mapping load or mapping select statement (see Mapping).

To set individual comments, the following syntax is used:

comment tables tablename with comment

where

tablename is the name of the table that should be commented.
comment is the comment that should be added to the table.

Example 1:

Commentmap:

mapping Load * inline [

a,b

Main,This is the fact table

Currencies, Currency helper table

];

comment tables using commentmap;

Example 2:

comment table Main with ‘Main fact table’;

By Rebeca

Re: Comment - Limit

denwo2010 — Fri, 05 Apr 2013 14:51:16 GMT

So from my attachment, could you provide an example on how this would work? As having trouble trying to understand this.

Thanks

Re: Comment - Limit

denwo2010 — Mon, 08 Apr 2013 15:56:31 GMT

Hi, So when do the comments appear? If you take a look in the attached document, the comments appear when it is a Dimension but not a expression? Do they appear on a straight table as well as it does not look like it does? Thanks

Re: Comment - Limit

denwo2010 — Tue, 09 Apr 2013 08:13:00 GMT

Anyone else had this issue with the comments not showing for the expressions?

Re: Comment - Limit

agigliotti — Tue, 16 Jul 2013 13:54:09 GMT

Hi,

I have the same problem with comment on expression.

below the comment I used:

---

Indice acido di liquidità = (Liquidità immediata+Liquidità differita) / Debiti a Breve *100

Ci dice la percentuale di debiti a breve che l’azienda è in grado di coprire con liquidità immediata (cassa,

banca, titoli a breve) e liquidità differita (crediti) . Dovrebbe essere compreso tra 100 e 200.

---

using QlikView Developer and also ajax client I see characters until "liquidità differita (".

Why ???

Can someone help me to achieve it ?

Thanks in advance.

Best Regards

Andrea