Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MIKIEMILLER
Contributor III
Contributor III

Removing Years the Equal Zero in Load Editor

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.

Sum values of zero.GIF

Thanks,

Matt

2 Replies
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
Creator II
Creator II

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;