topic Straight Table: sum(amount) when condition is fulfilled... in QlikView

Straight Table: sum(amount) when condition is fulfilled...

Tue, 10 Jan 2012 07:44:26 GMT

Hello,

I'm making a straight table with a sum of purchases shown for each month. This first column is for cloths, the next for household goods etc...

making the sum is not difficult: Sum(amount) but when I add an 'if' so I only include items that are cloths (for example Goods='cloths') the result is always zero.

Whats wrong with this statement as expression:

=if(Goods='Cloths',sum(Amount),0)

What should be changed?

Straight Table: sum(amount) when condition is fulfilled...

vijay_iitkgp — Tue, 10 Jan 2012 07:52:40 GMT

Hi,

Use Sum(If(Goods='Cloths',Amount))

Straight Table: sum(amount) when condition is fulfilled...

Tue, 10 Jan 2012 09:54:26 GMT

Thanks a lot!

Straight Table: sum(amount) when condition is fulfilled...

Tue, 10 Jan 2012 10:19:55 GMT

Just a small point - avoid using 'if' wherever possible as it has a perfomance overhead particularily with large amounts of data.

This should be more efficient:

sum(pick(match(Goods,'Cloths'), Amount))

Regrads,

Gordon