topic Re: Multiple Entries in QlikView

Multiple Entries

Thu, 21 Jan 2016 13:47:33 GMT

T1:

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:

sunny_talwar — Thu, 21 Jan 2016 18:22:05 GMT

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;

Thu, 21 Jan 2016 18:47:05 GMT

Can You please get same in front end

sunny_talwar — Thu, 21 Jan 2016 19:00:43 GMT

Front end:

Create a straight table with:

Dimension: PID, Name, Status, Date

Expression: Concat(Text)

maxgro — Thu, 21 Jan 2016 19:08:32 GMT

maybe maxstring(Text)