topic Re: Replace field value by value from another field in Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Replace-field-value-by-value-from-another-field-in-Set-Analysis/m-p/392367#M488058 <HTML><HEAD></HEAD><BODY><P>please find attached an example</P></BODY></HTML> Fri, 01 Feb 2013 09:06:56 GMT beeaj2011 2013-02-01T09:06:56Z Replace field value by value from another field in Set Analysis https://community.qlik.com/t5/QlikView/Replace-field-value-by-value-from-another-field-in-Set-Analysis/m-p/392362#M488053 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I've got a question, problably straightforward but I cannot find it myself.</P><P></P><P>I have got a datamodel with a field for Country and Currecy.</P><P></P><P>I want to have a dynamic formula structured like: </P><P></P><P style="font-size: 9px; font-family: 'Courier New';"><SPAN style="font-size: 12pt;"><SPAN style="color: #1b39f5;">Sum</SPAN> ({&lt;<SPAN style="color: #800000;">Currency_Code</SPAN> = <STRONG>{'EUR'}</STRONG> , <SPAN style="color: #9a0806;">COUNTRY</SPAN> = {'$(vMaxSI)'} &gt;} <SPAN style="color: #9a0806;">COUNTER</SPAN>) </SPAN></P><P></P><P style="font-size: 9px; font-family: 'Courier New';"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;">I need the hardcoded {'EUR'} part&nbsp; top be pickedup by the definition of COUNTRY which is calculated.</SPAN></P><P></P><P style="font-size: 9px; font-family: 'Courier New';"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;">Thanx for your help.</SPAN></P><P></P><P style="font-size: 9px; font-family: 'Courier New';"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;">Ton</SPAN></P><P style="font-size: 9px; font-family: 'Courier New';"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;"><BR /></SPAN></P><P style="font-size: 9px; font-family: 'Courier New';"><SPAN style="font-size: 12pt; font-family: arial, helvetica, sans-serif;"><BR /></SPAN></P><P></P><P style="font-size: 9px; font-family: 'Courier New';"><SPAN style="font-size: 12pt;"><BR /></SPAN></P></BODY></HTML> Fri, 01 Feb 2013 07:18:24 GMT https://community.qlik.com/t5/QlikView/Replace-field-value-by-value-from-another-field-in-Set-Analysis/m-p/392362#M488053 beeaj2011 2013-02-01T07:18:24Z Re: Replace field value by value from another field in Set Analysis https://community.qlik.com/t5/QlikView/Replace-field-value-by-value-from-another-field-in-Set-Analysis/m-p/392363#M488054 <HTML><HEAD></HEAD><BODY><P>Hey please explain in brief!!!!!</P></BODY></HTML> Fri, 01 Feb 2013 07:21:32 GMT https://community.qlik.com/t5/QlikView/Replace-field-value-by-value-from-another-field-in-Set-Analysis/m-p/392363#M488054 sujeetsingh 2013-02-01T07:21:32Z Re: Replace field value by value from another field in Set Analysis https://community.qlik.com/t5/QlikView/Replace-field-value-by-value-from-another-field-in-Set-Analysis/m-p/392364#M488055 <HTML><HEAD></HEAD><BODY><P>Actually it is not so complex, I know the country for which I should make the calculation, now I need to know the corresponding Currency_Code in the Set Analysis part of the expression, but the Code is not the selected country on the sheet so just pinting to the field "Currency_Code" won't be sufficient..</P></BODY></HTML> Fri, 01 Feb 2013 07:27:53 GMT https://community.qlik.com/t5/QlikView/Replace-field-value-by-value-from-another-field-in-Set-Analysis/m-p/392364#M488055 beeaj2011 2013-02-01T07:27:53Z Re: Replace field value by value from another field in Set Analysis https://community.qlik.com/t5/QlikView/Replace-field-value-by-value-from-another-field-in-Set-Analysis/m-p/392365#M488056 <HTML><HEAD></HEAD><BODY><P>Why don'y you build a table that links counties and currencies? This is the easiest way to solve the problem.</P></BODY></HTML> Fri, 01 Feb 2013 08:24:54 GMT https://community.qlik.com/t5/QlikView/Replace-field-value-by-value-from-another-field-in-Set-Analysis/m-p/392365#M488056 alexandros17 2013-02-01T08:24:54Z Re: Replace field value by value from another field in Set Analysis https://community.qlik.com/t5/QlikView/Replace-field-value-by-value-from-another-field-in-Set-Analysis/m-p/392366#M488057 <HTML><HEAD></HEAD><BODY><P>Hi Alexandros</P><P></P><P>I already have that table, I need it because I calculated a specific country as best performing and I need to compare that max country with selections therefor I need to point to that specific country in my SET Analysis.</P><P>I will attach an example I an few moments</P></BODY></HTML> Fri, 01 Feb 2013 08:31:32 GMT https://community.qlik.com/t5/QlikView/Replace-field-value-by-value-from-another-field-in-Set-Analysis/m-p/392366#M488057 beeaj2011 2013-02-01T08:31:32Z Re: Replace field value by value from another field in Set Analysis https://community.qlik.com/t5/QlikView/Replace-field-value-by-value-from-another-field-in-Set-Analysis/m-p/392367#M488058 <HTML><HEAD></HEAD><BODY><P>please find attached an example</P></BODY></HTML> Fri, 01 Feb 2013 09:06:56 GMT https://community.qlik.com/t5/QlikView/Replace-field-value-by-value-from-another-field-in-Set-Analysis/m-p/392367#M488058 beeaj2011 2013-02-01T09:06:56Z Re: Replace field value by value from another field in Set Analysis https://community.qlik.com/t5/QlikView/Replace-field-value-by-value-from-another-field-in-Set-Analysis/m-p/392368#M488059 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>Managed to find a workaround by placing a 1 before my Set Selection. Thanx to the great book of Barry Harmsen : Qlikview for Developers a real recommandation...</P><P></P><P>Stil curious about the solution by the way</P></BODY></HTML> Fri, 01 Feb 2013 09:21:53 GMT https://community.qlik.com/t5/QlikView/Replace-field-value-by-value-from-another-field-in-Set-Analysis/m-p/392368#M488059 beeaj2011 2013-02-01T09:21:53Z