6 Replies Latest reply: Apr 11, 2014 3:14 PM by Matt Maino RSS

    Need help creating expression in a chart

    Matt Maino

      Hi everyone,

       

      I have imported a few fields into a new qlikview worksheet and am interested in adding an expression to a chart based off of these fields, but am having a bit of trouble doing so. I have one field that contains a dollar amount, and another that contains a number of days past due. What I would like to do is create an expression in a line graph that sums the dollar amount fields, but only for a specific window of days past due. For example - I would need to know the summation of all the current balances that are in the 5-10 days past due range. Would anybody know how to do this using Qlikview syntax rather than creating a whole new field in the import script.

       

      Thank you.