Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sum ({< Year = {$(=(max(Year)))}, DivisionName ={'Van XXX','XXX'} , VehicleCategory ={'*'}-{'Scan'}>} CharterKilometers)/1000
Sum ({< Year = {$(=(max(Year)))}, DivisionName ={'Van XXX','XXX'} , VehicleCategory ={'*'}-{'Scan'}>} CharterKilometers)/1000
TRY
Sum ({< Year = {$(=(max(Year)))}, DivisionName ={'Van XXX','XXX'} , Production.VehicleCategory -={'Scan'}>} CharterKilometers)/1000