topic Dynamically apply the currency conversion on the currently active level in an entity hierarchy drill down/ cyclic group in QlikView https://community.qlik.com/t5/QlikView/Dynamically-apply-the-currency-conversion-on-the-currently/m-p/607467#M224319 <HTML><HEAD></HEAD><BODY><P>Dear Community users,</P><P></P><P>There is a finance dashboard problem involving multiple currencies.</P><P></P><P>[Region(ASIA), Regional Currency-USD] -&gt; [Company(Australia/NZ), Company Currency-AUD] -&gt; [Entity(Australia),Entity Currency-AUD] OR [Entity(NZ), Entity Currency-NZD].</P><P></P><P>The transactional data is mapped at the lowest level i.e. entity and hence the local currency is applied at the this level. The data has to be aggregated with respective currency exchange rates at higher levels.</P><P></P><P>BR,</P><P>Rishit </P></BODY></HTML> Mon, 07 Apr 2014 04:12:44 GMT 2014-04-07T04:12:44Z Dynamically apply the currency conversion on the currently active level in an entity hierarchy drill down/ cyclic group https://community.qlik.com/t5/QlikView/Dynamically-apply-the-currency-conversion-on-the-currently/m-p/607467#M224319 <HTML><HEAD></HEAD><BODY><P>Dear Community users,</P><P></P><P>There is a finance dashboard problem involving multiple currencies.</P><P></P><P>[Region(ASIA), Regional Currency-USD] -&gt; [Company(Australia/NZ), Company Currency-AUD] -&gt; [Entity(Australia),Entity Currency-AUD] OR [Entity(NZ), Entity Currency-NZD].</P><P></P><P>The transactional data is mapped at the lowest level i.e. entity and hence the local currency is applied at the this level. The data has to be aggregated with respective currency exchange rates at higher levels.</P><P></P><P>BR,</P><P>Rishit </P></BODY></HTML> Mon, 07 Apr 2014 04:12:44 GMT https://community.qlik.com/t5/QlikView/Dynamically-apply-the-currency-conversion-on-the-currently/m-p/607467#M224319 2014-04-07T04:12:44Z