Expression showing different on server

[wallerjc]

Hi All,

I have this expression which is working fine locally:

     =Only({$<Name={$(Selected)}>} [Demographics.Hobbies])

I'm hoping you can see what this is doing.

Locally this gives the result:

PIC1

but this exact same object on the server seems to return null:

PIC2

Has anyone experienced something similar or can point me in the right direction for troubleshooting?

Thanks,

James.

[Gysbert_Wassenaar]

Make sure the documents contain the same data in both environments. And check that $(Selected) returns the same value in both environments. The only() function will only return a value if exactly one value is possible. In other cases you'll get a null.

[Colin-Albert]

Does your document have Section Access?

If yes, is the Distribution Service account included in the section access table with Admin access and no restrictions on data values?

You could try using maxstring instead of only as only will return null if there is more than 1 value returned.

=MaxString({$<Name={$(Selected)}>} [Demographics.Hobbies])

[wallerjc]

Hi thanks for your input.

I have verified the $(Selected) variable returns the same on both instances. Further, if I change the expression to remove the variable:

=Only({$<Name={'James'}>} [Demographics.Hobbies])

I get the same result

[kamal_sanguri]

Hi,

This can be because of Alternate state.. I have past experience of that, where a chart was looking absolutely fine on desktop.. but it wasn't visible at all in Access Point.

Thanks,

-Kamal

[kamal_sanguri · Accepted solution]

I think, I wasn't clear enough.. Just want you to right click on object>> go to properties and in General Tab.. look for the alternate state (If you don't see Alternate state that means.. you have not created any alternate state..) and see what it is set to.. as in this case it is set to "inherited".