topic Re: Show Dimension of Latest Date in App Development

Show Dimension of Latest Date

Anonymous — Mon, 19 Feb 2018 11:48:08 GMT

Hi All,

I have a issue where I have below sample data:

Date | Name

-----------------------------------

20180101 | Richard

20180201 | Emily

Where I want to show column Name with latest Date (20180201), like below output

Date | Name

-----------------------------------

20180201 | Emily

I have try below method:

=IF(TEXT(COUNT({$<Date_Dup={$(=num#(date(max([Date.autoCalendar.YearMonth]),'YYYYMMDD')))}>}SEQ))='1',Name)

* Date_Dup data type is general, is duplicate date I create based on Date field

However the output I gain is

Which the field I created is a measure.

What I want is it only show latest records only.

Re: Show Dimension of Latest Date

sunny_talwar — Mon, 26 Feb 2018 17:04:44 GMT

May be uncheck 'Include Zero Values' under Add-ons -> Data handling

Re: Show Dimension of Latest Date

pablolabbe — Wed, 28 Feb 2018 09:05:10 GMT

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others