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

Comments have in first line a date the reminder null

HI Community,

I want that the Comments which has the same "LaufendeNr"(EntryNR) get the "Datum" from first Line which is given in the database.

LaufendeNrKommentarDatum
21501es stehen Verhandlungen an14.03.2012
21501Kommentar 2 Test01.01.1753
21501Test 301.01.1753
1959 usw.........

That is: all the 3 lines with the LaufendeNr(EntryNo) "21501" must have the Datum "14.03.2012".

(01.01.1753 is a Null Value if there are no date for this line in database.)

At the end, i want to achieve that all Comments with the same LaufendeNr are displayed in a TextBox : Commnt1,Comment2,Comment3 with this Expression

FirstSortedvalue(Kommentar, -Datum).

You must still do something with concat?

Thanks!!!!!!!

0 Replies