Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

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
Luminary Alumni
Luminary Alumni

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)