topic Re: Server bookmark in set analysis is not working in QlikView

Server bookmark in set analysis is not working

francisco_marti — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone.

I want to make a set analysis sum with a bookmark located and created in the server.

I know that I can use this type of formula in set analysis:

Sum({Server\BM01}Sales),

in my case it would be:

=sum({Server\BM65-220} CA_COMMANDE)

The BM65-220 is a bookmark created by a user in the AccesPoint and shared to everyone.

But my result is 0.

I tried to replace 'Server' by 'MyServerName' but it didn't work.

I tried =sum({Server\BM65} CA_COMMANDE) also.

Can anyone help me, please?

Thank you.

sunny_talwar — Thu, 30 Aug 2018 11:28:50 GMT

Did you try putting the bookmark name within square brackets

=sum({[Server\BM65]} CA_COMMANDE)

francisco_marti — Mon, 10 Sep 2018 14:34:50 GMT

Sorry by the delay.

Yes, I put square brackets and unfortunately didn't work.

Thank you for your advise.

francisco_marti — Fri, 16 Nov 2018 09:53:11 GMT

Qlik Support told me that I had to put the name of the bookmark instead the internal name. That simple.

For instance: sum({Server\BM65} CA_COMMANDE) is wrong.

Right: sum({Server\TheNameYouGiveToTheBookmark} CA_COMMANDE) .

Regards.