expression

[#1]

HI all,

This is my expression:

Sum ({< Year = {$(=(max(Year)))}, DivisionName ={'Van XXX','XXX'}>} , Production.VehicleCategory <>  'Scan' CharterKilometers)/1000

How can I let qlikview exclude on that vehiclecategory?

kind regards

[alexandros17 · Accepted solution]

Sum ({< Year = {$(=(max(Year)))}, DivisionName ={'Van XXX','XXX'} , VehicleCategory ={'*'}-{'Scan'}>} CharterKilometers)/1000

[rustyfishbones]

TRY

Sum ({< Year = {$(=(max(Year)))}, DivisionName ={'Van XXX','XXX'} , Production.VehicleCategory -={'Scan'}>} CharterKilometers)/1000