Discussion board where members can get started with Qlik Sense.
I have a excel table as below:
I would like to do in scripting level to always show it's latest exchange rate.
Please find below as my expected outcome:
select Year,Month,exchangeRate from table.xls
where year=max(year) and month=max(Month)
Thanks for the advice.
However it does not work.