Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a question regarding using macros in Qlik.
I know how to select a value from a certain field using a macro with VBScript language, but i want to select multiple values.
Also i would like to know if i can reduce data using macros( the equivalent of reduce data from file menu ).
Go to Solution.
you can do it withToggleSelect:
<pre>sub multi_selectActiveDocument.Fields("Field1").Select "a"ActiveDocument.Fields("Field1").ToggleSelect "b"end sub
Check out those APIs:
If you are not already using QlikView API Guide, I highly recommend it - it's under Program Files\QlikView\Documentation\ folder.
Thank you very much!
Have a nice day!
I will look up for those!
How do I exclude only 1 value from a certain field ?
I am trying to make a a selection from a list box which has an expression in it.
I generally use the below syntax to select values from list box:-
Set Qv = CreateObject("QlikTech.QlikView")
Set QvDoc = Qv.OpenDoc("<QV_File_location>")
Set fz = QvDoc.Fields("objectname")
for each v in listbox3
But whenever I try to access an expression from a list box, it will have an objectID but wont have an object name ? How can I solve for this problem ?