Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Did you try putting the bookmark name within square brackets
=sum({[Server\BM65]} CA_COMMANDE)
Sorry by the delay.
Yes, I put square brackets and unfortunately didn't work.
Thank you for your advise.
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.