topic Re: MATCH FIELDS in QlikView

MATCH FIELDS

upaliwije — Tue, 19 Aug 2014 04:48:59 GMT

I have following data fields in a table

Customer Payee AMOUNT

A TOYATO 10000

B M/S TOYOTA 7500

C Toyota pvt ltd 4000

D DIMO 2000

E DIMO COMPANY 15000

F Dimo 100

I want to sum amount according to payee name. Since the payee name . Since the payee name recorded differently pls help with a expression to extract data

Re: MATCH FIELDS

sujeetsingh — Tue, 19 Aug 2014 04:54:07 GMT

You can use subfield function to do this but before you need to come up with the consistency in the names .

Re: MATCH FIELDS

Tue, 19 Aug 2014 04:54:50 GMT

Hi,

How your Output Should look like ? Can u upload sample output Table ?

Re: MATCH FIELDS

PrashantSangle — Tue, 19 Aug 2014 04:59:17 GMT

Hi,

Use combination of wildmatch() and Special charater *

If(wildmatch(Payee,'*Toyato*'),sum(Amount))

Regards

Re: MATCH FIELDS

Tue, 19 Aug 2014 05:03:50 GMT

please elaborate your requirement,post the output table which you want.

Re: MATCH FIELDS

ashfaq_haseeb — Tue, 19 Aug 2014 05:11:23 GMT

Hi,

Have a look at the attached application.

Regards

ASHFAQ

Re: MATCH FIELDS

jagan — Tue, 19 Aug 2014 05:20:33 GMT

Hi,

Try to create one more with Customer and Payee names like below.

Data:

load * Inline

[

Customer,Payee,AMOUNT

A,TOYATO,10000

B ,M/S TOYOTA,7500

C ,Toyota pvt ltd,000

D ,DIMO,2000

E,DIMO COMPANY,15000

F,Dimo,100

];

LEFT JOIN(Data)

load * Inline

[

Customer,PayeeCategory

Toyota,A

Toyota ,B

Toyota ,C

Dimo ,D

Dimo,E

Dimo,F

];

Now PayeeCategory as Dimension in your chart.

Create an excel and maintain the Customer mapping details so that it would be easier to maintain.

Regards,

Jagan.