Subsetting data WITHOUT selecting

[#1]

Hello,

I'm new to Qlikview, and still wrapping my head around the syntax/logic of Qlickview expressions.   My data in cumulative, similar to the table given below, and I'm trying to make a series of charts out of it.  The first two charts are line charts showing trend lines for all days selected by the max/min of a slider bar.  The third chart is supposed to be a pie chart showing the distribution of "Type" AT THE MAX DEVELOPMENT DAY SELECTED.  So, if the slider selects days 2-4, the pie chart should sum(notices) where "Development Days" = 4.  This would provide the trend to a point, and then the distribution between "Type" at the end point. 

I've been trying

Sum(If(NumMax([Dev_days])=[Dev_days],[notices],0))

but the results still change based on the minimum. 

Development Days	Type	Notices
1	A	2
2	A	8
3	A	11
4	A	14
5	A	17
1	B	3
2	B	7
3	B	12
4	B	16
5	B	21
6	B	24

Thank you in advance for your help!

[swuehl · Accepted solution]

Try a set expression:

sum({<[Dev_days] = {$(=max([Dev_days]))}>} [notices] )

[#3]

Thank you!  That worked perfectly, and now I know there are things called "sets" in Qlikview to search in the future.