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.
Hi all, I'm trying to show in as a KPI chart the latest date in which other field has data greater than zero.
This is what I have:
In this example I'd need to show "mar-20" , which is the latest date where "things" has a value greater than zero.
Any ideas? I've tried to no avail:
Max(if ([things] = 0, date))
Thanks in advance.
Try this in KPI object.
Make sure the "date" field is a proper Date field, meaning it is not a text value.
View solution in original post
Thanks, that worked!
IDK why, but Max(if ([things] > 0, date)) also works..