topic sum a number with a condition in QlikView

sum a number with a condition

Thu, 02 Jun 2016 11:54:10 GMT

this i tha table that i have

what i need i very simple

i need 2 text boxex

1. sum all numbers of all areas (this i have)=1250

2. sum all numbers except D- the result should be=350 -this i need

arulsettu — Thu, 02 Jun 2016 11:56:16 GMT

try this

sum({<area1-={'D'}>}number)

sunny_talwar — Thu, 02 Jun 2016 11:57:09 GMT

Try these:

1) Sum(number)

2) Sum({<area1 -= {'D'}>}number) -> This would filter out area1 not selected (while still excluding D)

Sum({<area1 = {'*'} - {'D'}>}number) -> This would not change based on selection in area1

Anonymous — Thu, 02 Jun 2016 12:01:47 GMT

try this

1st text box ..>General..>Text...>

=sum(number)

2nd text box ..>General..>Text...>

=sum({$<area1=-{'D'}>} number)