How to display only null values

[Srinivas]

Hi Friends,

i want to display only null values in front end level and through script as well.

see below data i have this way:

my output is below way:

i need in script and Frontenac as well

Regards

Munna

[MayilVahanan]

Hi

Try like this

Load *, If(Len(Trim(STYLE)), 0, 1) as StyleNull from datasource;

In front end,

Add dimension as ID, DES, Number and Region

= Only({<StyleNull = {1}>}Style)

[Gabriel]

Hi,

Try this in your script

Data:

LOAD

ID,

DES,
If(IsNull(STYLE) ,'Null',STYLE) AS STYLE,  //Change 'Null' to whatever you want to display
NUMBER,
REGION

FROM SourceFile;

[Kushal_Chawda]

Try this,

Data:

LOAD *,

if( isnull(STYLE) or len(trim(STYLE))=0 ,1,0) as FlagNull

FROM SOURCE

Null:

noconcatenate

load *

resident Data

where FlagNull=1;

drop table Data;

[Srinivas]

Hi Mayil,

I need this code front end only, why because i don't have reload option.

Regards

Munna

[MayilVahanan]

hi

Try like this

In front end,

Add dimension as ID, DES, Number and Region

= Only({<Style -={'*'}>}Style)

[Anonymous]

Hi ,

Try Like This

load if(Len(Your Fileld)>=0,'-',1) as Null;

In front end Use the same field .

[sebastiandperei]

Create a Chart.

Use ID, DES, STYLE and NUMBER as dimmentions.

Use RES as expression like that:

Only({<ID=E({<STYLE={"*"}>})>}RES)

[d_koti24]

Hi,

In Expression try like this :

If(Len(STYLE) = 0, ' '),

Find the sample Attachment.

Regards,

!

[d_koti24]

Hi,

You can try like this also.

if(STYLE=null(), 'NULL')

OR

IF(LEN(STYLE)=0,' ')

Regards,