Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this?
Min({<Year=,Month=>}Aggr(If(Sum({<Year=,Month=>} OutstandingAmount) <> 0, Invoicedate), customer, [invoice no], [invoice date]))
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)
Solved it!