topic Re: expression and label in QlikView

expression and label

souadouert — Wed, 19 Apr 2017 13:52:51 GMT

Good morning

I have a simple table, with several expressions, I have expressions whose label is an expression also.

So sometimes in the table an expression is composed by another expression.

In case the label is an expression I can not use the name of the expresion when it is expression

for example:

exp1:='Realisation ' & MAX(MONTHNUM) & '/' &(Max(YEAR)-1 )

exp2:='Realisation ' & MAX(MONTHNUM) & '/' &(Max(YEAR) )

exp:=exp1/exp2

Can I find a solution ?! To note the expression

stigchel — Wed, 19 Apr 2017 14:19:28 GMT

I tried and it worked for me, something like this

[$(='Realisation ' & MAX(MONTHNUM) & '/' &(Max(YEAR)-1 ))]/

[$(='Realisation ' & MAX(MONTHNUM) & '/' &(Max(YEAR) ))]

Whether you should want that is another question, you could also use e.g. Column(1)/Column(2)

souadouert — Wed, 19 Apr 2017 14:29:46 GMT

hello ,

i tried yr solution and doesnt work

Otherwise I did not understand, column1 / column2

klausskalts — Wed, 19 Apr 2017 14:31:07 GMT

You could also use the Column(1)/Column(2) option .... if it's column 1 and 2

souadouert — Wed, 19 Apr 2017 14:32:10 GMT

Piet thx piet i undrstand yr proposition (function colmn (nb)

souadouert — Wed, 19 Apr 2017 14:32:48 GMT

yes , i fixed the solution with the column funtion thx

stigchel — Wed, 19 Apr 2017 14:37:55 GMT

I may have missed a ')' , the one that closes the dollar sign expansion $(=Exp)

souadouert — Wed, 19 Apr 2017 14:44:45 GMT

you are right Piet thx a ')' missed