Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: Using calculated label in expression

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


MVP
MVP

Re: Using calculated label in expression

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

Re: Using calculated label in expression

and where can i see the column nr?

MVP
MVP

Re: Using calculated label in expression

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

Re: Using calculated label in expression

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

Re: Using calculated label in expression

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

Community Browser