topic Re: Sum of amounts but exclude 2 dimensions in QlikView

Sum of amounts but exclude 2 dimensions

chriscools — Thu, 12 Jul 2012 19:10:59 GMT

Hello,

i want to make an overwiew table in which to monitor total sales per shop.

but since we have 2 testshops i don't want to include them in the table.

as an expression i found to do it like this:

Sum (if (shop <> Testshop, LineSalesAmount))

But that does not work, it gives me nothing.

i also tried it like this:

Sum (if (shop <> 'Testshop', LineSalesAmount))

but that also didn't work...

what do i do wrong?

and how should i exclude a second one?

thanx!

chris

MayilVahanan — Thu, 12 Jul 2012 19:14:58 GMT

Hi,

Try this,

=Sum({<Shop -= {'Testshop'}>}LineSalesAmount)

Can you post a sample.. or what is the second one..

=Sum({<Shop -= {'Testshop','Testshop2'}>}LineSalesAmount)

Hope it helps..

chriscools — Fri, 13 Jul 2012 10:09:07 GMT

Hello,

thank you very much for your reply, it works perfect!!!

thanx!!

chris