Good day, I am new to Qlikview. I have loaded a File with detail claims paid Currency SARand and USD. I need to convert the USD to SARand on the Date of Loss of each claim. I have loaded a table witht the Rate on each day and linked the table with the original detail Claims paid. This works fine but as soon as I do a graph or table and it does not include the detail like the Claim number and Date of Loss my Rate is no longer linked. Is there another way I can link the Rate to the Date of Loss in the detail sheet? I have done an If in my Expressions =if(Currency='[SA Rand]',1,USD) but have the same problem?
