topic Script Help in QlikView

Script Help

hopkinsc — Fri, 12 Aug 2011 14:42:14 GMT

Hi, i am trying to do something in my script but i'm not sure how to do it..

I am loading in a table with the following fields..

PosTransactionDetail:

LOAD

StoreNumber,

TransId,

EANCode AS EAN,

VATIndicator,

VATAmountDue,

VATBase,

LineType,

SaleStartDate

FROM xyz

But i don't want to load in any POSITIVE VATbase values with the LineType of V (But still want to include the NEGATIVE LineTypes of V)

Can anyone help me to achieve this please?

Script Help

john_duffy — Fri, 12 Aug 2011 14:44:39 GMT

Hello.

Try adding a Where clause such as 'not(LineType = 'V' and VATBase > 0)'.

John.

Script Help

hopkinsc — Fri, 12 Aug 2011 14:51:49 GMT

Hi John,

This is what i did..

PosTransactionDetail:

LOAD

StoreNumber,

TransId,

EANCode AS EAN,

VATIndicator,

VATAmountDue,

VATBase,

LineType,

SaleStartDate

FROM $(cFileName) (qvd) Where not(LineType = 'V' and VATBase > 0);

But this excluded ALL lineTypes of V except ZERO....

Any ideas?

Script Help

hopkinsc — Fri, 12 Aug 2011 14:55:47 GMT

John, sorry, ignorfe me, i had a selection wrong. That did what i wanted, but have found another problem. Just trying to find out what the problem is,...