Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try a set expression:
sum({<[Dev_days] = {$(=max([Dev_days]))}>} [notices] )
Try a set expression:
sum({<[Dev_days] = {$(=max([Dev_days]))}>} [notices] )
Thank you! That worked perfectly, and now I know there are things called "sets" in Qlikview to search in the future.