Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
madeleine_josef
Creator
Creator

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
Creator III
Creator III

modify the where statement as below

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

View solution in original post

5 Replies
dmac1971
Creator II
Creator II

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
Creator III
Creator III

modify the where statement as below

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

View solution in original post

madeleine_josef
Creator
Creator
Author

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
Creator III
Creator III

yes you can do this in the expression

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

madeleine_josef
Creator
Creator
Author

Thank you once again, this worked excellent!