Suppress Null

[#1]

Hi All,

I have data with a include classname and ID mean String and Number.

I seperated Both string and ID.

Right(String, len(String)-index(String,'-',4)) As Employee_Type

I created a Bar chart,

Dimension : Employee_Type

Expresion : Count(ID)

But in Employee_Type having some NULL value.

I have written If(len(Employee_Type)=0,'NULL',Employee_Type)

it is showing NULL in my char.

But Now i don't want the NULLs in my chat i want to suppress.

i enabled CharProperties--->Presentation------> Suppress Zero Value

But still it is showing NULL in my chart is there any way to suppress NULL when we load into Qlikview.

Please let me know.

Thanks

[amit_saini]

Try This:

=if (not isnull(Employee_Type),Employee_Type)

Thanks,
AS

[#3]

Thanks Amit,

For your Help.

Sorry where should i try. in Chart i have taken Calculated dimension.

Please give some clarification

[amit_saini]

Hi,

You can use this as Dimension (Calculated expression) or also as expression based on your requirement.

Thanks,
AS

[#5]

Thanks Amit,

I tried but it is not working.

[Anonymous]

write this if(len(Employee_Type)=0,null(),Employee_Type)

it will load null then suppress null

Thanks

BKC

[MK_QSL]

Change the Definition of Employee_Type in Script....

IF(IsNull(Right(String, len(String)-index(String,'-',4)))

OR

LEN(TRIM(Right(String, len(String)-index(String,'-',4))))=0, Null(), Right(String, len(String)-index(String,'-',4))) As Employee_Type

[hariprasadqv]

Hi,

Supressing null values with the chart properties my help you.

[avinashelite]

can you please share the app

[simsondevadoss]

Use suppress when value is null in dimension(chart properties) and uncheck show all values