Show Value for Max Date

Mon, 19 Jul 2010 17:40:45 GMT

I am using a date field named Month as a dimension for line chart, and cannot seem to Show Value for the line expression for only the most recent month. I have tried examples posted in this forum previously with no success. My attribute expression is:

=if(Month=(Max(Month), 1,0)

Thanks!

Show Value for Max Date

Mon, 19 Jul 2010 19:18:56 GMT

So you have a couple hiccups in your application:

1. Your Month field is not real month, it's fist date of month.

2. You have Month field and a variable with the same name - "Month". When you tries to do your expression, on left side it's variable and on right side it's the field.

I've attached fixed application. I've removed the Month variable. And the expression should be something like this:

=if(Month(Month)= Max(total month(Month)), 1,0)

topic Show Value for Max Date in QlikView

Show Value for Max Date

Show Value for Max Date