Subsetting data WITHOUT selecting

Thu, 26 Apr 2012 20:29:45 GMT

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!

Subsetting data WITHOUT selecting

swuehl — Thu, 26 Apr 2012 21:18:07 GMT

Try a set expression:

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

Subsetting data WITHOUT selecting

Thu, 26 Apr 2012 21:48:02 GMT

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

topic Subsetting data WITHOUT selecting in QlikView

Subsetting data WITHOUT selecting

Subsetting data WITHOUT selecting

Subsetting data WITHOUT selecting