Capture a value from chart and pass it to another chart
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.
