Discussion Board for collaboration on QlikView Scripting.
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
exp1:='Realisation ' & MAX(MONTHNUM) & '/' &(Max(YEAR)-1 )
exp2:='Realisation ' & MAX(MONTHNUM) & '/' &(Max(YEAR) )
Can I find a solution ?! To note the expression
Go to Solution.
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)
i tried yr solution and doesnt work
Otherwise I did not understand, column1 / column2
You could also use the Column(1)/Column(2) option .... if it's column 1 and 2
Piet thx piet i undrstand yr proposition (function colmn (nb)
yes , i fixed the solution with the column funtion thx
I may have missed a ')' , the one that closes the dollar sign expansion $(=Exp)
you are right Piet thx a ')' missed