Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Expression Calculation - Variable name

Column Calculation.png

Hi i have the following scenario whereby i have used my variables as headerlines.

i would now like to make a calculation based on these two expressions

ie. (Expression1- Expression2)/ Expression1

can these expressions be used as Column1 and Column2, i have such complex names because of the the variables that it doesnt work.

Best,

Brad

2 Replies
juleshartley
Valued Contributor

Re: Expression Calculation - Variable name

Hi,

I'm not sure I understand your requirement. Do you want to use the columns of the pivot table in other expressions? If so then you can use the shortcut of '=Column(1)' for example - although I'd be wary of this approach as it breaks if you move the column order.

jvitantonio
Valued Contributor III

Re: Expression Calculation - Variable name

Of course you can. In your case Column 1 = vDate_From.... and Column 2 = Date(VDate_From...

In variance do: (column(1) - Column(2))/Column(1)

Community Browser