topic Need Help Regarding Currency Conversions in QlikView https://community.qlik.com/t5/QlikView/Need-Help-Regarding-Currency-Conversions/m-p/234264#M85720 <HTML><HEAD></HEAD><BODY><P>Hi to All ,</P><P></P><P>I need help regarding currency conversions in qlikview</P><P>my data is like this</P><P>from currency to currency date conversion rate conversion factor</P><P><IMG src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAfsAAABOCAIAAAComSj3AAAGdklEQVR4nO3d2WGkMBBFUdJSQqRDNiRDMMwHm1TaBbQH1T1fNsbuRgUFDZg3rAAAHYa/fgMAgB+h4wOAFnR8ANCCjg8AWtDx8S5jpuWv3wOAjdvx53E4jfO6TGYYrg12mYyZlnm8Ji2TGTRu0E4X24Zl++IYPDMt9rfbcOokhuIYuXNVOwfGmxL4LWEenVUxMXPBy92a391UtjdjzTiP0WX4gvSyH/OkapEo7jFLvtwQrDEvdnX8ZTJ2RedxnJfJmHE0VknMtKzrPO7z2c1flVDHtwdjHrf9pbsN6Gz62xpzLPs+SucqtExm+8qf4v+Wbe8P7pDHZi56uRvzr4EtRXxrvvtZJ7PsBbXw/oK1bZzlSlYQghzzYlfHn/xV8jyoP8t1HsyaaYnVX4FIx3dHY5nCHwWUcdcQsUqFRi8wUJGxC08+pl4fQMternb+0FLtP1kmY6b5mHEeh3H6bvUzy76mfhQrtzV3ebkhNI3T1fED7Vsc1IsdszFK+33krM7+wfUcFFkPb5egUGDvuH3tT/F/K/bXIhODHTzxcrXz+y95tnx7Mc/Do682sfSyH1K1CP6F8zxPZP/53AJ0627HT288Yq3VXZXUwfu2JouzOvsPlHd86wN8RUuNf8YPrITBmWs7ePMO6Xh19yBAHC19TXPHT5Tb2c26f5JTOsVudvzAQLufvZxPph9egx+QO11jHdylZlPFvc5Retokuf0H9qnBmWvP0tTN716hPy7aX58zjs721eq3ndVJltuZ2f6Gdl/jZsePXLm1tz33bgTFpbHXy32jXqbrJFdgtZ5HrVdu1zVwT1fRpdHsnWDy2rjfia9j76qXq7ly607YWpa/dXx5e4mMVfzMW77c1uZg7xRp91VudvxVHK345yXEfZmaq2OP1HW1zp3kjKbmwQodBRfc/hj6rfDfPG4k9g60ncPMzMtVz3/+ln9sO3fV8SNjdY1DvhYFd2emyw1BjHk5/gMLALSg4wOAFnR8ANCCjg8AWtDxAUALOj4AaEHHBwAt6PgAoAUdHwC0oOMDgBZ0fLzry08XAHpjPx9/kA9qEI+62B4YMvQU59aI1MNyYiishIWSB92kn7JC6uFfKRw9UY2ienU3Vu+5l3oYiOgLPwKwnzi3ZqQeltueo5WLwQs9oJHUw/9VLgcx8Bj9wnrN42CPHGLkeBaLJKLEgnuWnuLc2pF6WI7Uw+42k+wT8yPBKel6nV9p3VKq3XxaciCwyX+Aqb0BxPYKCpB62CiwdyT18HOyqVjXWR1noZP18ho/cl7p+JHHfHcR59aO1MMmpB72oSwHcf+ptdipeslrhoOZ3njrXXmy4yfP6hwF+nqcWztSD+uRethN9ctyEP0fF9arq7F603Md/8gkS3T8e6/6daQe1rlOmOxIPfy0TA7ieVVWDFa6XsHZkHC34/s3VMlPWv3FubWyR+Y6++hOckZP4RhdAkfBpB5+WzIH0SqGfRSUqdept7F6hRjPcvwHFgBoQccHAC3o+ACgBR0fALSg4wOAFnR8ANCCjg8AWtDxAUALOj4AaEHHBwAt6Ph4F/8xD/w/SD1sQephOTEUx8iRetiZ2hzEhnJDIPXwV0g9LLc9No3Uw743k9ocxNpyQ5DrfzFSD1uQeliO1EMFm0ltDmJTuSE8mYhC6mESqYeNAntHUg87UJuD2FRuCK90/MhjvjuNcytF6mETUg97VZuD2FRuCE92/ORZnX7j3EqReliP1MOOq1+bg9hUbgjPdXxSDzNIPazjxEutK6mH3anNQWwpN4S7HV/ePhW5O1PZqhxmj8x1tc6d5IyewjG6BI6CST3sTW0OYl25IYj1vxz/gQUAWtDxAUALOj4AaEHHBwAt6PgAoAUdHwC0oOMDgBZ0fADQgo4PAFrQ8QFACzo+3tX70wWALyH1sAWph+XEUBwjR+qhQrXJiEgj9fBXSD0stz02TQTakXqoUG0yIhLk+l+M1MMWpB6WI/VQ7Wbiqk1GRM4rGVjiAab2BhDbKyhA6mGjwN6R1EMlapMRkfNKx4885ltNnFsYqYdNSD3UrDYZ8Tfv6sue7PjJszqa4tzCSD2sR+qh5uqv9cmIP3pbH/Zcxyf1MIPUwzpeoB2phwrVJiMi427H92+NCt6dyaq8knpYJ3AUTOqhRrXJiIgS6385/gMLALSg4wOAFnR8ANCCjg8AWtDxAUALOj4AaEHHBwAt/gHiwKzDIJGP3AAAAABJRU5ErkJggg==" /></P><P></P><P></P><P>I need to convert the BRL's HKD's etc,,,</P><P>I have to calculate the billing value i tried in this way while writing expression in a pivot chart</P><P>if( pricing date=date,conversion rate*conversion Factor,0)</P><P>it says expression is ok but not displaying any results</P><P></P><P>Thanking u all a lot ...</P><P>Bradd</P></BODY></HTML> Thu, 28 Apr 2011 20:48:36 GMT 2011-04-28T20:48:36Z Need Help Regarding Currency Conversions https://community.qlik.com/t5/QlikView/Need-Help-Regarding-Currency-Conversions/m-p/234264#M85720 <HTML><HEAD></HEAD><BODY><P>Hi to All ,</P><P></P><P>I need help regarding currency conversions in qlikview</P><P>my data is like this</P><P>from currency to currency date conversion rate conversion factor</P><P><IMG src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAfsAAABOCAIAAAComSj3AAAGdklEQVR4nO3d2WGkMBBFUdJSQqRDNiRDMMwHm1TaBbQH1T1fNsbuRgUFDZg3rAAAHYa/fgMAgB+h4wOAFnR8ANCCjg8AWtDx8S5jpuWv3wOAjdvx53E4jfO6TGYYrg12mYyZlnm8Ji2TGTRu0E4X24Zl++IYPDMt9rfbcOokhuIYuXNVOwfGmxL4LWEenVUxMXPBy92a391UtjdjzTiP0WX4gvSyH/OkapEo7jFLvtwQrDEvdnX8ZTJ2RedxnJfJmHE0VknMtKzrPO7z2c1flVDHtwdjHrf9pbsN6Gz62xpzLPs+SucqtExm+8qf4v+Wbe8P7pDHZi56uRvzr4EtRXxrvvtZJ7PsBbXw/oK1bZzlSlYQghzzYlfHn/xV8jyoP8t1HsyaaYnVX4FIx3dHY5nCHwWUcdcQsUqFRi8wUJGxC08+pl4fQMternb+0FLtP1kmY6b5mHEeh3H6bvUzy76mfhQrtzV3ebkhNI3T1fED7Vsc1IsdszFK+33krM7+wfUcFFkPb5egUGDvuH3tT/F/K/bXIhODHTzxcrXz+y95tnx7Mc/Do682sfSyH1K1CP6F8zxPZP/53AJ0627HT288Yq3VXZXUwfu2JouzOvsPlHd86wN8RUuNf8YPrITBmWs7ePMO6Xh19yBAHC19TXPHT5Tb2c26f5JTOsVudvzAQLufvZxPph9egx+QO11jHdylZlPFvc5Retokuf0H9qnBmWvP0tTN716hPy7aX58zjs721eq3ndVJltuZ2f6Gdl/jZsePXLm1tz33bgTFpbHXy32jXqbrJFdgtZ5HrVdu1zVwT1fRpdHsnWDy2rjfia9j76qXq7ly607YWpa/dXx5e4mMVfzMW77c1uZg7xRp91VudvxVHK345yXEfZmaq2OP1HW1zp3kjKbmwQodBRfc/hj6rfDfPG4k9g60ncPMzMtVz3/+ln9sO3fV8SNjdY1DvhYFd2emyw1BjHk5/gMLALSg4wOAFnR8ANCCjg8AWtDxAUALOj4AaEHHBwAt6PgAoAUdHwC0oOMDgBZ0fLzry08XAHpjPx9/kA9qEI+62B4YMvQU59aI1MNyYiishIWSB92kn7JC6uFfKRw9UY2ienU3Vu+5l3oYiOgLPwKwnzi3ZqQeltueo5WLwQs9oJHUw/9VLgcx8Bj9wnrN42CPHGLkeBaLJKLEgnuWnuLc2pF6WI7Uw+42k+wT8yPBKel6nV9p3VKq3XxaciCwyX+Aqb0BxPYKCpB62CiwdyT18HOyqVjXWR1noZP18ho/cl7p+JHHfHcR59aO1MMmpB72oSwHcf+ptdipeslrhoOZ3njrXXmy4yfP6hwF+nqcWztSD+uRethN9ctyEP0fF9arq7F603Md/8gkS3T8e6/6daQe1rlOmOxIPfy0TA7ieVVWDFa6XsHZkHC34/s3VMlPWv3FubWyR+Y6++hOckZP4RhdAkfBpB5+WzIH0SqGfRSUqdept7F6hRjPcvwHFgBoQccHAC3o+ACgBR0fALSg4wOAFnR8ANCCjg8AWtDxAUALOj4AaEHHBwAt6Ph4F/8xD/w/SD1sQephOTEUx8iRetiZ2hzEhnJDIPXwV0g9LLc9No3Uw743k9ocxNpyQ5DrfzFSD1uQeliO1EMFm0ltDmJTuSE8mYhC6mESqYeNAntHUg87UJuD2FRuCK90/MhjvjuNcytF6mETUg97VZuD2FRuCE92/ORZnX7j3EqReliP1MOOq1+bg9hUbgjPdXxSDzNIPazjxEutK6mH3anNQWwpN4S7HV/ePhW5O1PZqhxmj8x1tc6d5IyewjG6BI6CST3sTW0OYl25IYj1vxz/gQUAWtDxAUALOj4AaEHHBwAt6PgAoAUdHwC0oOMDgBZ0fADQgo4PAFrQ8QFACzo+3tX70wWALyH1sAWph+XEUBwjR+qhQrXJiEgj9fBXSD0stz02TQTakXqoUG0yIhLk+l+M1MMWpB6WI/VQ7Wbiqk1GRM4rGVjiAab2BhDbKyhA6mGjwN6R1EMlapMRkfNKx4885ltNnFsYqYdNSD3UrDYZ8Tfv6sue7PjJszqa4tzCSD2sR+qh5uqv9cmIP3pbH/Zcxyf1MIPUwzpeoB2phwrVJiMi427H92+NCt6dyaq8knpYJ3AUTOqhRrXJiIgS6385/gMLALSg4wOAFnR8ANCCjg8AWtDxAUALOj4AaEHHBwAt/gHiwKzDIJGP3AAAAABJRU5ErkJggg==" /></P><P></P><P></P><P>I need to convert the BRL's HKD's etc,,,</P><P>I have to calculate the billing value i tried in this way while writing expression in a pivot chart</P><P>if( pricing date=date,conversion rate*conversion Factor,0)</P><P>it says expression is ok but not displaying any results</P><P></P><P>Thanking u all a lot ...</P><P>Bradd</P></BODY></HTML> Thu, 28 Apr 2011 20:48:36 GMT https://community.qlik.com/t5/QlikView/Need-Help-Regarding-Currency-Conversions/m-p/234264#M85720 2011-04-28T20:48:36Z Need Help Regarding Currency Conversions https://community.qlik.com/t5/QlikView/Need-Help-Regarding-Currency-Conversions/m-p/234265#M85721 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can create a data model to better solve this kind of problem.</P><P>Please, check this previous post with a lot of examples:</P><P><A href="http://community.qlik.com/forums/t/38309.aspx">http://community.qlik.com/forums/t/38309.aspx</A></P><P></P></BODY></HTML> Thu, 28 Apr 2011 21:23:51 GMT https://community.qlik.com/t5/QlikView/Need-Help-Regarding-Currency-Conversions/m-p/234265#M85721 erichshiino 2011-04-28T21:23:51Z