Qlik Community

Qlik Sense App Development

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

sth_wch004
New 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
sth_wch004
New Contributor III

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

Thank  Sunny Talwar,

Load only latest record for each unique id

This is exactly what I wan..

5 Replies
arvind_patil
Valued Contributor II

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

Hi Chris,

Your Expression may like below:

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

CompletedSmiley Frustratedum ({<Date={'$(=max(Date))'}Status={"Completed"}>}Quantity)


Thanks,

Arvind Patil

sth_wch004
New Contributor III

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

Thank for your reply,

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

Capture.JPG

arvind_patil
Valued Contributor II

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

Hi Chris,

From the property add lable what you want.

Thanks,

Arvind Patil

sth_wch004
New Contributor III

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

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

sth_wch004
New Contributor III

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

Thank  Sunny Talwar,

Load only latest record for each unique id

This is exactly what I wan..

Community Browser