Removing Years the Equal Zero in Load Editor

[MIKIEMILLER]

In the load editor I am looking to remove all data for any unit from any year that the amount total equals zero.  This is just a snapshot of my data.

Thanks,

Matt

[sunny_talwar]

May be try this

Table:

LOAD Unit,

    Year,

    Period,

    Amount

FROM

[..\..\Downloads\Qlik Test.xlsx]

(ooxml, embedded labels, table is Sheet1);

Right Join (Table)

LOAD Unit,

Year

Where Total <> 0;

LOAD Unit,

Year,

Sum(Amount) as Total

Resident Table

Group By Unit, Year;

[sumanta12]

TABLE_NEW:

LOAD

Unit,

Year,

Period,

SUM(Amount) AS Amount

GROUP BY Unit,Year,Period;

LOAD Unit,

     Year,

     Period,

     Amount

FROM

(ooxml, embedded labels, table is Sheet1);

NOCONCATENATE

TABLE:

LOAD * RESIDENT TABLE_NEW

WHERE Amount>0;

DROP TABLE TABLE_NEW;