Referencing another row in a table

[c_gilbert]

Please can anyone help, we currently have a straight table with the 'Ward' as the dimension, and results and RAG ratings as the expressions.

For some results, the wards have joint data, but we don't want to duplicate the data at the source, we just want to base the RAG rating of one ward on another ward.

For example, here is a very simple representation of what we have now. At the moment Ward1b is showing red as there is no data, but we want it to show green, as Ward1a is green.

Ward	Result	RAG rating
Ward1a	90%	Green
Ward1b	-	Red

And this is what we want to get to:

Ward	Result	RAG rating
Ward1a	90%	Green
Ward1b	Joint Ward	Green

Any help would be much appreciated

[c_gilbert]

No one?

[#3]

Hi

How do you make the link between Ward1a and 1b ?

Chris

[jvishnuram]

Hi c_gilbert,

If possible can you share the qvw.

[tresesco]

Probably you can get it using peek()/previous() in the script, or above() in the chart. Please create a sample table (in excel or inline load) and explain the expected output with some 10-15 rows.

[c_gilbert]

Sorry I can't share the qvw.

But basically, we have the different indicators as the expressions along the top, and the wards as the dimension down the side. For some indicators, there is data for both wards, but for others, they submit data jointly under one ward ID.

It's hard to explain but I appreciate any help. Thank you.

[c_gilbert]

I'll try to create some dummy data in a qvw that I can share, thank you.

[c_gilbert]

Hopefully this makes more sense.

In the last table, I have forced it to show what I want it to show, but we want a way of doing this automatically, so that whatever the performance is for the 'main' ward, it will show the same in the 'joint' ward for Indicator_2.

[jvishnuram]

Hi c_gilbert,

Refer the output or result table in the attached qvw.

[c_gilbert]

Thanks but this doesn't work when the wards are re-ordered (in the full document there are around 100 wards, and users can sort by any indicator or ward.