Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello there, community
I have the followining issue:
I updated the metrics and dimensions in the back end of my report, but after this optimization, the bookmarks used by the users are not working as expected. The bookmarks work partially, without getting the changed dimensions/measures.
For instance, I have this bookmark code:
{<App={'MobiOffice'},%analyze={'Ad-hoc report'},%dimension={'A/B test group','Billing period'},[%measure.New purchases]={'Intro-price purchases','Direct purchases','$ Direct purchases','New purchases','$ New purchases'},[%measure.Totals & RC]={'$ Total'}/* MISSING VALUES */>}
The commented part 'MISSING VALUES' is the part I want to see what is actually inside it. I tried to bring back an older version of the report and this way we got some of the missing dimensions and measures, but not all of them. This way I found out that in the 'MISSING VALUES' Qlik actually stores something inside and when it is present it gets it and puts it back in the bookmark.
Here is what I see in the bookmark settings:
My question is how can I find what is inside this commented section "MISSING VALUES"?
I hope I explained everything in detail. If you need any further detail for resolving this issue, I will be more than happy to provide.
I found an interesting alternative solution. I copied the binary file on PROD server and moved it to DEV server. After that I linked the file to an old version of my RepositoryApp file. As soon as I established the connection I was able to see all of the bookmarks code.
I guess I was able to see the bookmarks code since I copied the binary file of the live version published on PROD. If you want to duplicate the live version on PROD and work on it, you won't be able to see the bookmarks created by the users.
After that it was just an easy work of updating the bookmarks. Please feel free to ask questions if you need any further clarification. I will be more than happy to help.
@Chanty4u In the future I will try your solution, but at this time the alternative was working in this case for me. Thank you for your time
May be have a look on below steps
Use Dev Hub –> Single Configurator or Engine API Explorer
Go to https://<your-qlik-sense-server>/dev-hub/engine-api-explorer/
Use GetBookmark or GetObject method on the bookmark ID.
This will return the full layout, including selections and potentially the unresolved field names/values.
I found an interesting alternative solution. I copied the binary file on PROD server and moved it to DEV server. After that I linked the file to an old version of my RepositoryApp file. As soon as I established the connection I was able to see all of the bookmarks code.
I guess I was able to see the bookmarks code since I copied the binary file of the live version published on PROD. If you want to duplicate the live version on PROD and work on it, you won't be able to see the bookmarks created by the users.
After that it was just an easy work of updating the bookmarks. Please feel free to ask questions if you need any further clarification. I will be more than happy to help.
@Chanty4u In the future I will try your solution, but at this time the alternative was working in this case for me. Thank you for your time