This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
=Aggr(If(Max(TOTAL <Doc>[Date]) = Date,'Yes','No'), Doc, Code, Date)
View solution in original post
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:
date(max(Date)) as MaxDate
group by Doc
After that, you can add this expression to your chart:
If(Date = MaxDate, 'Yes', 'No')
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.