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!
