10 Replies Latest reply: Jun 2, 2015 8:51 AM by Michael Solomovich RSS

    Getting my straight table to match up to slider parameters

      Hi Qlik Community,

       

       

      Having issues with my slider and was hoping someone could help out.

       

       

       

       

       

       

      I have a slider with the following expression:

       

      =aggr(sum({1} tran_amt), id)

       

       

       

       

      My understanding is that it is supposed to aggregate the transaction amount based on the ID.

       

       

      When I make the following selection in the slider: $1,040min and $1,526 max

       

       

       

       

       

       

       

       

       

       

       


      I get a table with the right max (or so I think)

       

        but the minimum goes below $1,040:

      Can someone please explain to me what I'm doing wrong? I've been having the same issue with other tables. The max seems to be taken into account but the min is not.

       

      The table dimension is set to the ID and the expression reads sum(tran_amt) .



      THANKS SO MUCH!