not geting a result using sum and if

[Anonymous]

HI,

I have tried many things so I am hoping someone can shed some light on why my basic formula isn't working please.

The following is a sample of my table in QlikView:-

Account	RecordType	Purchased	Remaining
Dollys Flowers	Business advice	1	1
Dolly's Flowers	Call - HR	5	2
Dolly's Flowers	Call - HR	5	5
Justins Lande	Call - Business	5	4

I need to accomplish the following.  I.e. list all the accounts and summing up the 2 different call types.

Account	Calls-HR purch	Calls-HR Rem'g	Calls-Bus puch	Calls-Bus Rem'g
Dolly's Flowers	10	7	1	1
Justins Land	0	0	5	4

I have tried:-

=if(RecordType = 'Business advice', sum(Purchased))

=Sum({<RecordType ='Business advice'>} Purchased)

[sunny_talwar]

Try this:

=Sum({<RecordType = {'Business advice'}>} Purchased)

[sunny_talwar · Accepted solution]

You can also try a pivot table like this

[Anonymous]

thanks Sunny

[Anonymous]

Hi Sunny,

Ive gone with your circled suggestion above.  Ive needed to add another RecordType.  "Calls-BusHep" but  in the expression it sums a different field. its really a Record Type on its own, so i don't want =Sum(Quantity) to be seen under Calls or Calls-HR. I've tried if(Quantity <>'',sum(Quantity),'') so that results returns NULL rather than zero then I've tried suppressing in both presentation and under dimension.  but so far nothing is working:-

	Calls			Calls-HR			Calls-BusHelp
Account	=SUM(Purchased)	=SUM(Remaining)	=SUM(Quantity)	=SUM(Purchased)	=SUM(Remaining)	=SUM(Quantity)	=SUM(Purchased)	=SUM(Remaining)	=SUM(Quantity)
Dolly's Flowers	1	1	0	10	7	0	0	0	2
Justins Land	5	4	0	0	0	0	0	0	1