Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple Entries

  T1:  

PIDNameStatusDateText
1XXxOpen12/8/2014
2werOpen15/07/2015
3t5ttClosed13/08/2015
3t5ttClosed13/08/2015Exit
4testOpen16/01/2016
4testOpen16/01/2016Nexit

T1 has got multiple entries when I added the new field Text to it.

I would like to display a sigle entry which have the value for the field Text for each PID like below.

Help me to get the below output:

  output:  

PIDNameStatusDateText
1XXxOpen12/8/2014
2werOpen15/07/2015
3t5ttClosed13/08/2015Exit
4testOpen16/01/2016Nexit
4 Replies
sunny_talwar

Try this:

Table:

LOAD PID,

    Name,

    Status,

    Date,

    Text

FROM

[https://community.qlik.com/thread/200924]

(html, codepage is 1252, embedded labels, table is @1);

FinalTable:

NoConcatenate

LOAD PID,

  Only(Name) as Name,

  Only(Status) as Status,

  Only(Date) as Date,

  FirstValue(Text) as Text

Resident Table

Group By PID

Order By PID, Text desc;

DROP Table Table;

Not applicable
Author

Can You please get same in front end

sunny_talwar

Front end:

Create a straight table with:

Dimension: PID, Name, Status, Date

Expression: Concat(Text)

Capture.PNG

maxgro
MVP
MVP

maybe maxstring(Text)

1.png