Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Make a screen shot of your excel file (the expression part)
hello youssef,
did you try this ?
=$(=Only({<desc_expression={'conquete2'}>} EXPRESSION))
i have to use the variable conquete2 and not expression beacause qlikview interpret expression as string
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
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.
Conquête2=
COUNT({< CLIENT_ENTREE={"CONQUETE"},CLIENT_PRE_SOUS_SEGMENT_A,CLIENT_PRE_SEGMENT_A,CLIENT_PRE_SEGMENT_A={"TRE"}>}CLE)
And if you put
=$(Conquête2)
in a text box, then does it display a hyphen, and error message or a value?