Discussion Board for collaboration on QlikView Scripting.
I would like to create a macro that automatically selects values in a chart based on a variable's value.
I have a variable called Status that has a value of either A, B, C, or D. This variable is used as a dimension in a straight table chart.
When I run my macro, I would like to select lines in my chart where Status has a value of A or B. I have tried several different variations of the macro below, but it is not working.
arr1 = Array("A", "B")
Seems like it should be fairly straightforward. Any thoughts about how I can get this macro to work?
You need a loop to read the array-values:
for i = 0 to ubound(arr1) - 1
But what is the reason for this routine?
Thanks for the response Marcus, but that does not seem work either. The edit module window opens whenever I run the macro.
I am trying to add a few buttons to my Qlikview doc that allow me to quickly switch between different views of my chart, rather than selecting each field from a list or menu.
Is it possible to accomplish this without using an array?