topic Re: problem with set analysis expression from file in QlikView

problem with set analysis expression from file

souadouert — Mon, 18 Dec 2017 10:53:11 GMT

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

Re: problem with set analysis expression from file

YoussefBelloum — Mon, 18 Dec 2017 11:11:00 GMT

Hi,

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

Re: problem with set analysis expression from file

souadouert — Mon, 18 Dec 2017 11:18:48 GMT

hello youssef,

Re: problem with set analysis expression from file

YoussefBelloum — Mon, 18 Dec 2017 11:28:12 GMT

did you try this ?

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

Re: problem with set analysis expression from file

souadouert — Mon, 18 Dec 2017 11:36:49 GMT

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

Re: problem with set analysis expression from file

souadouert — Mon, 18 Dec 2017 11:41:43 GMT

Re: problem with set analysis expression from file

marcus_sommer — Mon, 18 Dec 2017 11:46:52 GMT

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

Re: problem with set analysis expression from file

Peter_Cammaert — Mon, 18 Dec 2017 11:59:55 GMT

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.

Re: problem with set analysis expression from file

souadouert — Mon, 18 Dec 2017 12:09:30 GMT

Conquête2=

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

Re: problem with set analysis expression from file

Peter_Cammaert — Mon, 18 Dec 2017 12:17:18 GMT

And if you put

=$(Conquête2)

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

Re: problem with set analysis expression from file

souadouert — Mon, 18 Dec 2017 12:21:15 GMT

same problem

Re: problem with set analysis expression from file

souadouert — Mon, 18 Dec 2017 12:23:39 GMT

i changed conquete but the the same problem

Re: problem with set analysis expression from file

Peter_Cammaert — Mon, 18 Dec 2017 12:27:23 GMT

In theory, putting this in that text box should also work:

=$(=Expression)

As long a you have a single value selected in desc_expression at all times...

Re: problem with set analysis expression from file

Peter_Cammaert — Mon, 18 Dec 2017 12:29:14 GMT

Ok, put this in your text box:

='$(Conquête2)'

Re: problem with set analysis expression from file

sunny_talwar — Mon, 18 Dec 2017 12:29:47 GMT

Have you checked the variable overview to see what you get after the variable is loaded?

Re: problem with set analysis expression from file

souadouert — Mon, 18 Dec 2017 12:36:54 GMT

the first is cpnquete and the second expression

Re: problem with set analysis expression from file

souadouert — Mon, 18 Dec 2017 12:43:19 GMT

i used thiis example

Re: problem with set analysis expression from file

souadouert — Mon, 18 Dec 2017 12:44:44 GMT

hello sunny,

the first conquete the second expression

Re: problem with set analysis expression from file

sunny_talwar — Mon, 18 Dec 2017 13:07:07 GMT

What do you see in variable overview?

Re: problem with set analysis expression from file

Peter_Cammaert — Mon, 18 Dec 2017 13:13:06 GMT

Or if you aren't comfortable with the tightly spaced Variable Overview dialog, what does this expression display in a text box:

='$(Conquête2)'