topic Re: Using calculated label in expression in QlikView

Using calculated label in expression

Thu, 25 Jun 2015 10:31:24 GMT

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?

Re: Using calculated label in expression

Thu, 25 Jun 2015 10:37:53 GMT

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

Re: Using calculated label in expression

jonathandienst — Thu, 25 Jun 2015 10:43:57 GMT

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

Re: Using calculated label in expression

Thu, 25 Jun 2015 10:56:40 GMT

and where can i see the column nr?

Re: Using calculated label in expression

jonathandienst — Thu, 25 Jun 2015 10:59:16 GMT

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

Re: Using calculated label in expression

Thu, 25 Jun 2015 11:15:17 GMT

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" .

Re: Using calculated label in expression

Thu, 25 Jun 2015 11:21:28 GMT

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