topic Re: Need help creating expression in a chart in QlikView

Need help creating expression in a chart

Fri, 11 Apr 2014 16:45:35 GMT

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.

Re: Need help creating expression in a chart

maxgro — Fri, 11 Apr 2014 16:52:11 GMT

something like

Sum ({$<d={">=$(=date(Today()-10))<=$(=date(Today()-5))"}>} amount)

Re: Need help creating expression in a chart

Fri, 11 Apr 2014 17:23:26 GMT

Massimo's expression should work if d=Due Date. Although if the field is already the Actual number of days past due then you just need

Sum ({$<DaysPastDue={">=5<=10))"}>} amount)

Re: Need help creating expression in a chart

Fri, 11 Apr 2014 17:50:52 GMT

This is what I need, but for some reason nothing displays in the chart after I put it in as an expression with all of the proper field names.

Re: Need help creating expression in a chart

maxgro — Fri, 11 Apr 2014 18:00:31 GMT

if possible, post your qlik doc

Re: Need help creating expression in a chart

Fri, 11 Apr 2014 18:31:07 GMT

H Mattew

Check the attached sample

Re: Need help creating expression in a chart

Fri, 11 Apr 2014 19:14:04 GMT

I was actually using the wrong field names - but once i fixed that this worked. Thank you.