How to pick up

[Anonymous]

Hi Qlikers,

I'm facing a problem

Data is like

EmpId	Sequence No	CODE	Description
0000003237	0001	INIT	e_assignment
0000003237	0002	RMGO	e-Assignment Resource   Request 0000003237
0000003237	0003	RINT	Erc Requisition   request
0000003237	0004	RIIA	Requisition Approval   for Consultant
0000003237	0005	RRRA	Requisition Approval   for Consultant
0000003320	0001	INIT	e_assignment
0000003320	0002	RMGO	e-Assignment Resource   Request 0000003320
0000003320	0003	RINT	Erc Requisition   request
0000003320	0004	RIIA	Requisition Approval   for SAP ABAP Consultant
0000003320	0005	RRRA	Requisition Approval   for SAP ABAP Consultant
0000003320	0006	RCOM	Erc Requisition   request
0000003320	0007	OINT	Offer Approval
0000003320	0008	OCRA	eReq - Offer Approval   for Amit Kumar
0000003320	0009	ORRA	eReq - Offer Approval   for Amit Kumar
0000003320	0010	OCOM	Offer Approval

If I click emp Id : 3237 it should pick the last Sequence No & code id  gives the single description

My output like:

EmpID ,    Sequence No,   Code,     Description

00003237,    005,              RRRA,    Requisition Approval  for Consultant

Thanks in advance..........

[maxgro]

see attachment

[anbu1984]

Check this

[PrashantSangle]

Hi,

Use FirstSortedValue()

check details in Help menu.

It will help you to acheive desired result.

Regards

[Anonymous]

Hi Grossi,

Exactly I want the output like that only ,but I want to that in the script level not for the chart level,

if you don't mine can help me that..

Thanks in advance

[Anonymous]

Hi Anbu,

Exactly I want the output like that only ,but I want to do that in the script level not for the chart level,

if you don't mine can help me that..

Thanks in Advance.....

[maxgro]

LOAD EmpId, max([Sequence No]), FirstSortedValue(CODE, -[Sequence No]),

FirstSortedValue(Description, -[Sequence No])

FROM [http://community.qlik.com/thread/135414] (html, codepage is 1252, embedded labels, table is @1)

group by EmpId

;

[anbu1984]

Load EmpId,FirstSortedValue([Sequence No],-[Sequence No]) As [Sequence No],FirstSortedValue(CODE,-[Sequence No]) As CODE,FirstSortedValue(Description,-[Sequence No]) As Description

Group by EmpId;

Load * Inline [

EmpId,Sequence No,CODE,Description

0000003237,0001,INIT,e_assignment

0000003237,0002,RMGO,e-Assignment Resource Request 0000003237

0000003237,0003,RINT,Erc Requisition request

0000003237,0004,RIIA,Requisition Approval for Consultant

0000003237,0005,RRRA,Requisition Approval for Consultant

0000003320,0001,INIT,e_assignment

0000003320,0002,RMGO,e-Assignment Resource  Request 0000003320

0000003320,0003,RINT,Erc Requisition  request

0000003320,0004,RIIA,Requisition Approval  for SAP ABAP Consultant

0000003320,0005,RRRA,Requisition Approval  for SAP ABAP Consultant

0000003320,0006,RCOM,Erc Requisition  request

0000003320,0007,OINT,Offer Approval

0000003320,0008,OCRA,eReq - Offer Approval  for Amit Kumar

0000003320,0009,ORRA,eReq - Offer Approval  for Amit Kumar

0000003320,0010,OCOM,Offer Approval ];

[Anonymous]

Hi Anbu,

I didn't get the result..

Can u post the scripting code please..........

[anbu1984]

check this qvw