topic Re: set analysis problem in QlikView

set analysis problem

souadouert — Fri, 12 May 2017 09:21:19 GMT

I have a problem with an expression set analysis, I want this test

dituationdate=(maxyear)-1 '&-12'

-->sum({<SITUATION_PRODUIT={$(=Max(YEAR)-1)&"-12"}>}REAL_TITRES.ENCOURS_TITRES)

It does not work always show the expression in red

Anonymous — Fri, 12 May 2017 09:23:51 GMT

why do you need dituationdate, but use SITUATION_PRODUIT ?

swuehl — Fri, 12 May 2017 09:24:45 GMT

So you want to create something like '2016-12' ?

Try

sum({<SITUATION_PRODUIT={"$(=(Max(YEAR)-1) & '-12')"} >} REAL_TITRES.ENCOURS_TITRES)

Anonymous — Fri, 12 May 2017 09:28:31 GMT

Im not sure if this makes any difference as long as there are no spaces within the search string?!?

I don't trust in the syntax checker

I just tried it:

LOAD * INLINE [

012016

022016

];

--> this works even without quotes:

But as soon as there's a "-" a space or any other "special sign" in the search string you'll need single or double quotes.

So I admit I was wrong...

swuehl — Fri, 12 May 2017 09:35:54 GMT

There should be a difference, since in the OP, the dollar sign expansion stops after -1.

The concatenation thereafter is not a valid syntax.

souadouert — Fri, 12 May 2017 09:44:13 GMT

i used this expression ,But the result is always null

swuehl — Fri, 12 May 2017 09:45:53 GMT

How do the values of field SITUATION_PRODUIT look like?

For example,post a screenshot of a list box.

souadouert — Fri, 12 May 2017 09:48:28 GMT

thank y Stefan , i fixed the problem

souadouert — Fri, 12 May 2017 10:08:59 GMT

thank y Robin i fixed the problem , hank y for yr help