Where function in script

hopkinsc — Wed, 10 Aug 2011 12:22:42 GMT

Hi,I am writing a VAT application and i am trying to break down a SalesValue field in my script

E.g.

Sales Value =£1000 which is a total of £200 Vat Code A, £400 Vat Code B and £400 Vat Code C

I want to break this down in the script and make new fields something like:

Load...

SalesValue Where VATIndicator ='A' AS SalesValueA,

SalesValue Where VATIndicator ='B' AS SalesValueB,

SalesValue Where VATIndicator ='C' AS SalesValueC

From...

But i do not know how to do it..

I know i can use set analysis in a chart to total up each VAT Code but i thought it might be quicker to get it done in the script instead (As the script is reloaded out of hours)

Can anyone help please?

Where function in script

jedgson — Wed, 10 Aug 2011 12:33:16 GMT

Try,

Load

If( VATIndicator = 'A', SalesValue, 0) as SalesValueA,

If( VATIndicator = 'B', SalesValue, 0) as SalesValueB,

If( VATIndicator = 'C', SalesValue, 0) as SalesValueC

From ..

Jay

topic Where function in script in QlikView

Where function in script

Where function in script