8 Replies Latest reply: Jul 16, 2013 9:54 AM by Andrea Gigliotti RSS

    Comment - Limit

    Denis Woods

      Hi,

       

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

       

      Thanks

        • Re: Comment - Limit
          Alessandro Saccone

          If you mean REM:

           

          // for only a line

           

          /* ....

          ...

          ...

          */

           

          for more lines

          • Re: Comment - Limit
            Sushil Kumar

            Have u encountered any comment limits???

            • Re: Comment - Limit

              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
                  Denis Woods

                  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
                      Denis Woods

                      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
                          Denis Woods

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

                            • Re: Comment - Limit
                              Andrea Gigliotti

                              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