Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

bhavvibudagam
Contributor II

Correction help needed in the script of attached app

Hi Experts,

Can anyone please help me on below requirement.

Please help me on  avoiding null values under Team(scope) field.

Thanks in advance.

2 Replies

Re: Correction help needed in the script of attached app

Maybe like attached?

prieper
Honored Contributor II

Re: Correction help needed in the script of attached app

Depending on what you want to achieve ...

You may have a look into the OTHERSYMBOL-functionality,

e.g. (aircode)

SET OTHERSYMBOL = +;

MainTable: LOAD .....;

Scope:

LOAD [Team category] as [Team (scope)],

     [Team name]  as [Team (detail)],

     RevTarget,

     [Sample Target],

     [margin Target]

FROM

[Test Data.xlsx]

(ooxml, embedded labels, table is sample2);

CONCATENATE (Scope)

LOAD * INLINE [Team (scope), Team (detail), RevTarget, Sample Target, margin Target

               +              ,     #       , #          ,#          ,#];

LEFT JOIN (Maintable) LOAD * RESIDENT Scope;

DROP TABLE Scope;

This then will show "#" (or any other) in each related field