For the first one (Test1 and Test2), if you want to sum all values when tab is not expanded you should use sum:
if(ReferredYYYY=2014, Sum([SA1 Target Total 2014]),
if you only put the name of a field, when there are multiple values, qlikview returns null.
For the seconf one (Test3), I don't know how to make a conditional dimension based on a dimension created using a value list, my choice is tho create a data_island (table not connected to any other table) with the name of metrics, so you can create a calculated dimension like:
If(Metric='Test3', null(), HospitalGroup)
Hope this helps.
test.qvw 146.8 K