Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

beeaj2011
New Contributor III

Replace field value by value from another field in Set Analysis

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




1 Solution

Accepted Solutions
beeaj2011
New Contributor III

Re: Replace field value by value from another field in Set Analysis

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

6 Replies
sujeetsingh
Honored Contributor III

Re: Replace field value by value from another field in Set Analysis

Hey please explain in brief!!!!!

beeaj2011
New Contributor III

Re: Replace field value by value from another field in Set Analysis

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

Re: Replace field value by value from another field in Set Analysis

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

beeaj2011
New Contributor III

Re: Replace field value by value from another field in Set Analysis

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
New Contributor III

Re: Replace field value by value from another field in Set Analysis

please find attached an example

beeaj2011
New Contributor III

Re: Replace field value by value from another field in Set Analysis

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

Community Browser