Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

avinsingh
New Contributor II

Exlude some rows from the file loaded

Hi All,

I am new to qliksense. I am trying to load a file which have many fields in it. There is field name by Country in which i have name of the countries and "Total" in it. While loading the data i do not want Total to get loaded in the script.

Pls help.

Regards,

Avinash

1 Solution

Accepted Solutions

Re: Exlude some rows from the file loaded

May be like this

Where Country <> 'Total';

6 Replies

Re: Exlude some rows from the file loaded

May be like this

Where Country <> 'Total';

OmarBenSalem
Esteemed Contributor

Re: Exlude some rows from the file loaded

Load *

from yourSource where Country<>'Total';

laddu_927
Valued Contributor

Re: Exlude some rows from the file loaded

try

Load Country,

.

.

.

.

From filename

where 1-sign(Match(Country,'Total'));

shiveshsingh
Honored Contributor

Re: Exlude some rows from the file loaded

Hi

Load * from source where Country <> 'Total'

avinsingh
New Contributor II

Re: Exlude some rows from the file loaded

Thanks. It worked.

oknotsen
Honored Contributor III

Re: Exlude some rows from the file loaded

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .

May you live in interesting times!
Community Browser