topic If then conditional in QlikView

If then conditional

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have a problem concerning conditional formatting.

I have two charts, one "overview" and one "detail" (see below)

This problem is the second table with the "oldest" invoice. I only want to see to oldest invoice of outstanding amounts (1/1/2015), not the oldest invoice of that customer in total (1/1/2013).

I thought I could fix this with:

=if(sum({<Year=,Month=>} OutstandingAmount)<>0, min({$<Year=,Month=,Paid={'No'}>}Invoicedate))

But this does not work. I understand why. He thinks "idd, this customer has got an oustanding amount, so OutstandingAmount <> 0, I will now look at the oldest invoice date of this customer".

How do I tell Qlikview to only look at the dates of the outstanding invoices and show me the oldest one of those? Is that with an AND expression?

Can anybody help me?

Thanks in advance

Re: If then conditional

sunny_talwar — Fri, 20 Jan 2017 11:59:03 GMT

May be this?

Min({<Year=,Month=>}Aggr(If(Sum({<Year=,Month=>} OutstandingAmount) <> 0, Invoicedate), customer, [invoice no], [invoice date]))

Re: If then conditional

Fri, 20 Jan 2017 12:06:27 GMT

Do I have to add all the dimension names between squared brackets? Is that what you did with [invoice no] and [invoice date]?

(I gave you a simplified table, I have more expressions and dimensions)

Re: If then conditional

Fri, 20 Jan 2017 13:39:30 GMT

Solved it!