Pivot table problem

[#1]

Hi,I need your help..

I've created a pivot table.

The table have dimension "KPI name" that's have a number as key.

Also have "company name" as the dimension.

The expression is matched by the KPI key.

KPI_ID	KPI Name
1	PPM Arkal
2	CPM Arkal

KPI_ID	CalYear
1	Sum(PRR_Qty)*1000000 / Sum(Sales_Qty)
2	sum(PRR_Qty)

this is the table:

it is empty, as you can see..

when I'm choosing a KPI like this:

the table is fine, but only show what i chose:

but when i'm not choosing the table is empty

in the expression, when i write: CalYear it's works but it puts only the string as it is: sum(PRR_Qty)

when im write: $(=CalYear ) its working only when im choosing KPI 😕

why this is happening? your help is appreciated. thank you and have a nice day.

[Gysbert_Wassenaar]

Can you post a small qlikview document that shows what you're trying to do?