Set analysis field in place of variable

[martynlloyd]

In my script I have a table:

Charts:

LOAD * Inline [

_Chart, _ChartKPI

C01 Penetration, S8

C02 QC, V1

C03 Variance, V11

C04 Performance, V7

C08 Submission, V4

C09 Referral, V9

C10 Refusal, V5

];

List type is set to select only 1 value

In the chart I have expression:

if(GetSelectedCount(KPIMonth)>0, sum({$<KPIID={V1}>} ResultValue), sum({$ <KPIID={V1}, KPIMonth={Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec}>} ResultValue))

I want to replace the constant V1 with field _ChartKPI.

I have looked at several posts, tried $ expansion, but can't find a solution.

Regards,

Marty.

[Gysbert_Wassenaar · Accepted solution]

sum({$<KPIID={'$(=only(_ChartKPI))'}>} ResultValue) should work as long as your Charts table is a data island and only one value of _Chart or _ChartKPI is selected .

[martynlloyd]

That's what I thought, but I get No data to display.

If I put  ='$(=only(_ChartKPI))' in a text boxt, I get the correct value, if I use a constant, it works.

It's driving me nuts, I need a better strategy for debuging this problem.

[Gysbert_Wassenaar]

Can you post the offending document or an example that demonstrates the problem?

[martynlloyd]

strange thing - I created a new chart from scratch and it works.