topic Re: How can I get rid of this Unknown fields and only show the rows which have normal data in QlikView

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

trishita — Wed, 25 Nov 2020 16:16:04 GMT

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

Anonymous — Wed, 26 Sep 2018 09:12:34 GMT

Change your Dimension "Actual_Fuel_Type' to a calculated Dimension:

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

trishita — Wed, 26 Sep 2018 09:39:54 GMT

Hi,

I changed but the unknown values are still visible

Anonymous — Wed, 26 Sep 2018 09:53:31 GMT

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 — Wed, 26 Sep 2018 11:07:58 GMT

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 — Wed, 26 Sep 2018 11:13:12 GMT

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