big problem with variable and set analysi expression

[souadouert]

HELLO,
I still have problems with the expression set download from a file, the expression gives the right result using direct in a table,

but when I download it since file does not work, I removed the $ and used TOTAL, and nothing has changed

[Anil_Babu_Samineni]

Can you paste expression?

[pradosh_thakur]

you need to be more clear with your requirement and as anil said please paste the expression.

[souadouert]

sum({<ANNEE = {"=Max(TOTAL (ANNEE))"}, MOIS,  MOIS = {"<= MAX(TOTAL(MOIS))"} , DATE_SITUATION,CREDIT_NATURE={"CONSO"},CLIENT_PRE_SEGMENT_A={"HAUT DE GAMME"}>} CREDIT_MONTANT_PRODUCTION )

[Anil_Babu_Samineni]

May be problem due to one field to degrade using multi times

sum({<ANNEE = {"=ANNEE=Max(TOTAL ANNEE)"}, MOIS = {"<=MAX(TOTAL MOIS)"} , DATE_SITUATION,CREDIT_NATURE={"CONSO"},CLIENT_PRE_SEGMENT_A={"HAUT DE GAMME"}>} CREDIT_MONTANT_PRODUCTION )

[souadouert]

Anil expression is correct when i used directly in expression , and when i put this expresion in variable didnt work

[souadouert]

look this exemple with $ :
um(TOTAL{<ANNEE = {$(=Max(ANNEE))}, MOIS,  MOIS = {"<= $(=MAX(MOIS))"} , DATE_SITUATION,CREDIT_NATURE={"CONSO"},CLIENT_PRE_SEGMENT_A={"CLASSE MOYENNE"}>} CREDIT_MONTANT_PRODUCTION )

[souadouert]

um(TOTAL{<ANNEE = {$(=Max(ANNEE))}, MOIS,  MOIS = {"<= $(=MAX(MOIS))"} , DATE_SITUATION,CREDIT_NATURE={"CONSO"},CLIENT_PRE_SEGMENT_A={"CLASSE MOYENNE"}>} CREDIT_MONTANT_PRODUCTION )

[PrashantSangle]

try below

sum({<ANNEE = {"$(=Max(TOTAL ANNEE))"}, MOIS,  MOIS = {"<= $(=MAX(TOTALMOIS))"} , DATE_SITUATION,CREDIT_NATURE={"CONSO"},CLIENT_PRE_SEGMENT_A={"HAUT DE GAMME"}>} CREDIT_MONTANT_PRODUCTION )

Regards,

[Anil_Babu_Samineni]

That means, Let's assume your variable called Var1 and expression contains same. Are you going to use Using Parameter level or Plain variable?