Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
tan_chungkam
Contributor

Always show the latest Rate

Hi all,

I have a excel table as below:

image.pngTable

I would like to do in scripting level to always show it's latest exchange rate.

Please find below as my expected outcome:

image.pngExpected Outcome

Labels (1)
2 Replies
Channa
Valued Contributor III

Re: Always show the latest Rate

select Year,Month,exchangeRate from table.xls

where year=max(year) and month=max(Month)

Channa
tan_chungkam
Contributor

Re: Always show the latest Rate

Hi,

Thanks for the advice.

However it does not work.