List Box Problem

[senpradip007]

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

PR@D!P

[er_mohit]

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.....

[senpradip007]

Many thanks for reply.

Can this problem be sorted out using Macro?

[#4]

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