Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic Notes/Comments in Document

My challenge is to create an object with dynamic notes/comments from my business users.  My solution is to provide them an excel sheet where they will add the comments they want added to the report(s), pull that in during my load, and display in the report.  It works but it's a little clumsy.  Take a look at the example where I added some fake data.  Notice how in my text object I am hardcoding the unique identifier (RowNumber) in my only() funtion so that only one value will be returned per row.  I am forced to do this since this is a text object and not a chart (aggegration permitted).

Can anybody think of a way I can use a text object and display all three rows of data ... without having to hardcode the unique identifer?  Like I said this approach works but is not ideal.

Thanks for anything.

1 Solution

Accepted Solutions
fosuzuki
Partner - Specialist III
Partner - Specialist III

Try this:

=concat(

          aggr(

                    Author& ' - ' & Date(Date) & ':' & chr(13) & Note

                    , RowNumber

          )

          , chr(13) & chr(13)

          , RowNumber

)

View solution in original post

2 Replies
fosuzuki
Partner - Specialist III
Partner - Specialist III

Try this:

=concat(

          aggr(

                    Author& ' - ' & Date(Date) & ':' & chr(13) & Note

                    , RowNumber

          )

          , chr(13) & chr(13)

          , RowNumber

)

Not applicable
Author

Fernando perfect!  I forget about the usefullness of the concat() function.  That married with aggr() hit the spot.