topic help with expression in QlikView

help with expression

hopkinsc — Thu, 28 Oct 2010 10:29:48 GMT

Hi,

i am trying to write an expression to show total sales qty (SalesQuantity) but excluding any Voided transactions. Voids have a (LineType) of V.

I thought it should be something like

Sum({$<LineType=V>}SalesQuantity

But i cannot get it to work..

Can someone help please?

Thu, 28 Oct 2010 10:41:43 GMT

Hi Hopkinsc,

try this:


Sum({$<LineType -= V>}SalesQuantity)

put a dash before an equal sign to exclude all LineType V

regards

hopkinsc — Thu, 28 Oct 2010 10:45:58 GMT

Hi Ronald, I have just tried that but it still returns the sales quantity including VOIDS.

Any other ideas?

marcel_olmo — Thu, 28 Oct 2010 10:52:04 GMT

Maybe i'ts just formatting badly, when I have to exclude something in set analysis I always do it like this :


Sum( {$<[LineType ] -= {V} >} SalesQuantity )
If I don't use { } in the field I don't want to exclude it doesn't work.

hopkinsc — Thu, 28 Oct 2010 10:57:15 GMT

Thanks Marcel, but that hasn't worked either....

Thu, 28 Oct 2010 11:01:59 GMT

yes it should be enclosed with {}


Sum({$<LineType -= {V}>} SalesQuantity)

Thanks Marcel!

qliksus — Thu, 28 Oct 2010 11:07:59 GMT

I think this will work

Sum( {$<[LineType ] = {"*"} - {V}>} SalesQuantity )

Thu, 28 Oct 2010 11:10:30 GMT

Hi Hopkinsc,

that code should work. if the field LineType is two words enclosed it with []

I attached a file that shows exclusion.

hopkinsc — Thu, 28 Oct 2010 11:16:29 GMT

Hi Qliksus,

I have pasted your expression but i am getting an error in expression message.

hopkinsc — Thu, 28 Oct 2010 11:23:32 GMT

Hi, thanks everyone for your replies...

I have managed to get it working by using...

Sum({$<LineType -= {V}>} SalesQuantity)

Thanks again. 🙂