Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Find attached.
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
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