Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, there.
I'm trying something like described in this post: How exclude Rows from table? | Qlik Community. But, for some unknown reason (at last for me), the IF statement is never true. An example is attached, if someone can help, I appreciate.
Thanks.
C.
Try this:
=Aggr(If(Max(TOTAL <Doc>[Date]) = Date,'Yes','No'), Doc, Code, Date)
Try this:
=Aggr(If(Max(TOTAL <Doc>[Date]) = Date,'Yes','No'), Doc, Code, Date)
No clue why your If statement does not work (except that apparently it is wrong), but here is an alternative solution:
Assuming the table you load first is called "Source", add this to your script:
DateTmp:
Left Join(Source)
Load
Doc,
date(max(Date)) as MaxDate
Resident Source
group by Doc
;
After that, you can add this expression to your chart:
If(Date = MaxDate, 'Yes', 'No')
Thank you so much!
Thank you so much!
Both are correct answer! Unfortunately I can choose only one, so I checked the first one. But in the attach I implemented both.
Thanks again, @Sunny and @Onno.
Best regards!