Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
This discussion may be easy to all of you as I'm new in qlikview.
Suppose I select a List Box named Year. What I want, when I will select another List Box named Month the Year List Box should be deselected.
Can any one help me to get rid of this problem.....
Thanks in advance
hi
it works on OR gate..
like if you select year then corresponding assosiation made on month when you select month then you can't deselect
another option using AND mode list box.
i attached the file may be helpful to you.....
Many thanks for reply.
Can this problem be sorted out using Macro?
Yes you can.
1) Go to the module and create a Sub vbscrip:
Sub Test
ActiveDocument.Fields ("Year"). Clear
End Sub
2) Go to the menu:
Settings, Document Properties,
Triggers tab and locate the month field in the "Event Triggers field."
Click on the field and click the "Select By" and create an action type "External Run Macro."
In the Macro Name field enter the name of the SUB in this case is "Test".
So, whenever you select any value in the month, the year field will be cleared.
God bless you!
Stive
Brazil