Exclude fields in expression sum

pauledrich — Thu, 01 Aug 2013 08:42:13 GMT

Hi,

I am attempting to display the result of total sales but want to exclude 2 specific fields from the calculation where sales have been made - this is the expression I have used which I am sure isn't quite right:-

=Sum({$<Field1-={">$(=.00)"},Field2=>}Sales)

I have seen the thread below which will come in handy I am sure but a bit beyond my skillset just yet.

http://community.qlik.com/thread/64281

Re: Exclude fields in expression sum

tresB — Thu, 01 Aug 2013 08:52:46 GMT

Say, you have three fields like Year, Product, Sales. Now,

sum( {$<Year = {“*”} – {2013}, Product = >} Sales ) // this will exclude the sales of 2013 irrespective of the selection in the year field, and for the Product dimension selection is ignored (all the products would be considered in the sales).

hope this gives you an idea.

topic Exclude fields in expression sum in QlikView

Exclude fields in expression sum

Re: Exclude fields in expression sum