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: 
souadouert
Specialist
Specialist

big problem with variable and set analysi expression

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


capture1.PNG

1 Solution

Accepted Solutions
stigchel
Partner - Master
Partner - Master

Instead of loading the expression with dollar signs you can load for example with @ first and then replace them when assigning to the variables, in example:

Set _varName=vExpression;

Set _varValue=Sum({<Year={"@(=Max(Year))"}>} Value);

Let [$(_varName)] =Replace('$(_varValue)','@','$');

View solution in original post

31 Replies
Anil_Babu_Samineni

Can you paste expression?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
pradosh_thakur
Master II
Master II

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

Learning never stops.
souadouert
Specialist
Specialist
Author

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 )

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
souadouert
Specialist
Specialist
Author

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

souadouert
Specialist
Specialist
Author

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
Specialist
Specialist
Author

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,


Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
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?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)