# 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?

Tags (4)
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.

now example usage in some expression say to increment:

=\$(v1)+1

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

## 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@tom