there is a way to use in a formula a value already calculate in another column ?
A B C
60 50 10
where C is A-B..
Since both in Column A e B there are big expression behind, and it will be really massive to calculate again for the column C,
there is some way to say in the expression for Column C --> Column(A) - Column (B)
thanks for any helps
unfortunately the issues is not this one.. I tried and nothing happens.
Are we sure that should work for both QS and QV?
I am using QS
Have just had a play around with it, and as per the Qlik documentation, it doesn't work on dimension values, just measures.. Could that be the issue?
"Column() returns the value found in the column corresponding to ColumnNo in a straight table, disregarding dimensions. For example Column(2) returns the value of the second measure column."