Capture a value from chart and pass it to another chart

Wed, 13 Apr 2011 07:06:18 GMT

I have a pivot table that depeneds on another chart on the same sheet, when clicking on a fact in the strait table a a condition depend on this fact should populate the pivot table, as an example :

If the below KPIs are available on he strait table

KPI1 KPI2 KPI3

A1 2 4 5

A2 6 7 8

where KPI1 for A1 is calculated as follows:

if(Y1=3,Sum(x1/X2,0)

then when I click on A1:KPI1 the pivot table should show

A1 X1

A1 X2

I am new on Qlikview , and I am sure it is doable but I am having some hard time trying capture caption of a strait table and formulate a condition to filter the pivot table, any suggestions.

Regards,

Zaid.

topic Capture a value from chart and pass it to another chart in QlikView

Capture a value from chart and pass it to another chart