Qlik Sense - Map Chart show max date record(text)

[sth_wch004]

Dear Community,

How to show Max Date record(text) in map chart by default? 

Expected result: -

should default to max date record instead of select the date 02/07/2018(selection).

Attached qvf file & kml file.

[Data]:

Load * inline

[

Block, Date, Quantity, Status,

B1, '01/07/2018', 100, 'In Progress'

B2, '01/07/2018', 200, 'In Progress'

B3, '01/07/2018', 300, 'In Progress'

B1, '02/07/2018', 100, 'In Progress'

B2, '02/07/2018', 200, 'In Progress'

B3, '02/07/2018', 300, 'Completed'

]

;

[arvind_patil]

Hi Chris,

Your Expression may like below:

In Progress:Sum ({<Date={'$(=max(Date))'}Status={"In Progress"}>}Quantity)

Completed:Sum ({<Date={'$(=max(Date))'}Status={"Completed"}>}Quantity)

Thanks,

Arvind Patil

[sth_wch004]

Thank for your reply,

What I want to display is the status( In Progress or Completed ) not the quantity.

[arvind_patil]

Hi Chris,

From the property add lable what you want.

Thanks,

Arvind Patil

[sth_wch004]

Thanks,

That's what i am doing now, any help is appreciated.

1) This is my expected result. but should be without the date selection(default to max date)

2) This is my output now.

[sth_wch004 · Accepted solution]

Thank  Sunny Talwar,

Load only latest record for each unique id

This is exactly what I wan..