How can I get rid of this Unknown fields and only show the rows which have normal data

[trishita]

I want to hide the unknown fields.I have uploaded my qvw.Can some one help me with this

[Anonymous]

Change your Dimension "Actual_Fuel_Type' to a calculated Dimension:

=if (Actual_Fuel_Type<>'Unknown', Actual_Fuel_Type)

[trishita]

Hi,

I changed but the unknown values are still visible

[Anonymous · Accepted solution]

I just checked your Expression to the end

there you define 'Unknown'  when no other Option applies

drop this and you will not see Unknown

why do you use if conditions hwhen you have the same Expression?

this should be sufficient, but with SOUNDING_START_DATE you ignore when the user selects a specific date

sum( {$<Actual_Fuel_Type={'HSFO'},SOUNDING_START_DATE,IMO_NO>}FUEL_MASS_AFTER_SOUNDING/ 1000)

[trishita]

could u assist then how should i modify my expression:

if (Match([Actual_Fuel_Type],'HSFO'), sum(  {$<Actual_Fuel_Type={'HSFO'},SOUNDING_START_DATE,IMO_NO>}FUEL_MASS_BEFORE_SOUNDING/ 1000),

if (Match([Actual_Fuel_Type],'LSDO'), sum(  {$<Actual_Fuel_Type={'LSDO'},SOUNDING_START_DATE,IMO_NO>}FUEL_MASS_BEFORE_SOUNDING/ 1000),

if (Match([Actual_Fuel_Type],'HSDO'), sum(  {$<Actual_Fuel_Type={'HSDO'},SOUNDING_START_DATE,IMO_NO>}FUEL_MASS_BEFORE_SOUNDING/ 1000),

if (Match([Actual_Fuel_Type],'ULSFO'),sum(  {$<Actual_Fuel_Type={'ULSFO'},SOUNDING_START_DATE,IMO_NO>}FUEL_MASS_BEFORE_SOUNDING/ 1000),'Unknown'

))))

[trishita]

its working..i understood what u meant..

if (Match([Actual_Fuel_Type],'HSFO'), sum(  {$<Actual_Fuel_Type={'HSFO'},SOUNDING_START_DATE,IMO_NO>}FUEL_MASS_BEFORE_SOUNDING/ 1000),

if (Match([Actual_Fuel_Type],'LSDO'), sum(  {$<Actual_Fuel_Type={'LSDO'},SOUNDING_START_DATE,IMO_NO>}FUEL_MASS_BEFORE_SOUNDING/ 1000),

if (Match([Actual_Fuel_Type],'HSDO'), sum(  {$<Actual_Fuel_Type={'HSDO'},SOUNDING_START_DATE,IMO_NO>}FUEL_MASS_BEFORE_SOUNDING/ 1000),

if (Match([Actual_Fuel_Type],'ULSFO'),sum(  {$<Actual_Fuel_Type={'ULSFO'},SOUNDING_START_DATE,IMO_NO>}FUEL_MASS_BEFORE_SOUNDING/ 1000)

))))

Thanks a lot