topic Re: Currency convert in QlikView https://community.qlik.com/t5/QlikView/Currency-convert/m-p/636858#M1090441 <HTML><HEAD></HEAD><BODY><P>Thanks for you help</P></BODY></HTML> Tue, 03 Jun 2014 09:33:37 GMT 2014-06-03T09:33:37Z Currency convert https://community.qlik.com/t5/QlikView/Currency-convert/m-p/636854#M1090437 <HTML><HEAD></HEAD><BODY><P>i have a table with field currency. it represent the currency in crore, i have buttons in my sheet like LAKES, AND THOUSANDS</P><P>IF i click on lakes the crore data will convert into lakes and similar the same how can i do this.</P><P></P><P></P><P>Please help me</P></BODY></HTML> Tue, 03 Jun 2014 08:54:29 GMT https://community.qlik.com/t5/QlikView/Currency-convert/m-p/636854#M1090437 2014-06-03T08:54:29Z Re: Currency convert https://community.qlik.com/t5/QlikView/Currency-convert/m-p/636855#M1090438 <HTML><HEAD></HEAD><BODY><P>Create a variable say vRate. On click of button 'lakhs', set this variable value to 100, on click of 'thousand' button set it's value to 10000. Now if you write your expression like: =Sum(YourCroreValue)*$(vRate) , you get your desired output on button click. Sample attached.</P></BODY></HTML> Tue, 03 Jun 2014 09:01:54 GMT https://community.qlik.com/t5/QlikView/Currency-convert/m-p/636855#M1090438 tresB 2014-06-03T09:01:54Z Re: Currency convert https://community.qlik.com/t5/QlikView/Currency-convert/m-p/636856#M1090439 <HTML><HEAD></HEAD><BODY><P>it is converted , but when i click on other button it is not changing the values</P></BODY></HTML> Tue, 03 Jun 2014 09:15:28 GMT https://community.qlik.com/t5/QlikView/Currency-convert/m-p/636856#M1090439 2014-06-03T09:15:28Z Re: Currency convert https://community.qlik.com/t5/QlikView/Currency-convert/m-p/636857#M1090440 <HTML><HEAD></HEAD><BODY><P>Check my attached sample</P></BODY></HTML> Tue, 03 Jun 2014 09:19:18 GMT https://community.qlik.com/t5/QlikView/Currency-convert/m-p/636857#M1090440 tresB 2014-06-03T09:19:18Z Re: Currency convert https://community.qlik.com/t5/QlikView/Currency-convert/m-p/636858#M1090441 <HTML><HEAD></HEAD><BODY><P>Thanks for you help</P></BODY></HTML> Tue, 03 Jun 2014 09:33:37 GMT https://community.qlik.com/t5/QlikView/Currency-convert/m-p/636858#M1090441 2014-06-03T09:33:37Z