Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

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

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'

]

;

Capture.JPG

1 Solution

Accepted Solutions
Contributor III
Contributor III

Thank  Sunny Talwar,

Load only latest record for each unique id

This is exactly what I wan..

View solution in original post

5 Replies
Partner
Partner

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

Contributor III
Contributor III

Thank for your reply,

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

Capture.JPG

Partner
Partner

Hi Chris,

From the property add lable what you want.

Thanks,

Arvind Patil

Contributor III
Contributor III

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)Capture.JPG

2) This is my output now.

Capture.JPG

Contributor III
Contributor III

Thank  Sunny Talwar,

Load only latest record for each unique id

This is exactly what I wan..

View solution in original post