Hello Team,
I want to compare the one currency to the local currency .
for eg the data table i have ,
Main Currency
Exchange rate
![Qlik3.PNG Qlik3.PNG](https://community.qlik.com/t5/image/serverpage/image-id/88040i1D33F1A5DB3D64ED/image-size/large?v=v2&px=999)
I want on UI as if we select USD and other exchange Rate in Cur_Id if we choose CAD it should show the CAD values
How to do it ?