topic Stuck on expression in QlikView

Stuck on expression

Mon, 04 Feb 2013 12:42:55 GMT

Hello I have a problem with an expression :-

if([Contact Date]-Date<='7',money([Sum Paid]))

Contact Date refers to when the customer contacted me.

There are payments in the past and future of this date.

I am trying to link when the customer called me to pay and the payment clearing on account within a 7 day period. For some reason this is returning a null argh.

Please help.

Paul.

Re: Stuck on expression

hic — Mon, 04 Feb 2013 14:38:19 GMT

If this function is used somewhere in the UI, you need to have an aggregation function. Otherwise QlikView will most likely return NULL. See more on http://community.qlik.com/blogs/qlikviewdesignblog/2012/08/03/the-only-function

You probably want

Sum( if([Contact Date]-Date<='7',[Sum Paid]) )

will evaluate the date comparison for every record in the raw data, then sum over the records where the condition is true.

HIC