Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Max year

i have a question.

We have a table containing, amongst other fields, a property code, a value at a specific date, a date, a month and a year field

we want to select the value of the PROP_UNIT_ARE field on a date that has been selected in the calender.

we're using the this statement;  max({$<Year={'>=$(PROP_UNIT_DATE_YEAR)'}>}PROP_UNIT_AREA) 

A sample file is attached.

Anyone have a clue?

Thanks in advance

0 Replies