0 Replies Latest reply: Jun 14, 2012 4:30 AM by andrishav RSS

    Converting SARand to USD

      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?