topic Format to negative in Set analysis in QlikView

Format to negative in Set analysis

Anonymous — Wed, 25 Jun 2014 23:43:32 GMT

Hello! I have a set analysis formula to get the projected ending inventory...Thus, I would like to convert one of the item (Sales Order) to negative so the SalesOrder value will be deducted from the total value.

So my values would look like this

Aspect

Inventory 35000000

Sales Order A -500000

Sales Order B -200500

Open PO 10000000

Total 44,299,500 desired results ....Right now, it's adding everything.

sum({$<Aspect = {SalesOrder*',' Inventory','Open PO'}>}Value)

Tks.

Re: Format to negative in Set analysis

Clever_Anjos — Thu, 26 Jun 2014 00:01:57 GMT

sum({$<Aspect = {SalesOrder*',' Inventory','Open PO'}>} Value*if(Aspect like 'SalesOrder*'',-1,1) )

Re: Format to negative in Set analysis

Anonymous — Thu, 26 Jun 2014 00:08:19 GMT

Thank you, Clever...It worked... Anyway, may I know what does the -1,1 mean?

Re: Format to negative in Set analysis

Clever_Anjos — Thu, 26 Jun 2014 00:15:21 GMT

I´m multiplying by -1 the number when Aspect like 'Sales*' doing that is same thing then subtracting.

By the way... I think you should mark my answer as correct, right? Could you kindly do that?