topic Re: Qlikview, strange behavior with bookmarks and macros in QlikView

Qlikview, strange behavior with bookmarks and macros

castro88 — Thu, 15 Feb 2024 14:23:42 GMT

Hi,
one of our customers has a strange problem with using bookmarks and macros on a QlikView application via AccessPoint.
I'll try to explain myself, starting with the case that works.

If I access the application with the user who is also the user of the services (I don't know if it can be useful as information) everything works. In detail: I access the sheet where there is a ListBox for choosing the dimensions and measures to represent in the table, I choose dimensions and measures and select, again via the ListBox, for which dimensions to enable the totals in the Pivot table. This last selection is managed by a macro. At this point, if I create a bookmark while the totals view is active, close and reopen the application by selecting the previously created bookmark, my pivot table presents the data with the total.
If I log in to the application with any other user and follow the same steps, once I apply the bookmark I do not see the totals. It does this behavior with all users except the service user.
I attach some images.
Let me know if you need any other information.
Thanks

Re: Qlikview, strange behavior with bookmarks and macros

Brian_C — Thu, 15 Feb 2024 14:12:51 GMT

Can I ask is the bookmark you created a document bookmark and therefore available to all users or a user bookmark available only to the user who created it?

Re: Qlikview, strange behavior with bookmarks and macros

castro88 — Thu, 15 Feb 2024 14:16:11 GMT

Hi Brian,

each user creates his own bookmark, they are not shared.

Re: Qlikview, strange behavior with bookmarks and macros

igoralcantara — Thu, 15 Feb 2024 14:20:35 GMT

How does the macro contribute to the display of the totals? Do you have section access? Also, have you try with any other admin or high privilege user? Does it work? When does it not work, is for one user only or any user that is not the services account?

Re: Qlikview, strange behavior with bookmarks and macros

Or — Thu, 15 Feb 2024 14:23:52 GMT

Macros aren't meant to work in Ajax mode, so the only surprise here is that it's working for the service user...

https://support.qlik.com/articles/000045380

Re: Qlikview, strange behavior with bookmarks and macros

castro88 — Thu, 15 Feb 2024 14:25:59 GMT

Yes, there is section access.
The problem affects all users, ADMIN and USER, it only works with the service user.

Re: Qlikview, strange behavior with bookmarks and macros

igoralcantara — Thu, 15 Feb 2024 14:27:11 GMT

I recommend replacing the macro with something else. Can you post the macro code for us to take a look?

Re: Qlikview, strange behavior with bookmarks and macros

castro88 — Thu, 15 Feb 2024 14:31:37 GMT

Yes, sure.
Unfortunately it is a macro that we inherited, the comments are in German which is not my language.

sub MOSTRATOTALI dim chart, prop, dims, pSums, str, i, j 'Variablen deklarieren set doc = ActiveDocument set pSums = doc.Fields("DIMENSION_TOTAL").getSelectedValues 'selektierte Werte vom Auswahlfeld in ein Array einlesen set chart = doc.GetSheetObject("CH53") 'Pivot auswählen prop = chart.GetProperties 'Zugriff auf Eigenschaften set dims = prop.Dimensions 'Auswahl der Dimensionseigenschaften for i = 0 to dims.Count - 1 'Pivotdimensionen durchlaufen und auslesen dims(i).ShowPartialSums = false 'für alle Dimensionen die Teilergebnisse rausnehmen for j = 0 to pSums.Count - 1 'selektierte Werte des Auswahlfeldes werden durchlaufen und ausgelsen if dims.Item(i).Title.v = pSums.Item(j).Text then dims(i).ShowPartialSums = true 'Vergleich des Auslesens + setzen des Teilergbenis next 'str = str & dims.Item(i).Label.v & chr(10) next chart.SetProperties prop 'Zuweisung der Sichtbarkeiten für die Teilergebnisse für die Dimensionseigenschaften der Pivot set doc = nothing 'Variablen löschen set pSums = nothing set chart = nothing set dims = nothing end sub

Re: Qlikview, strange behavior with bookmarks and macros

igoralcantara — Thu, 15 Feb 2024 14:40:33 GMT

Ok, let's go one step at a time. I know a little German, so here is your macro with the comments in English:

Sub MOSTRATOTALI

Dim chart, prop, dims, pSums, str, i, j 'Declare variables

Set doc = ActiveDocument
Set pSums = doc.Fields("DIMENSION_TOTAL").getSelectedValues 'Read selected values from the selection field into an array

Set chart = doc.GetSheetObject("CH53") 'Select the pivot table
prop = chart.GetProperties 'Access properties
Set dims = prop.Dimensions 'Select dimension properties

For i = 0 To dims.Count - 1 'Loop through pivot dimensions and read them
dims(i).ShowPartialSums = False 'Remove partial sums for all dimensions
For j = 0 To pSums.Count - 1 'Loop through selected values from the selection field and read them
If dims.Item(i).Title.v = pSums.Item(j).Text Then dims(i).ShowPartialSums = True 'Compare read + set partial result
Next
Next

chart.SetProperties prop 'Assignment of visibilities for partial results for the dimension properties of the pivot

Set doc = Nothing 'Delete variables
Set pSums = Nothing
Set chart = Nothing
Set dims = Nothing

End Sub

Second a few ideas to do the same without using a macro:

1. Use Variables and Button States: Create variables that represent the selected values in your selection field. Then use these variables in the expressions of your pivot table to filter the data. You can use buttons to allow the user to select values and update the variables accordingly.

2. Use Conditional Selections in QlikView: You can use conditional expressions in the properties of your pivot table to control the display of subtotals based on the selected values in your "DIMENSION_TOTAL" field.

These approaches can help you achieve the same result without needing to use macros.

Re: Qlikview, strange behavior with bookmarks and macros

David_Friend — Thu, 15 Feb 2024 14:55:02 GMT

https://community.qlik.com/t5/Official-Support-Articles/Considerations-When-Using-Macros-In-QlikView/ta-p/1710861

Re: Qlikview, strange behavior with bookmarks and macros

castro88 — Thu, 15 Feb 2024 15:21:08 GMT

Thank you.
I only have one doubt on the second point, I don't see any settings for conditional expressions in partial sums in the graph tab. Am I understanding wrong?

Re: Qlikview, strange behavior with bookmarks and macros

cwolf — Fri, 16 Feb 2024 23:10:02 GMT

Cascading actions triggered by events are executed by the server at different levels.

If the user make a selection in the field "ShowTotals", the macro runs on level 1.

A bookmark is nothing more than an event that triggers actions. The selection triggered by the bookmark in the field "ShowTotals" is executed at level 1, the macro triggered by this selection now is executed at level 2.

But this is not allowed per default! On Ajax client a user can only run actions on level 1, no higher levels. The service user has no limits!

To get it work for all users you have to increase the MaxActionLevel on the Server:

Stop the server service.

Open the file:

c:\ProgramData\QlikTech\QlikViewServer\Settings.ini

Add the line

MaxActionLevel=2

to section [Settings 7].

Start the server service.

Now it should works for all users.