topic Calculation best practices in QlikView

Calculation best practices

Mon, 18 Jul 2011 20:10:49 GMT

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

Calculation best practices

danielrozental — Mon, 18 Jul 2011 20:14:48 GMT

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.

Calculation best practices

Mon, 18 Jul 2011 21:11:10 GMT

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.

Calculation best practices

danielrozental — Tue, 19 Jul 2011 21:06:59 GMT

by variables I mean, Settings>Variable Overview.

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

Calculation best practices

Tue, 19 Jul 2011 21:08:33 GMT

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