2 Replies Latest reply: Apr 26, 2012 5:48 PM by cswofford RSS

    Subsetting data WITHOUT selecting

      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 DaysTypeNotices
      1

      A

      2
      2A8
      3A

      11

      4A14
      5A17
      1B3
      2B7
      3B12
      4B16
      5B21
      6B24

       

       

      Thank you in advance for your help!