Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
trishita
Creator III
Creator III

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

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

1 Solution

Accepted Solutions
Anonymous
Not applicable

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)

View solution in original post

5 Replies
Anonymous
Not applicable

Change your Dimension "Actual_Fuel_Type' to a calculated Dimension:

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

trishita
Creator III
Creator III
Author

Hi,

I changed but the unknown values are still visible

Anonymous
Not applicable

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
Creator III
Creator III
Author

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
Creator III
Creator III
Author

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