Excluding data

[Anonymous]

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!

[dmac1971]

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

[Anonymous · Accepted solution]

modify the where statement as below

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

[Anonymous]

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?

[Anonymous]

yes you can do this in the expression

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

[Anonymous]

Thank you once again, this worked excellent!