Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
beeaj2011
Contributor III
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
Contributor III
Contributor III
Author

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

View solution in original post

6 Replies
sujeetsingh
Master III
Master III

Hey please explain in brief!!!!!

beeaj2011
Contributor III
Contributor III
Author

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
Partner - Champion III
Partner - Champion III

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

beeaj2011
Contributor III
Contributor III
Author

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

please find attached an example

beeaj2011
Contributor III
Contributor III
Author

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