Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

madeleine_josef
New Contributor III

Excluding data

Hi,

I have the following in my data load editor:

LOAD

      Account

FROM [lib://QvdLib (alfa_qliksense)/Prod\Load\Hansa\Receipt.qvd]

(qvd)WHERE ([Account]>=3000) and ([Account]<=3799);

Is there any way I can exclude one account that is within this range?

Thanks!

1 Solution

Accepted Solutions
greeshma_k
Contributor III

Re: Excluding data

modify the where statement as below

WHERE ([Account]>=3000) and ([Account]<=3799) and [Account] <> 3001 ;

5 Replies
dmac1971
Contributor II

Re: Excluding data

Hi you can do the above load as a temp load, then load again from the temp table and add your where not clause?

greeshma_k
Contributor III

Re: Excluding data

modify the where statement as below

WHERE ([Account]>=3000) and ([Account]<=3799) and [Account] <> 3001 ;

madeleine_josef
New Contributor III

Re: Excluding data

Thanks, this worked!

Is there any way I can write this in my expression in the table, ie. exluding one account in the sum?

I have the following expression: Sum(SalesSEK)/1000

Can I exlude account 3034 from this?

greeshma_k
Contributor III

Re: Excluding data

yes you can do this in the expression

Sum({<[Account] - = {3034}>}SalesSEK)/1000

madeleine_josef
New Contributor III

Re: Excluding data

Thank you once again, this worked excellent!

Community Browser