Calculation best practices

[#1]

I am working on a solution that uses a pivot table.  The overall solution may only show 6 or 7 calculations on the row member.  However, to get to these 6 or 7, it will require 10-12 calculations.  Instead of embedding all of these calculations into a handful of calculations, I thought I would create the calcs separately.  I can create the calculations, but they show up on the pivot table.  I dont see an option to hide them.

What is the best practice for creating sub calculations on a pivot table?

Thanks,

Joe

[danielrozental]

Only straight allow for columns to be hidden, pivot tables do not.

Another idea you might want to consider is using variables, then instead of referring to a particular column you can reffer to a variable.

[#3]

Thanks for responding Dan.  Qlikview is still really new to me so some of the concepts havent completely sunk in.  By variable, do you mean specifying it in the script?    here is a calulation I have:

avg( aggr(distinct sum({1<MEASURE_KEY={9}>} Value), SCENARIO_DESC, MONTH,DEPT_NAME) )

I keep getting error messages when I try to embed it in the script.  The error refers to not knowing what aggr is.  I am assuming this is because aggr functions are not allowed in the script.

[danielrozental · Accepted solution]

by variables I mean, Settings>Variable Overview.

Aggr is not a script function, only an expression (front end) function.

[#5]

I was able to figure it out.  Thanks for the reply Daniel