Error Nestet aggregation

[Newhaven]

Hi!

I have this script:

set HidePrefix = '#';


LanguageList:
Load * Inline [
Index, 	Deutsch, 		English,		Italiano				
1,		Haus, 			House, 			Casa
2, 		Holz,			Wood,			Legna						
];


Let vLanguage = 'MinString(#LANGUAGE)' ;

Language:
CrossTable (Language, Translation) load
Index,
Deutsch,
English,
Italiano
Resident LanguageList;

LaguageList:
Load Distinct Language as #LANGUAGE
Resident Language
where Language > 0;

drop Table Language;

In analyse I create a textfield with a code (and select only one language)

=Only({<Index = {1}>} $(vLanguage))

then I get the error: Nested aggregation not allowed

Where is my mistake?

Thx

[maheshkuttappa]

What the result are you trying to get?  if need to nest aggregation you need to use the Aggr function or you can use the solution in the screenshot using the variable language _1 , its global variable 

[rwunderlich]

I believe your expression should be:

=MinString({<Index = {1}>} #LANGUAGE)

[Newhaven]

Sorry, forget zu explain 🙂

I have a table with my languages (#LANGUAGE)

If I now select  for example Italiano,  I would like to have the result casa in my text field (inline table Index 2, Language Italiano)

[Newhaven]

Sorry, dosn't work. 

Please see previous post.

[vincent_ardiet_]

Why are you putting #LANGUAGE in a data island? Why dont' you keep it in the table [Language]? This would simplify.