Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
modify the where statement as below
WHERE ([Account]>=3000) and ([Account]<=3799) and [Account] <> 3001 ;
Hi you can do the above load as a temp load, then load again from the temp table and add your where not clause?
modify the where statement as below
WHERE ([Account]>=3000) and ([Account]<=3799) and [Account] <> 3001 ;
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?
yes you can do this in the expression
Sum({<[Account] - = {3034}>}SalesSEK)/1000
Thank you once again, this worked excellent!