topic Re: Suppress Null in QlikView

Suppress Null

Fri, 03 Apr 2015 08:24:05 GMT

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

Re: Suppress Null

amit_saini — Fri, 03 Apr 2015 08:26:12 GMT

Try This:

=if (not isnull(Employee_Type),Employee_Type)

Thanks,
AS

Re: Suppress Null

Fri, 03 Apr 2015 08:34:59 GMT

Thanks Amit,

For your Help.

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

Please give some clarification

Re: Suppress Null

amit_saini — Fri, 03 Apr 2015 08:40:15 GMT

Hi,

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

Thanks,
AS

Re: Suppress Null

Fri, 03 Apr 2015 08:49:07 GMT

Thanks Amit,

I tried but it is not working.

Re: Suppress Null

Anonymous — Fri, 03 Apr 2015 08:49:38 GMT

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

it will load null then suppress null

Thanks

BKC

Re: Suppress Null

MK_QSL — Fri, 03 Apr 2015 09:09:55 GMT

Change the Definition of Employee_Type in Script....

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

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

Re: Suppress Null

hariprasadqv — Fri, 03 Apr 2015 09:26:47 GMT

Hi,

Supressing null values with the chart properties my help you.

Re: Suppress Null

avinashelite — Fri, 03 Apr 2015 09:36:38 GMT

can you please share the app

Re: Suppress Null

simsondevadoss — Fri, 03 Apr 2015 09:39:40 GMT

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

Re: Suppress Null

sujeetsingh — Fri, 03 Apr 2015 09:48:42 GMT

use this as calculated dimension

If(len(Employee_Type)=0,null(),Employee_Type) as Calculated dimension

and then suppress null

Re: Suppress Null

buzzy996 — Fri, 03 Apr 2015 16:47:30 GMT

are u tried tis?

Dimension tab-->Suppress When Value is Null

Re: Suppress Null

ramoncova06 — Fri, 03 Apr 2015 17:01:21 GMT

topic Re: Suppress Null in QlikView

Suppress Null

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

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

Re: Suppress Null

Re: Suppress Null

Re: Suppress Null

Re: Suppress Null

Re: Suppress Null

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

Re: Suppress Null

Change the Definition of Employee_Type in Script....

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

Re: Suppress Null

Re: Suppress Null

Re: Suppress Null

Re: Suppress Null

If(len(Employee_Type)=0,null(),Employee_Type) as Calculated dimension

Re: Suppress Null

Re: Suppress Null

If(len(trim(Employee_Type))=0,'NULL',Employee_Type)