Set chart to pick max date by default

[#1]

Hello,

Find attached.

[MarcoWedel · Accepted solution]

Hi,

one solution could be:

default / without selection:

but still showing the result for a selected Month:

Using this chart expression:

Sum({$<MonthName={'$(=Date(Max(MonthName),'YYYY/MMM'))'}>} Data)

and changing your load script to generate an additional MonthName field during load instead of a list box with expression to do so:

table1:
CrossTable(Month, Data, 3)
LOAD Year, 
     Revenue, 
     Station, 
     Jan, 
     Feb, 
     Mar, 
     Apr, 
     May, 
     Jun, 
     Jul, 
     Aug, 
     Sep, 
     Oct, 
     Nov, 
     Dec
FROM
[http://community.qlik.com/servlet/JiveServlet/download/682486-142273/period.xlsx]
(ooxml, embedded labels, table is Sheet1);

Left Join
LOAD Distinct
  Year,
  Month,
  Date#(Year&'/'&Month, 'YYYY/MMM') as MonthName
Resident table1;

hope this helps

regards

Marco