topic Re: Expression showing different on server in QlikView

Expression showing different on server

wallerjc — Mon, 09 May 2016 11:43:31 GMT

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.

Re: Expression showing different on server

Gysbert_Wassenaar — Tue, 10 May 2016 08:06:19 GMT

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.

Re: Expression showing different on server

Colin-Albert — Tue, 10 May 2016 08:13:55 GMT

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])

Re: Expression showing different on server

wallerjc — Tue, 10 May 2016 08:59:37 GMT

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

Re: Expression showing different on server

kamal_sanguri — Tue, 10 May 2016 09:08:33 GMT

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

Re: Expression showing different on server

kamal_sanguri — Wed, 11 May 2016 11:23:40 GMT

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".