Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
denwo2010
Creator
Creator

Comment - Limit

Hi,

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

Thanks

8 Replies
alexandros17
Partner - Champion III
Partner - Champion III

If you mean REM:

// for only a line

/* ....

...

...

*/

for more lines

sushil353
Master II
Master II

Have u encountered any comment limits???

denwo2010
Creator
Creator
Author

Hi

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

Thanks

Not applicable

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

denwo2010
Creator
Creator
Author

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

Thanks

denwo2010
Creator
Creator
Author

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

denwo2010
Creator
Creator
Author

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

agigliotti
Partner - Champion
Partner - Champion

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