# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for
Did you mean:
Contributor III

## If Match function + a measure formula

Good Day

I would like to link the below two calculations into one formula to be used my in measure(for my line graph):

calc 1: =if(match(ContractName,'X110 - PPC SLURRY','X120 - PPC DWAALBOOM','X260 - DISTELL GP','X260 - DISTELL GP MANAGED','X270 - DISTELL CAPE TOWN','X270 - DISTELL CAPE TOWN MAANGED','CCL McCain Transport','X360 - ISANTI','X370 - EVERITE','X380 - MERENSKY','X390 - SAFRIPOL','X400 - CAPE TOWN LOCAL','X410 - LANGENI','X500 - OWNER DRIVERS','X500 - RELIEF DRIVERS','X510 - Refrigerated O/D (Trucks)','X575 - FIXED SUBCONTRACTORS','X600 - NEOGISTIX','X740 - NEOGISTIX NAMIBIA','X745 - NEOGISTIX SAFRIPOL','X999 - DEPOT SUPPORT','HVL' ),ContractName)

Calc 2: sum(TripFuel)/sum(TripDistance)*100

Hope this makes sense

Kind Regards

Labels (4)

• ### Variables

1 Solution

Accepted Solutions
Specialist II

Hi,

Is not really clear what you want to do, could it be you want to include just those ContractName in the sum, if so then include as set analysis;

Maybe?

Cheers,

Chris.

2 Replies
Specialist II

Hi,

Is not really clear what you want to do, could it be you want to include just those ContractName in the sum, if so then include as set analysis;

Maybe?

Cheers,

Chris.

Contributor III
Author

@chrismarlow HI,

This is perfect, Thank you!

Kind Regards