Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Min date by dimension

Hi, I would like to get an expression built where I am able to see a minimum service date by a specific dimension (in this case a patient record number). I'm sure this is simple, but haven't found an example in the discussion forums.

13 Replies
Not applicable
Author

I'm still getting all the years populated.

sunny_talwar

Can you show the image of what you are seeing?

Not applicable
Author

I needed to suppress zero values, but otherwise the expression worked. If you have a minute, do you mind explaining how adding the Avg(1) at the end fixed the expression? Thank you so much for your support.

sunny_talwar

Avg(1) will equal to one for your selected years and will equal 0 for years out of selection.... So, basically the first part of the expressions shows the value for all years, but the second part (Avg(1)) forces it to show only the value for selected years....

Another way to do this would to do something like this (using if statement)

If(Year, Min({<Year>} TOTAL <[Patient Record Number]> Date))