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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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