Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Clearing user selections, based off drop down list?

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

2 Replies
mikael_bjaveclo
New Contributor II

Clearing user selections, based off drop down list?

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

Not applicable

Clearing user selections, based off drop down list?

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.