Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show Value for Max Date

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!

1 Solution

Accepted Solutions
Not applicable
Author

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)


View solution in original post

1 Reply
Not applicable
Author

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)