topic Re: Re: How to pick up in QlikView

How to pick up

Anonymous — Mon, 29 Sep 2014 12:49:43 GMT

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..........

Re: How to pick up

maxgro — Mon, 29 Sep 2014 12:54:44 GMT

see attachment

Re: How to pick up

anbu1984 — Mon, 29 Sep 2014 12:55:47 GMT

Check this

Re: How to pick up

PrashantSangle — Mon, 29 Sep 2014 12:57:30 GMT

Hi,

Use FirstSortedValue()

check details in Help menu.

It will help you to acheive desired result.

Regards

Re: How to pick up

Anonymous — Mon, 29 Sep 2014 12:57:49 GMT

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

Re: How to pick up

Anonymous — Mon, 29 Sep 2014 13:02:12 GMT

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.....

Re: How to pick up

maxgro — Mon, 29 Sep 2014 13:03:53 GMT

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

;

Re: How to pick up

anbu1984 — Mon, 29 Sep 2014 13:04:28 GMT

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 ];

Re: How to pick up

Anonymous — Mon, 29 Sep 2014 13:12:54 GMT

Hi Anbu,

I didn't get the result..

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

Re: Re: How to pick up

anbu1984 — Mon, 29 Sep 2014 13:16:05 GMT

check this qvw