Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
PaReD_SF85
Contributor II
Contributor II

Display field in Text box results in a hyphen

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?

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

 

This is one of my attempts: 

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

2 Solutions

Accepted Solutions
MayilVahanan

Hi @PaReD_SF85 

Try like below

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

Thanks & Regards,
Mayil Vahanan R

View solution in original post

PaReD_SF85
Contributor II
Contributor II
Author

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

View solution in original post

2 Replies
MayilVahanan

Hi @PaReD_SF85 

Try like below

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

Thanks & Regards,
Mayil Vahanan R

View solution in original post

PaReD_SF85
Contributor II
Contributor II
Author

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

View solution in original post