topic SUM IFS in Pivot Table in QlikView

SUM IFS in Pivot Table

Thu, 29 Jan 2015 15:40:54 GMT

Hi,

the below formula does not sum the Or 'Updated transaction',

I need both New and Updated transactions to be summed, right now only the New transactions part work.

Any ideas why?

SUM(IF([ILM RESPONSIBLE]='YES',IF([TRANSACTION STATUS]='New transaction' Or 'Updated transaction', AMOUNT)))

m_woolf — Thu, 29 Jan 2015 16:13:34 GMT

Try:

SUM(IF([ILM RESPONSIBLE]='YES',IF([TRANSACTION STATUS]='New transaction' Or ([TRANSACTION STATUS]='Updated transaction', AMOUNT)))

Fri, 30 Jan 2015 08:29:30 GMT

thanks!