topic Clearing user selections, based off drop down list? in QlikView

Clearing user selections, based off drop down list?

Mon, 26 Jan 2026 18:19:17 GMT

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

Clearing user selections, based off drop down list?

mikael_bjaveclo — Mon, 21 Feb 2011 13:03:49 GMT

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

Clearing user selections, based off drop down list?

Mon, 21 Feb 2011 13:07:09 GMT

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.