Replace field value by value from another field in Set Analysis

[beeaj2011]

Hi

I've got a question, problably straightforward but I cannot find it myself.

I have got a datamodel with a field for Country and Currecy.

I want to have a dynamic formula structured like:

Sum ({<Currency_Code = {'EUR'} , COUNTRY = {'$(vMaxSI)'} >} COUNTER)

I need the hardcoded {'EUR'} part  top be pickedup by the definition of COUNTRY which is calculated.

Thanx for your help.

Ton

[sujeetsingh]

Hey please explain in brief!!!!!

[beeaj2011]

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..

[alexandros17]

Why don'y you build a table that links counties and currencies? This is the easiest way to solve the problem.

[beeaj2011]

Hi Alexandros

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.

I will attach an example I an few moments

[beeaj2011]

please find attached an example

[beeaj2011 · Accepted solution]

Hi All

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...

Stil curious about the solution by the way