Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mjmilian
New Contributor II

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
MVP
MVP

Re: Removing Years the Equal Zero in Load Editor

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
Contributor II

Re: Removing Years the Equal Zero in Load Editor

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;

Community Browser