topic Re: new to qlikviewMatch data in QlikView

new to qlikviewMatch data

qlikapple — Wed, 25 Nov 2020 16:16:04 GMT

Hi all , I am

Re: new to qlikviewMatch data

qlikapple — Mon, 12 Jun 2017 08:32:05 GMT

Hi all , i am new to qlik

i have data below , My requirement is attched, anyon eplease help

Re: new to qlikviewMatch data

Siva_Sankar — Mon, 12 Jun 2017 08:35:32 GMT

Hi Sahaja,

Can you explain breifly about your question?

Qlik Community Tip: How to Get Answers to Your Post

-siva

Re: new to qlikviewMatch data

Siva_Sankar — Mon, 12 Jun 2017 09:33:34 GMT

Hi Sahaja,

Find the attached output as you expected,

[Table A]:

Load*,

if(len(GRPMain)=0,'',

if(GRP=GRPMain,'Y','N') ) as GRPMATCH;

Load * inline

[

Incidents,GRP,GRPMain

1,A,A

2,B,C

3,C,B

4,D

5,E

6,F

7,G

];

-Regards

Siva

Re: new to qlikviewMatch data

qlikapple — Tue, 20 Jun 2017 10:53:20 GMT

HI all , can anyone plese help

I didnt get the O/p as expected

i have data like this from direct database, but the user gave one excel sheet i nee to map with excel sheet and see if its matches i have to keep as Y else N

Suppose

TAbleA

Ticket AssignemntGRP

1 GRPA

2 GRPB

3 GRPC

4 GRPD

Table B(user gave Excel sheet)

GRP

GRPC

GRPD

GRPA

GRPE

I want the O/P as

Ticket AssignmentGRP Matches

1 GRPA Y

2 GRPB N

3 GRPC Y

4 GRPD Y

Anyone please help , as the data is huge in database, i want to change in the sript

Re: new to qlikviewMatch data

Anil_Babu_Samineni — Tue, 20 Jun 2017 11:03:45 GMT

How about this?

If(ApplyMap('TAbleA', AssignemntGRP, Null()) as AssignemntGRP

Then You have to write like below

If(GRP = AssignemntGRP, 'Y', 'N') as Flag

Re: new to qlikviewMatch data

sasikanth — Tue, 20 Jun 2017 11:08:53 GMT

Try below one

Table B (From user)

LOAD * INLINE [

AssignemntGRP

GRP

GRPC

GRPD

GRPA

GRPE

];

TAbleA:

Load Ticket,AssignemntGRP, if Exists(AssignemntGRP),'Y','N') as Matches;

LOAD * INLINE [

Ticket AssignemntGRP

1 GRPA

2 GRPB

3 GRPC

4 GRPD

];