Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: Multiple Entries

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

Re: Multiple Entries

Can You please get same in front end

Re: Multiple Entries

Front end:

Create a straight table with:

Dimension: PID, Name, Status, Date

Expression: Concat(Text)

Capture.PNG

MVP
MVP

Re: Multiple Entries

maybe maxstring(Text)

1.png

Community Browser