Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
souadouert
Contributor III

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
Honored Contributor

Re: big problem with variable and set analysi expression

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)','@','$');

31 Replies

Re: big problem with variable and set analysi expression

Can you paste expression?

Life is so rich, and we need to respect to the life !!!
pradosh_thakur
Honored Contributor II

Re: big problem with variable and set analysi expression

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

Learning never stops.
souadouert
Contributor III

Re: big problem with variable and set analysi expression

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 )

Re: big problem with variable and set analysi expression

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 )

Life is so rich, and we need to respect to the life !!!
souadouert
Contributor III

Re: big problem with variable and set analysi expression

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

souadouert
Contributor III

Re: big problem with variable and set analysi expression

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

Re: big problem with variable and set analysi expression

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

Re: big problem with variable and set analysi expression

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.

Re: big problem with variable and set analysi expression

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

Life is so rich, and we need to respect to the life !!!
Community Browser