topic Re: Display field in Text box results in a hyphen in QlikView

Display field in Text box results in a hyphen

PaReD_SF85 — Wed, 25 Nov 2020 02:31:07 GMT

I have a table where the most recent date's comments should be displayed in a text box. Currently it results in a hyphen (-). If I substitute the ReturnComments field with the ReturnDate field as the field to be displayed, I get the date (9/1/2020) displayed. Mystified why a hyphen is the result for the comments?

ReturnDate	ReturnComments
2/19/2020	Summary comments A
5/26/2020	On 5/26 These comments were made.
9/1/2020	This summary from 9/1 provides insights to….

This is one of my attempts:

=Only({$<(max(date(ReturnDate)))>}[Return Comments])

Re: Display field in Text box results in a hyphen

MayilVahanan — Wed, 25 Nov 2020 08:15:31 GMT

Hi @PaReD_SF85

Try like below

=Only({<ReturnDate={"$(=Date(Max(ReturnDate),'M/D/YYYY'))"}>}ReturnComments)

Re: Display field in Text box results in a hyphen

PaReD_SF85 — Wed, 25 Nov 2020 13:15:17 GMT

Thank you MayilVahanan! This worked perfectly. What a difference a missing set of quote marks makes!