-
Re: Can I insert a trigger by a macro...?
Tamil arasu May 31, 2016 12:16 PM (in response to Luciano Anselmetti)Hi Luciano,
You can try this.
Sub Test
Set Selections = ActiveDocument.Fields("Field1").GetSelectedValues(10000)
ActiveDocument.Fields("Field2").SelectValues Selections
End Sub
-
Re: Can I insert a trigger by a macro...?
Luciano Anselmetti Jun 1, 2016 5:08 AM (in response to Tamil arasu )Thanks Tamil,
Is useful, but I have seen that using field selection triggered macros, they not run in full browser mode. For this I used the shadow select suggested in Re: Forcing selection in listbox according to item selection in other listbox with macro.
Then, with a command button, in a macro I will scan columns of chart (pivot) to check if identifier is selected in subtotal tables and activate it if yes.
Regards
Luciano
-
-
Re: Can I insert a trigger by a macro...?
Marcus Sommer Jun 1, 2016 4:40 AM (in response to Luciano Anselmetti)I think you don't need this macro- and action-stuff for this and in general you should avoid it if possible: Macros are Bad. There are various approaches available how users could choose their dimensions and expressions for an object and if you want to extend it to features which are not directly conditionally controllable like subtotals / partial sums you create for each chooseable dimensions two - one one and one without the subtotals.
User Controlled Charts In QlikView
Customisable Straight (and Pivot) Tables - more food for thought
- Marcus
-
Re: Can I insert a trigger by a macro...?
Luciano Anselmetti Jun 1, 2016 5:42 AM (in response to Marcus Sommer )Hi Marcus,
thanks for suggestion and links tha are very interesting; I will study them.
My dubt about 2 columns for measure approach is that if the user move a column, when apply subtotals the column is hide and is showed one which is in original position.
Regards
Luciano
-
Re: Can I insert a trigger by a macro...?
Marcus Sommer Jun 1, 2016 6:29 AM (in response to Luciano Anselmetti)If you don't want that the users could move the columns you could disable these option within the tab presentation. But I think you should not much worry about it - qlikview is extremly easy to use and the basics, like they could move columns, expand/collapse columns and how they could find and select values and their meaning (logic of green, white and grey) are not very difficult (otherwise would be qlikview the wrong tool and maybe static pdf's more suitable).
- Marcus
-
Re: Can I insert a trigger by a macro...?
Luciano Anselmetti Jun 1, 2016 6:46 AM (in response to Marcus Sommer )Yes Marcus,
the chart is a dynamic controlled pivot and the user has full control on it. For this, when the user move a column for grouping a dimension, if he/she enable subtotals on this column, it is probable that the pivot goes in a unwanted condition, hiding the moved column and showing another that is (if never moved) in original position...
Is for this reason that I have preferred macro for enable/disable subtotals.
Thanks again
Luciano
-
Re: Can I insert a trigger by a macro...?
Marcus Sommer Jun 1, 2016 9:21 AM (in response to Luciano Anselmetti)Some years ago I have played with such macro-stuff on subtotals, formatting, column-widths and so on to be more flexible but it's complicated, won't work within AJAX client and slowed down the response-times and therefore didn't used it in productive (like above mentioned I use dimensions twice for one dimension to be able to switch between subtotal or not and it worked well).
- Marcus
-
-
-
-