topic Re: List Box Problem in QlikView

Re: List Box Problem

senpradip007 — Thu, 24 Jan 2013 05:09:46 GMT

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

er_mohit — Thu, 24 Jan 2013 05:23:22 GMT

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 — Thu, 24 Jan 2013 05:52:52 GMT

Many thanks for reply.

Can this problem be sorted out using Macro?

Thu, 24 Jan 2013 11:59:43 GMT

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