expression for dimensions with hierarchies

Wed, 18 Jun 2014 15:22:50 GMT

Hello

I have an expression that can take in three types of indicators

-CUM : which is the sum on a selected period of a value

-FDP: which has to return the maximum of the value on a selected period

-MOY: which has to return the average of the value on a selected period

the indicators are presented in a hierarchy, there for, for each indicator (on every level) there is a precalculcated value.

the periods are also in a hyerarchies. we decided to split the values by indicators and period so that we have the right value, but the problem happens when we reduce the columns of the pivot table (the dimension [Indicateur niveau] or [PERIODE_DESC]) it sums on a all the columns which it shouldn't.

for example

in image 1 the the indicator is split by period , so it gives the right values,

but if we reduce Encours Bilan FDP ( which is an indicator of the type 'FDP'), it gives the sum on the months and the trimester which is wrong

Thank you in advance for your help

topic expression for dimensions with hierarchies in QlikView

expression for dimensions with hierarchies