topic Re: A/R Report Question in QlikView

A/R Report Question

Anonymous — Fri, 01 Apr 2016 22:28:42 GMT

Hello all:

I have an Accounts Receivable (A/R) report below:

1. Dimensions as shown in the first 5 columns.

2. (Measure) Open AR $ = Work Billed $ - Cash Received $.

3. A Date field (not shown), which contains the 'Work Billed' date.

4. The same Date field (also not shown) which contains the 'Cash Received' date.

When I do not include the Date field, I get the correct report below.

But, I need to add the 'Due Date' which is equal to the 'Work Billed Date' + 'Customer Payment Terms Date'. When I add this date, I get the report shown in the second screen shot.

I need to remove the null value date rows from the the second report. I have tried several If and Set approaches to no avail and could use some feedback from the Community.

Thanks,

Edward

Re: A/R Report Question

sunny_talwar — Fri, 01 Apr 2016 22:37:28 GMT

May be this:

If([Open AR] > 0, YourDueDateExpressionHere)

Re: A/R Report Question

swuehl — Fri, 01 Apr 2016 22:44:38 GMT

Sorry, I don't understand your setting.

It's not totally clear what your dimensions and expressions are, also some fields suddenly pop in your description like 'Customer Payment Terms Date' without being introduced.

How these fields are related to each other is totall unclear.

In general, use aggregation functions in your expressions, I assume your measure is missing that:

Use Aggregation Functions!

If this doesn't help, please post a more complete description of your setting, e.g. by posting a small sample QVW.

Regards,

Stefan