topic Chart does not show selected row in alternative state when select from macro in QlikView

Chart does not show selected row in alternative state when select from macro

Wed, 11 Nov 2015 23:14:06 GMT

Hi experts,

I am trying to make a selection using run macro.

It worked when I am in default state and using following script

ActiveDocument.Fields("Member").Select "(100000|1000001)"

But if doesn't do the selection if I update my sheet to be a specific Alternative State. The script I used was the following.

ActiveDocument.Fields("Member","State_Sampling").Select "(100000)"

Could anyone give me some advice to see what I didn't do right?

Thanks

marcus_sommer — Thu, 12 Nov 2015 09:00:05 GMT

Maybe only the select-criteria isn't correct and it should be:

.Select 100000 instead of .Select "(100000)"

another possibility is a typo by the state-name.

- Macus

Thu, 12 Nov 2015 13:39:06 GMT

yea, it seemed there were some incorrectness in my script originally. I tried it again then it worked. providing the correct code below

ActiveDocument.Fields(v_Identifer, v_StateName).Select "(" & str & ")"