Clearing user selections, based off drop down list?

[#1]

Hi All,

Is it possible to get Qlikview to remove the selections in a particular selections table, depending on the user selected variable from a drop down listing?

ie on the attached QV doc, I have both a "Year" and "Month" selections table.

if the user selects "Year", I would like to have all the monthly selections removed (and vice versa).

Please advise,

Kind regards,

Rich

[mikael_bjaveclo]

You could call a macro, by "Field Event Trigger" on selection.
A selcetion in the field "Month" should call the rotuine "ClearYear" and vice verse...

Sub ClearMonth()
ActiveDocument.Fields("Month").Clear
End Sub

Sub ClearYear()
ActiveDocument.Fields("Year").Clear
End Sub

[#3]

Hey Rich,

I have added two buttons 'Annual' and 'Monthly' instead of variable input.

On click of theses buttons you will get the appropriate selections.

Just check the attched app, It might help you.

Regards,

Cherub.