problem with set analysis expression from file

[souadouert]

I prepared my expression in an excel file, and I tested them,

after I load the expresion, always there is a problem synthaxe I think even if I tested the expression

[YoussefBelloum]

Hi,

Make a screen shot of your excel file (the expression part)

[souadouert]

hello youssef,

[YoussefBelloum]

did you try this ?

=$(=Only({<desc_expression={'conquete2'}>} EXPRESSION))

[souadouert]

i have to use the variable conquete2 and not expression beacause qlikview interpret expression as string

[souadouert]

[marcus_sommer]

Your variable-name and the if-check contained a special char - e with upper "hat" - maybe there is a general problem with it or something related to collation: Search - But what shall you find?.

- Marcus

[Peter_Cammaert]

In the situation of your original screenshots, what was the content of variable Conquête2?

Remember that $-sign substitution is performed before the object is recaclulated, Therefor, ysing $-sign substitution you cannot influence the actual expression on a row-by-row basis. 

[souadouert]

Conquête2=

COUNT({<  CLIENT_ENTREE={"CONQUETE"},CLIENT_PRE_SOUS_SEGMENT_A,CLIENT_PRE_SEGMENT_A,CLIENT_PRE_SEGMENT_A={"TRE"}>}CLE)

[Peter_Cammaert]

And if you put

=$(Conquête2)

in a text box, then does it display a hyphen, and error message or a value?