Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hey please explain in brief!!!!!
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..
Why don'y you build a table that links counties and currencies? This is the easiest way to solve the problem.
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
please find attached an example
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