topic Re: Qlik Sense - Map Chart show max date record(text) in App Development

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

sth_wch004 — Thu, 12 Jul 2018 03:04:03 GMT

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 — Thu, 12 Jul 2018 07:32:07 GMT

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 — Thu, 12 Jul 2018 08:10:46 GMT

Thank for your reply,

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

arvind_patil — Thu, 12 Jul 2018 08:37:37 GMT

Hi Chris,

From the property add lable what you want.

Thanks,

Arvind Patil

sth_wch004 — Thu, 12 Jul 2018 08:50:48 GMT

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 — Mon, 16 Jul 2018 01:17:53 GMT

Thank Sunny Talwar,

This is exactly what I wan..