Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
mjmilian
New 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
Highlighted

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;

Highlighted
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;