Discussion Board for collaboration related to QlikView Deployment.
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).
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").ClearEnd Sub
Sub ClearYear() ActiveDocument.Fields("Year").ClearEnd Sub
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.