Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
souadouert
Specialist
Specialist

expression and label

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

1 Solution

Accepted Solutions
stigchel
Partner - Master
Partner - Master

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)

View solution in original post

7 Replies
stigchel
Partner - Master
Partner - Master

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
Specialist
Specialist
Author

hello ,

i tried yr solution and doesnt work

tab.PNG

Otherwise I did not understand, column1 / column2

klausskalts
Partner - Creator
Partner - Creator

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

souadouert
Specialist
Specialist
Author

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

souadouert
Specialist
Specialist
Author

yes , i fixed the solution with the column funtion thx

stigchel
Partner - Master
Partner - Master

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

souadouert
Specialist
Specialist
Author

you are right Piet thx a ')' missed