Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.