Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using calculated label in expression

Hello all,

Can somebody help me with this. I now it's out there, but i can't find the answer anywhere.

I want to use an expression in an other expression. Now i know i can do this by using the label of the first expression in the second. But what if the label of my expression is calculated (lets say my expression has the label "=count(TaskID)") how can i use this expression in an other expression?

6 Replies
Not applicable
Author

Hi tom,

u can put this expression in variable and use any where,any time u want.

let v1=count(TaskID)

now example usage in some expression say to increment:

=$(v1)+1


jonathandienst
Partner - Champion III
Partner - Champion III

I think the answer is to use Column(n) in place of the column label.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

and where can i see the column nr?

jonathandienst
Partner - Champion III
Partner - Champion III

It is the expression number (counting from the top) in the Properties | Expresssions tab. Starting with 1.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

in column label give ColumnNo
use "ColumnNo" in any expression  uwant.

else in a chart say u have 2 expressions; 1st expression is always column(1),2nd always column(2)...so, in 2 nd expression type"=column(1)+any calculation u wanna make" .

Not applicable
Author

n tat is working tom u can c in the attachment below@column_1.pngtom