Pivot table drill down

Thu, 22 Sep 2011 13:32:04 GMT

Hi all,

i try to explain my problem:

My data consist of a hierarchy: AREA -> FCS -> KPI -> Indicatore (hierarchy is shown below in picture)

i want to create a pivot table like this:

the expression is not the same for all level of hierarchy because of the PESO (PESO in english means "weight") that change for each level, so the column where is insert the expression must change dinamycally in base of deep of the drill down/up. I mean: first case

the expression must be multiply for PESO of AREA_ID

second case:

the expression must be multiply for PESO of FCS_ID

third case:

the expression must be multiply for PESO of KPI_ID

and so on...

any suggestion?

THX

Pivot table drill down

Wed, 05 Oct 2011 08:00:17 GMT

i think i need a function like getselectedcount()>0 that told me when user click on plus of the table so i can condition the formula in expression... any suggestion?

topic Pivot table drill down in QlikView

Pivot table drill down

Pivot table drill down